烦：DB2 V9.5 ERRORS:[encoding not supported]/[SQLCODE=-104, SQLSTATE=42601]

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