DB2 V9.5 经常出现以下异常,都是因为DB2的驱动包版本问题,大家碰到子类问题可以首先考虑驱动包版本的原因。
驱动包:db2java.jar db2jcc.jar db2jcc_license_cu.jar
异常:【encoding not supported】
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: encoding not supported!!
下面的异常主要是使用了 with ur 导致:
异常:【com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=with;esc,a.task_name desc;), DRIVER=3.52.95】
com.linkage.bace.core.reflect.exception.ReflectionError: invoke method 'queryIndexTaskList' with arguments []
at com.linkage.bace.core.reflect.method.Invoker.invoke(Invoker.java:59)
at com.linkage.bace.core.db.MCTransaction.execute(MCTransaction.java:104)
at com.linkage.bace.core.m.DBModuler.execute(DBModuler.java:55)
at com.linkage.bace.core.act.MCActioner.executeCallMethod(MCActioner.java:140)
at com.linkage.bace.core.act.MCActioner.execute(MCActioner.java:64)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at com.linkage.bace.core.act.MCRequestProcessor.process(MCRequestProcessor.java:93)
at com.linkage.bace.core.act.MCActionServlet.process(MCActionServlet.java:56)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.linkage.bi.util.SystemInfoFilter.doFilter(SystemInfoFilter.java:216)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.linkage.bace.core.reflect.method.Invoker.invoke(Invoker.java:57)
... 25 more
Caused by: com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=with;esc,a.task_name desc;), DRIVER=3.52.95
at com.ibm.db2.jcc.a.ad.a(ad.java:666)
at com.ibm.db2.jcc.a.ad.a(ad.java:60)
at com.ibm.db2.jcc.a.ad.a(ad.java:127)
at com.ibm.db2.jcc.a.rl.c(rl.java:2424)
at com.ibm.db2.jcc.a.rl.d(rl.java:2401)
at com.ibm.db2.jcc.a.rl.a(rl.java:1902)
at com.ibm.db2.jcc.t4.db.g(db.java:138)
at com.ibm.db2.jcc.t4.db.a(db.java:38)
at com.ibm.db2.jcc.t4.t.a(t.java:32)
at com.ibm.db2.jcc.t4.sb.h(sb.java:141)
at com.ibm.db2.jcc.a.rl.Y(rl.java:1873)
at com.ibm.db2.jcc.a.sl.bc(sl.java:2526)
at com.ibm.db2.jcc.a.sl.e(sl.java:3227)
at com.ibm.db2.jcc.a.sl.Ob(sl.java:569)
at com.ibm.db2.jcc.a.sl.executeQuery(sl.java:543)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at com.linkage.bace.ibatis.IbatisDAO.handlerForArray(IbatisDAO.java:254)
at com.linkage.bace.ibatis.IbatisDAO.queryJdbc(IbatisDAO.java:140)
at com.linkage.bace.core.m.atom.PagerModuler.queryRowNumber(PagerModuler.java:209)
at com.linkage.bace.core.m.atom.PagerModuler.wrapperSql(PagerModuler.java:100)
at com.linkage.bace.core.m.atom.PagerModuler.wrapperUid(PagerModuler.java:60)
at com.linkage.bace.core.m.atom.PagerModuler.<init>(PagerModuler.java:44)
at com.linkage.bi.powershow.query.QueryListModule.queryIndexTaskList(QueryListModule.java:205)
... 29 more