org.hibernate.exception.GenericJDBCException: could not execute query

[mukulgoel]

Hi ,

I am using jboss 7.2 alpha

when i am trying to access database i am getting this error

I am using the same application on Websphere as well as tomcat and it works fine so it should be some configuration issues

below is the stack trace

17:09:29,652 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   ERROR [http-localhost/127.0.0.1:8080-4] (com.csc.fs.logging.Log4JHandler:logError:190)  - 2012/07/09 17:09:29.652: Error : ERROR : mukul:MBean fscSA:name=AWD not compliant

17:09:30,289 INFO  [stdout] (http-localhost/127.0.0.1:8080-4) Length Header : [0][0][0][50]

17:09:31,004 INFO  [stdout] (http-localhost/127.0.0.1:8080-4) Interpreted Stream Length  : 15741

17:09:32,905 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   DEBUG [http-localhost/127.0.0.1:8080-4] (com.csc.fs.logging.Log4JHandler:logXML:260)  - 2012/07/09 17:09:32.905: ServiceDelegator : XML : :process event final result [<process-step-result><outcome>selectRole</outcome><result-params><has-errors><![CDATA[false]]></has-errors><error></error><PROCESS_STACK><![CDATA[openSession.SelectRoles$$]]></PROCESS_STACK><PersistElements><systems><![CDATA[[CLIENT-DB, XMLG, CyberLifeWS, Hibernate, CyberLifeWS_VSAM, AWD]]]></systems><User><![CDATA[mukul]]></User><roles><![CDATA[[Manager, FullRep, PolAdminRep, loaderRunner, Agent, CustomerService.Level1Analyst, PolOwnerService.Level1Analyst, Approver, AgentFull, OfflineUser, PolOwnerService.ReadOnly]]]></roles></PersistElements><Session><![CDATA[USK:F66F72A2086748424000AA5C5E81CD9E/ 

17:09:32,906 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   ]]></Session><successInd><![CDATA[success]]></successInd><outcome><![CDATA[success]]></outcome><SingleRole><![CDATA[false]]></SingleRole><LogonActionResult><![CDATA[success]]></LogonActionResult></result-params></process-step-result>]

17:09:37,269 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   DEBUG [http-localhost/127.0.0.1:8080-4] (com.csc.fs.logging.Log4JHandler:logXML:260)  - 2012/07/09 17:09:37.268: ServiceDelegator : XML : mukul:process event final result [<process-step-result><outcome>coordinatorDesktop</outcome><result-params><has-errors><![CDATA[false]]></has-errors><error></error><PROCESS_STACK><![CDATA[openSession.SelectRoleSuccess$$coordinatorDesktop.CoordinatorDesktop$$]]></PROCESS_STACK><PersistElements><roleID><![CDATA[FullRep]]></roleID></PersistElements><Session><![CDATA[USK:F66F72A2086748424000AA5C5E81CD9E/ 

17:09:37,269 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   ]]></Session><SelectRoleActionResult><![CDATA[success]]></SelectRoleActionResult><successInd><![CDATA[success]]></successInd><outcome><![CDATA[success]]></outcome></result-params></process-step-result>]

17:09:44,873 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   DEBUG [http-localhost/127.0.0.1:8080-4] (com.csc.fs.logging.Log4JHandler:logXML:260)  - 2012/07/09 17:09:44.872: ServiceDelegator : XML : mukul:process event final result [<process-step-result><outcome>customerDesktopBlank</outcome><result-params><PROCESS_STACK><![CDATA[openSession.SelectRoleSuccess$$coordinatorDesktop.CoordinatorDesktop$$customerDesktopBlank.customerDesktopBlank$$]]></PROCESS_STACK><Session><![CDATA[USK:F66F72A2086748424000AA5C5E81CD9E/ 

17:09:44,873 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   ]]></Session></result-params></process-step-result>]

17:09:46,557 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   DEBUG [http-localhost/127.0.0.1:8080-4] (com.csc.fs.logging.Log4JHandler:logXML:260)  - 2012/07/09 17:09:46.556: ServiceDelegator : XML : mukul:process event final result [<process-step-result><outcome>locateCustomer</outcome><result-params><PROCESS_STACK><![CDATA[openSession.SelectRoleSuccess$$coordinatorDesktop.CoordinatorDesktop$$customerDesktopBlank.customerDesktopBlank$$searchCustomer.NoMatches$$]]></PROCESS_STACK><Session><![CDATA[USK:F66F72A2086748424000AA5C5E81CD9E/ 

17:09:46,557 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   ]]></Session></result-params></process-step-result>]

17:09:56,148 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   ERROR [http-localhost/127.0.0.1:8080-4] (com.csc.fs.logging.Log4JHandler:logError:190)  - 2012/07/09 17:09:56.148: Error : ERROR : mukul:MBean fscSA:name=Hibernate not compliant

