|
版本: |
BeX5V3.1 |
小版本号: |
|
|
|
数据库: |
MS SQLServer |
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
其它(帖子中说明) |
浏览器: |
|
|
|
Bex5.321 开发手机应用,数据库Sql server。
新建了一个表,表里有个Date字段
select fleavealldate from ss_leaveapprchild
.....
查询后用getDate(0)取出这个日期。
String mssql = "select fleavealldate from ss_leaveapprchild where fleaverID = '"+personID+"'";
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(SQL.DEFAULT_DB_NAME,mssql);
Table table = SQL.select(sqlMap, null, dataModel);
Date tmpdate = new Date();
for(Iterator<?> it1 = table.iterator(); it1.hasNext();){
Row r1 = (Row) it1.next();
tmpdate = r1.getDate(0);
。。。。。。。
但app或者PC访问系统,这个getDate方法就出错,后台报错:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl
java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown
Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Sou
ce)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper
alve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContext
alve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
ava:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja
a:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav
:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proc
ss(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:4
9)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: 编码: JUSTEP150138; 提示: 列" fleavealldate"的类型不一致, 定义的类型是"String", 当前给出的是"Date"
at PhysicalMOA.LeaveDateRepeatCheck(PhysicalMOA.java:290)
... 27 more
查了数据库,字段类型没错,数据库中也存的日期,换了getValue(0)方法也不行,同样的出错信息。
请帮忙看看!
|
|