9 Replies Latest reply on Jul 20, 2012 2:47 AM by mukul goel

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

    mukul goel Newbie

      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