17:10:01,499 ERROR [stderr] (http-localhost/127.0.0.1:8080-4) org.hibernate.exception.GenericJDBCException: could not execute query

17:10:01,500 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)

17:10:01,500 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)

17:10:01,500 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

17:10:01,500 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.doList(Loader.java:2231)

17:10:01,500 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)

17:10:01,500 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.list(Loader.java:2120)

17:10:01,500 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)

17:10:01,501 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)

17:10:01,501 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)

17:10:01,501 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)

17:10:01,501 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.accel.interaction.services.SearchPartyService.invoke(SearchPartyService.java:357)

17:10:01,501 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.InteractionHandlerAccel.process(InteractionHandlerAccel.java:53)

17:10:01,501 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.SystemAccessBase.invokeInteraction(SystemAccessBase.java:374)

17:10:01,501 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.SystemAccessBase.internalInvoke(SystemAccessBase.java:242)

17:10:01,502 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.SystemAccessBase.invoke(SystemAccessBase.java:55)

17:10:01,502 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.om.ObjectAccessExtImpl.retrieveDirect(ObjectAccessExtImpl.java:1195)

17:10:01,502 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.AccelService.retrieve(AccelService.java:199)

17:10:01,502 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.service.AccelRetrieveService.execute(AccelRetrieveService.java:29)

17:10:01,502 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.AccelService.execute(AccelService.java:108)

17:10:01,502 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

17:10:01,502 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

17:10:01,503 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

17:10:01,503 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at java.lang.reflect.Method.invoke(Unknown Source)

17:10:01,503 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.ServiceHandler.invoke(ServiceHandler.java:59)

17:10:01,503 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.AccelService.callService(AccelService.java:1087)

17:10:01,503 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.process.SearchPartyBP.process(SearchPartyBP.java:27)

17:10:01,503 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.AccelBP.process(AccelBP.java:62)

17:10:01,503 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

17:10:01,504 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

17:10:01,504 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

17:10:01,504 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at java.lang.reflect.Method.invoke(Unknown Source)

17:10:01,504 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.service.ServiceControllerBP.process(ServiceControllerBP.java:54)

17:10:01,504 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.service.ServiceControllerAbstract.internalExecute(ServiceControllerAbstract.java:278)

17:10:01,504 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.service.ServiceControllerAbstract.execute(ServiceControllerAbstract.java:197)

17:10:01,504 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.delegate.DirectServiceController.execute(DirectServiceController.java:61)

17:10:01,505 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.delegate.ServiceDelegateDirect.execute(ServiceDelegateDirect.java:70)

17:10:01,505 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.BaseServiceAction.execute(BaseServiceAction.java:187)

17:10:01,505 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.action.customer.services.CustomerSearchBase.performSearch(CustomerSearchBase.java:107)

17:10:01,505 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.action.customer.services.CustomerLocate.perform(CustomerLocate.java:38)

17:10:01,505 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.ServiceDelegator.execute(ServiceDelegator.java:506)

17:10:01,505 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.BeanBase.executeAction(BeanBase.java:816)

17:10:01,505 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at pagecode.customer.services.CustomerSearch.submit(CustomerSearch.java:913)

17:10:01,506 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

17:10:01,506 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

17:10:01,506 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

17:10:01,506 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at java.lang.reflect.Method.invoke(Unknown Source)

17:10:01,506 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.el.parser.AstValue.invoke(AstValue.java:264)

17:10:01,506 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)

17:10:01,506 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68)

17:10:01,507 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)

17:10:01,507 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

17:10:01,507 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.component.UICommand.broadcast(UICommand.java:315)

17:10:01,507 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

17:10:01,507 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

17:10:01,507 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)

17:10:01,507 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)

17:10:01,508 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)

17:10:01,508 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

17:10:01,508 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

17:10:01,508 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

17:10:01,508 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.filters.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:82)

17:10:01,508 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

17:10:01,508 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

17:10:01,509 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

17:10:01,509 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

17:10:01,509 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)

17:10:01,509 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

17:10:01,509 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

17:10:01,509 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

17:10:01,509 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

17:10:01,510 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

17:10:01,510 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

17:10:01,510 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679)

17:10:01,510 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931)

17:10:01,510 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at java.lang.Thread.run(Unknown Source)

17:10:01,510 ERROR [stderr] (http-localhost/127.0.0.1:8080-4) Caused by: com.ibm.db2.jcc.b.SqlException: [jcc][t4][10199][10462][3.50.152] Required character converter is not available. ERRORCODE=-4220, SQLSTATE=null

17:10:01,510 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.wc.a(wc.java:55)

17:10:01,511 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.wc.a(wc.java:119)

