执行SQL报错，求大神指教！！

chnegyannenu 2014-08-27 11:23:04

该SQL用本机访问数据库无问题，用服务器的应用访问就报一下错误！

[INFO ][admin_1410801622342][09:36:59,186]结果集获取sql=select PROVNO,ORG_ID,ORG_NAME,ORG_DESC,ORG_TYPE,ORG_LEVEL,ABOVEPROVNO,ABOVE_ORG_ID,ACCTPROVNO,ACCTORGNO,CCPROVNO,CCORGNO,OUTPROVNO,OUTPROXYORG,INPROVNO,INPROXYORG,PAYSYSBKID,CLEARBKID,INNERPROVNO,INNER_ORG_ID,LINKNM,TEL,EMAIL,ORG_ADRESS,BAK1,BAK2,BAK3,AUTHLOWAMT,AUTHABOVEAMT,CREATETS,UPDATETS from t_org_cnaps order by org_id
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select PROVNO,ORG_ID,ORG_NAME,ORG_DESC,ORG_TYPE,ORG_LEVEL,ABOVEPROVNO,ABOVE_ORG_ID,ACCTPROVNO,ACCTORGNO,CCPROVNO,CCORGNO,OUTPROVNO,OUTPROXYORG,INPROVNO,INPROXYORG,PAYSYSBKID,CLEARBKID,INNERPROVNO,INNER_ORG_ID,LINKNM,TEL,EMAIL,ORG_ADRESS,BAK1,BAK2,BAK3,AUTHLOWAMT,AUTHABOVEAMT,CREATETS,UPDATETS from t_org_cnaps order by org_id ]; SQL state [null]; error code [-99999]; null; nested exception is com.ibm.db2.jcc.b.SqlException
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:433)
at com.hundsun.tamcx.database.JdbcDaoSupport.find(JdbcDaoSupport.java:185)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy0.find(Unknown Source)
at com.hundsun.tamcx.systemx.ext.util.dbUtil.ExtOrgDao.jgInit(ExtOrgDao.java:78)
at com.hundsun.tamcx.systemx.ext.util.dbUtil.ExtOrgDao.<init>(ExtOrgDao.java:44)
at com.hundsun.tamcx.systemx.ext.util.dbUtil.ExtOrgDao.getInstance(ExtOrgDao.java:51)
at com.hundsun.tamcx.systemx.ext.util.dict.TamcDict.tree(TamcDict.java:132)
at com.hundsun.tamcx.systemx.ext.util.dict.TamcDict.exeAjax(TamcDict.java:496)
at com.hundsun.tamcx.systemx.base.AjaxDictServlet.doPost(AjaxDictServlet.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:736)
Caused by: com.ibm.db2.jcc.b.SqlException
at com.ibm.db2.jcc.b.s.a(s.java:1517)
at com.ibm.db2.jcc.b.s.n(s.java:532)
at com.ibm.db2.jcc.b.s.W(s.java:1436)
at com.ibm.db2.jcc.b.kf.a(kf.java:1075)
at com.ibm.db2.jcc.b.kf.getObject(kf.java:1062)
at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:286)
at org.springframework.jdbc.support.JdbcUtils.getResultSetValue(JdbcUtils.java:137)
at org.springframework.jdbc.core.ColumnMapRowMapper.getColumnValue(ColumnMapRowMapper.java:96)
at com.hundsun.tamcx.database.util.CommonRowMapper.mapRow(CommonRowMapper.java:38)
at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:423)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:371)
... 34 more

...全文