java 传参 '[xx,xx] 代码报错
具体脚本
form_data_leng_append_data2zip
我 java 调用这个脚本,传值’的时候,代码就报错。
传参内容:
[2023-06-02 18:24:13]
DEBUG: param1=[“40288170879355a601879359ec1d001c20230602add.ctx”]
[2023-06-02 18:24:13]
DEBUG: param2=[10e8rb44,10e8rb3r,10e8rb3t,10e8rb3v,10e8rb3x,10e8rb3z,10e8rb46,10e8rb48,status,data_time]
[2023-06-02 18:24:13]
DEBUG: param3=[’[“100301001”,“河北省”,“保定市”,“南市区”,“天津分公司”,“保定办事处”,“钦锦汉物美”,“19202305593”,true,“datetime("2023-05-25 10:10:57.469")”]]
具体报错内容:
ERROR 18:24:13 TID: N/A [ExceptionInterceptor:intercept] - updateJsonFormHistoryData
java.sql.SQLException: 单元格 A2 中有错误
表达式:
create(10e8rb44,10e8rb3r,10e8rb3t,10e8rb3v,10e8rb3x,10e8rb3z,10e8rb46,10e8rb48,status,data_time).record(’[“100301001”,“河北省”,“保定市”,“南市区”,“天津分公司”,“保定办事处”,“钦锦汉物美”,“19202305593”,true,“datetime("2023-05-25 10:10:57.469")”])
中表达式:
‘[“100301001”,“河北省”,“保定市”,“南市区”,“天津分公司”,“保定办事处”,“钦锦汉物美”,“19202305593”,true,“datetime("2023-05-25 10:10:57.469")”]
中’不匹配
at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:301)
at com.esproc.jdbc.InternalStatement$1.run(InternalStatement.java:153)
Caused by: com.scudata.common.RQException: 单元格 A2 中有错误
表达式:
create(10e8rb44,10e8rb3r,10e8rb3t,10e8rb3v,10e8rb3x,10e8rb3z,10e8rb46,10e8rb48,status,data_time).record(’[“100301001”,“河北省”,“保定市”,“南市区”,“天津分公司”,“保定办事处”,“钦锦汉物美”,“19202305593”,true,“datetime("2023-05-25 10:10:57.469")”])
中表达式:
’[“100301001”,“河北省”,“保定市”,“南市区”,“天津分公司”,“保定办事处”,“钦锦汉物美”,“19202305593”,true,“datetime("2023-05-25 10:10:57.469")”]
中’不匹配
at com.scudata.expression.Expression.$1(Unknown Source:601)
at com.scudata.expression.Expression.(Unknown Source:109)
at com.scudata.expression.ParamParser.$1(Unknown Source:365)
at com.scudata.expression.ParamParser.parse(Unknown Source:317)
at com.scudata.expression.Function.setParameter(Unknown Source:36)
at com.scudata.expression.MemberFunction.setParameter(Unknown Source:60)
at com.scudata.expression.Expression.$1(Unknown Source:848)
at com.scudata.expression.Expression.$1(Unknown Source:709)
at com.scudata.expression.Expression.$1(Unknown Source:647)
at com.scudata.expression.Expression.(Unknown Source:109)
at com.scudata.expression.Expression.(Unknown Source:81)
at com.scudata.cellset.datamodel.PgmNormalCell.calculate(Unknown Source:151)
at com.scudata.cellset.datamodel.PgmCellSet.$1(Unknown Source:1949)
at com.scudata.cellset.datamodel.PgmCellSet.execute(Unknown Source:2623)
at com.scudata.cellset.datamodel.PgmCellSet.calculateResult(Unknown Source:2666)
at com.scudata.expression.fn.JDBCCall.calculate(Unknown Source:113)
at com.scudata.expression.Expression.calculate(Unknown Source:160)
at com.scudata.expression.fn.Eval.calc(Unknown Source:93)
at com.esproc.jdbc.JDBCUtil.execute(JDBCUtil.java:193)
at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:282)
… 1 more
java 调用不要前面的单引号
’[xx,xx],需要这种写法,api 传 [xx,xx],’怎么书写到上面例子中呢?
ide 中’是用来指明参数的类型是字符串,参数值就是’后面的串,用 api 调用就是传’后面的串
api 增加数据 - 无法识别日期类型
又回到原点了,这个问题怎么解决呢?《api 增加数据 - 无法识别日期类型》