17:10:01,511 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.bc.a(bc.java:1758)

17:10:01,511 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.bc.n(bc.java:496)

17:10:01,511 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.bc.P(bc.java:1689)

17:10:01,511 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.jk.e(jk.java:1174)

17:10:01,511 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.jk.getObject(jk.java:1156)

17:10:01,511 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.jk.getObject(jk.java:1429)

17:10:01,511 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.jboss.jca.adapters.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:1199)

17:10:01,512 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.usertypes.AccelString.nullSafeGet(AccelString.java:71)

17:10:01,512 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:128)

17:10:01,512 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1121)

17:10:01,512 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:588)

17:10:01,512 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.doQuery(Loader.java:724)

17:10:01,512 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

17:10:01,512 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.doList(Loader.java:2228)

17:10:01,512 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           ... 71 more

17:10:01,513 INFO  [stdout] (http-localhost/127.0.0.1:8080-4)   ERROR [http-localhost/127.0.0.1:8080-4] (com.csc.fs.logging.Log4JHandler:logError:190)  - 2012/07/09 17:10:01.513: com.csc.fs.sa.accel.interaction.services.SearchPartyService : ERROR : mukul:SearchParty DataService invoke() error - could not execute query

17:10:01,514 ERROR [stderr] (http-localhost/127.0.0.1:8080-4) org.hibernate.exception.GenericJDBCException: could not execute query

17:10:01,514 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)

17:10:01,514 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)

17:10:01,515 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

17:10:01,515 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.doList(Loader.java:2231)

17:10:01,515 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)

17:10:01,515 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.list(Loader.java:2120)

17:10:01,515 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)

17:10:01,515 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)

17:10:01,515 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)

17:10:01,515 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)

17:10:01,516 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.accel.interaction.services.SearchPartyService.invoke(SearchPartyService.java:357)

17:10:01,516 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.InteractionHandlerAccel.process(InteractionHandlerAccel.java:53)

17:10:01,516 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.SystemAccessBase.invokeInteraction(SystemAccessBase.java:374)

17:10:01,516 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.SystemAccessBase.internalInvoke(SystemAccessBase.java:242)

17:10:01,516 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.sa.SystemAccessBase.invoke(SystemAccessBase.java:55)

17:10:01,516 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.om.ObjectAccessExtImpl.retrieveDirect(ObjectAccessExtImpl.java:1195)

17:10:01,516 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.AccelService.retrieve(AccelService.java:199)

17:10:01,517 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.service.AccelRetrieveService.execute(AccelRetrieveService.java:29)

17:10:01,517 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.AccelService.execute(AccelService.java:108)

17:10:01,517 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

17:10:01,517 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

17:10:01,517 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

17:10:01,517 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at java.lang.reflect.Method.invoke(Unknown Source)

17:10:01,517 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.ServiceHandler.invoke(ServiceHandler.java:59)

17:10:01,517 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.AccelService.callService(AccelService.java:1087)

17:10:01,518 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.process.SearchPartyBP.process(SearchPartyBP.java:27)

17:10:01,518 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.AccelBP.process(AccelBP.java:62)

17:10:01,518 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

17:10:01,518 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

17:10:01,518 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

17:10:01,518 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at java.lang.reflect.Method.invoke(Unknown Source)

17:10:01,518 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.service.ServiceControllerBP.process(ServiceControllerBP.java:54)

17:10:01,518 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.service.ServiceControllerAbstract.internalExecute(ServiceControllerAbstract.java:278)

17:10:01,519 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.service.ServiceControllerAbstract.execute(ServiceControllerAbstract.java:197)

17:10:01,519 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.delegate.DirectServiceController.execute(DirectServiceController.java:61)

17:10:01,519 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.delegate.ServiceDelegateDirect.execute(ServiceDelegateDirect.java:70)

17:10:01,519 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.BaseServiceAction.execute(BaseServiceAction.java:187)

17:10:01,519 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.action.customer.services.CustomerSearchBase.performSearch(CustomerSearchBase.java:107)

17:10:01,519 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.action.customer.services.CustomerLocate.perform(CustomerLocate.java:38)

17:10:01,519 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.ServiceDelegator.execute(ServiceDelegator.java:506)

17:10:01,520 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.BeanBase.executeAction(BeanBase.java:816)

17:10:01,520 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at pagecode.customer.services.CustomerSearch.submit(CustomerSearch.java:913)

17:10:01,520 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

17:10:01,520 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

17:10:01,520 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

17:10:01,520 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at java.lang.reflect.Method.invoke(Unknown Source)

17:10:01,520 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.el.parser.AstValue.invoke(AstValue.java:264)

17:10:01,521 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)

17:10:01,521 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68)

17:10:01,521 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)

17:10:01,521 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

