Comments (6)
请问方便发一下调用堆栈吗?
jar包里的文件只能读成InputStream,应该调用LocalFile.getInputStream取输入流
from esproc.
raqsoftConfig.xml 配置文件内容如下:
<?xml version="1.0" encoding="UTF-8"?>
<Config Version="3">
<Runtime>
<DBList>
</DBList>
<Esproc>
<charSet>UTF-8</charSet>
<splPathList>
<splPath></splPath>
</splPathList>
<dateFormat>yyyy-MM-dd</dateFormat>
<timeFormat>HH:mm:ss</timeFormat>
<dateTimeFormat>yyyy-MM-dd HH:mm:ss</dateTimeFormat>
<mainPath></mainPath>
<tempPath></tempPath>
<bufSize>65536</bufSize>
<localHost/>
<localPort>0</localPort>
<parallelNum/>
<cursorParallelNum/>
<blockSize/>
<nullStrings>nan,null,n/a</nullStrings>
<fetchCount/>
<extLibsPath/>
</Esproc>
<Logger>
<Level>OFF</Level>
</Logger>
</Runtime>
<JDBC>
</JDBC>
</Config>
项目结构如下:
src
|---main
|---java
|---resources
|---raqsoftConfig.xml
|---STUDENT_SCORE_LIST.splx
Java 调用 代码如下:
Connection con = null;
java.sql.PreparedStatement st;
try
{
Class.forName("com.esproc.jdbc.InternalDriver");
con= DriverManager.getConnection("jdbc:esproc:local://");
st =con.prepareCall("call STUDENT_SCORE_LIST(?)");
st.setObject(1,"C:/Users/fengm/OneDrive/文档/学生成绩.xlsx");
st.execute();
ResultSet rs = st.getResultSet();
}
catch (Exception e)
{
e.printStackTrace();
}
调用堆栈信息如下:
java.sql.SQLException: 文件 STUDENT_SCORE_LIST 不存在
at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:286)
at com.esproc.jdbc.InternalStatement$1.run(InternalStatement.java:148)
Caused by: com.scudata.common.RQException: 文件 STUDENT_SCORE_LIST 不存在
at com.scudata.app.common.AppUtil.readCellSet(AppUtil.java:798)
at com.scudata.expression.fn.JDBCCall.calculate(JDBCCall.java:70)
at com.scudata.expression.Expression.calculate(Expression.java:143)
at com.scudata.expression.fn.Eval.calc(Eval.java:88)
at com.esproc.jdbc.JDBCUtil.execute(JDBCUtil.java:418)
at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:267)
... 1 more
集算器v2018这个版本是支持这样调用脚本文件的
from esproc.
看异常信息跟最新版的jar包不匹配,我看了一下目前的实现应该没这个错误。
请换最新版的集算器的jar包试一下。
from esproc.
替换了最新版(20220228版本)的jar包,依旧抛出以下错误信息,望请排除,谢谢
java.sql.SQLException: 文件 STUDENT_SCORE_LIST 不存在
at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:286)
at com.esproc.jdbc.InternalStatement$1.run(InternalStatement.java:148)
Caused by: com.scudata.common.RQException: 文件 STUDENT_SCORE_LIST 不存在
at com.scudata.app.common.AppUtil.readCellSet(AppUtil.java:795)
at com.scudata.expression.fn.JDBCCall.calculate(JDBCCall.java:68)
at com.scudata.expression.Expression.calculate(Expression.java:143)
at com.scudata.expression.fn.Eval.calc(Eval.java:88)
at com.esproc.jdbc.JDBCUtil.execute(JDBCUtil.java:418)
at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:267)
... 1 more
from esproc.
替换了最新版(20220228版本)的jar包,依旧抛出以下错误信息,望请排除,谢谢
java.sql.SQLException: 文件 STUDENT_SCORE_LIST 不存在 at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:286) at com.esproc.jdbc.InternalStatement$1.run(InternalStatement.java:148) Caused by: com.scudata.common.RQException: 文件 STUDENT_SCORE_LIST 不存在 at com.scudata.app.common.AppUtil.readCellSet(AppUtil.java:795) at com.scudata.expression.fn.JDBCCall.calculate(JDBCCall.java:68) at com.scudata.expression.Expression.calculate(Expression.java:143) at com.scudata.expression.fn.Eval.calc(Eval.java:88) at com.esproc.jdbc.JDBCUtil.execute(JDBCUtil.java:418) at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:267) ... 1 more
您好,已经找到了问题,刚刚修复提交了。请更新代码后重试,谢谢!
from esproc.
已验证,问题已经修复
from esproc.
Related Issues (20)
- 20230228版本集算器 远程计算出现疑似内存泄漏点 能否确认下 HOT 7
- 简单SQL里有支持pivot么?有样例么? HOT 1
- rename函数bug 远程计算会失败 HOT 2
- fnname函数也存在 rename函数类似的bug HOT 3
- [建议]esProc项目拆分成多模块 HOT 1
- 连接数据库提示Class [com.mysql.jdbc.Driver] is not found. HOT 1
- 集算器采用connect函数直连 连接不上oracle HOT 6
- sqltranslate函数不能正确的翻译 0 参数的函数;例如:TODAY(), NOW() HOT 1
- sqltranslate 无法正确翻译 LEFT(STR, N) 函数 HOT 1
- sqltranslate中 LEFT(str,n) 函数作为其它函数参数未被翻译 HOT 1
- 数据库对象单元格内容明码显示密码
- 数据库对象单元格内容明码显示密码
- 需要一个生成字符型序列的简单方法
- 集算器 spl 出现卡死现象 疑似 使用 Boolean 类型做为锁导致其它线程都出于等待 !!! HOT 3
- 是否支持二进制文件解析,比如stdf HOT 1
- SPL建议增加proxy功能 HOT 3
- 正则表达式匹配出错 HOT 4
- 数据查询异常 HOT 3
- Add Code of Conduct
- Proposal for Contributing Guidelines Documentation
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from esproc.