17:10:01,521 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.component.UICommand.broadcast(UICommand.java:315)

17:10:01,521 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

17:10:01,521 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

17:10:01,521 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)

17:10:01,522 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)

17:10:01,522 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)

17:10:01,522 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

17:10:01,522 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

17:10:01,522 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

17:10:01,522 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.ui.filters.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:82)

17:10:01,522 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

17:10:01,523 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

17:10:01,523 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

17:10:01,523 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

17:10:01,523 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)

17:10:01,523 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

17:10:01,523 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

17:10:01,523 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

17:10:01,523 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at java.lang.Thread.run(Unknown Source)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4) Caused by: com.ibm.db2.jcc.b.SqlException: [jcc][t4][10199][10462][3.50.152] Required character converter is not available. ERRORCODE=-4220, SQLSTATE=null

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.wc.a(wc.java:55)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.wc.a(wc.java:119)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.bc.a(bc.java:1758)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.bc.n(bc.java:496)

17:10:01,524 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.bc.P(bc.java:1689)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.jk.e(jk.java:1174)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.jk.getObject(jk.java:1156)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.ibm.db2.jcc.b.jk.getObject(jk.java:1429)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.jboss.jca.adapters.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:1199)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at com.csc.fs.accel.usertypes.AccelString.nullSafeGet(AccelString.java:71)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:128)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1121)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:588)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.doQuery(Loader.java:724)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           at org.hibernate.loader.Loader.doList(Loader.java:2228)

17:10:01,525 ERROR [stderr] (http-localhost/127.0.0.1:8080-4)           ... 71 more

i am attaching hibernate.cfg.xml for referrence. if any other data needed plz tell

[ctomc]

Hi,

problem is with how connection to your database is configured not how hibernate works..

you get exception

com.ibm.db2.jcc.b.SqlException: [jcc][t4][10199][10462][3.50.152] Required character converter is not available. ERRORCODE=-4220, SQLSTATE=null

i would say that there is some error with datasource configuration or problem with permisions.

check with your DBA what this error exacly means.

or try to update db2 driver to latest version as 3.50 is really old...

--

tomaz

[mukulgoel]

The driver is working fine on other projects running on same version of JBoss.

you mentioned something about permissions.

snippet from my standalone.xml

<datasource jta="true" jndi-name="java:/FSCDS" pool-name="FSCDS_Pool" enabled="true" use-ccm="true">

<connection-url>jdbc:db2://cscappaus027:50000/FSCCSD</connection-url> 

<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class> 

<driver>db2jcc4</driver> 

- <security>

<user-name>clientdbuser</user-name> 

<password>Cl1entDBuser</password>

</security>

- <validation>

<validate-on-match>false</validate-on-match> 

<background-validation>false</background-validation>

</validation>

<statement>

<share-prepared-statements>false</share-prepared-statements>

</statement>

</datasource>

The username and password i am using here. that has all the privilidges (these credentials are being used at many other places) . is there any other sort of permisions ? i was looking up and even created a .java.policy file in my home directory.. ?

[lafr]

This problem lookes similar: https://community.jboss.org/thread/175731.

[mukulgoel]

the it is similar but i am using JBoss 7.2 Alpha1 , which i downloaded today from

http://hudson.jboss.org/hudson/view/JBoss%20AS/job/JBoss-AS-7.0.x/lastBuild/artifact/build/target/

and the inclusion of sun/io has been fixed in Dec`11

ref JIRA https://issues.jboss.org/browse/AS7-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:changehistory-tabpanel

but still I am getting this error

[ctomc]

can you try with debugger to see what classes is are missing if this is similar problem...

and did you try with and more recent db2 jdbc driver?

[mukulgoel]

Tomaz, I dont think its a db2jcc driver issue, because my collegues are using the the same version 3.50 on JBoss As7.0 (the project is same)  and its working fine.

db2jcc driver needs a licence.. so to procure that i cant raise a request until m sure its a driver issue.

Sure. il debug and see what classes are missing

-Thanks

Mukul

[smarlow]

According to http://www.ibm.com/developerworks/forums/thread.jspa?threadID=255663, the error message "Required character converter is not available" is not the actual cause.  Its more about the sun.io classes not being accessible to the DB2 jdbc driver. 

Frank already posted above about the https://community.jboss.org/thread/175731 forum post, which is the same problem and has a solution of having the DB2 driver depend on the "sun.jdk" module.  Try that if you haven't yet.

Scott

[ctomc]

Hey,

how does your module.xml for your driver look like?

you can have both jars (driver + licence) in your module, maybe you are missing just some dependancies...

--

tomaz

[mukulgoel]

Thanks Scott and Tomaz, it was an issue of db2jcc having a missing dependency on sun.io

Warmest Regards

-Mukul