2 Replies Latest reply on Dec 17, 2013 9:44 AM by objectiser

    bpel-console logging on error -class com.google.gwt.http.client.RequestException

    hongdaw7

      Hi Team

       

      I have just installed riftsaw-2.3.0.Final with the combination- jboss-5.1.0.GA, jbossesb-4.11, and JDK is jdk1.6.0_45.

      The deploy script is ant deploy -Ddatabase=oracle -Dws.stack=cxf -Dws.version=3.4.0.GA

      Oracle is 11g standalone.

      Installation looks ok without error. but when I logs on http://localhost:8080/bpel-console, there are following error prompted,

       

        HTTP 500:

      HTTP Status 500 -


      type Exception report

      message

      description The server encountered an internal error () that prevented it from fulfilling this request.

       

      The server.log shows,

       

      2013-12-15 16:17:48,219 WARN  [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8080-6) SQL Error: 933, SQLState: 42000

      2013-12-15 16:17:48,221 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8080-6) ORA-00933: SQL command not properly ended

       

      2013-12-15 16:17:48,222 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/gwt-console-server].[Resteasy]] (http-127.0.0.1-8080-6) Servlet.service() for servlet Resteasy threw exception

      org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Failed to execute query

          at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:319)

          at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:230)

          at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:206)

          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:360)

          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)

          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)

          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)

          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 org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

          at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

          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:235)

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

          at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)

          at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

          at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

          at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

          at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

          at java.lang.Thread.run(Thread.java:662)

      Caused by: java.lang.RuntimeException: Failed to execute query

          at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.executeCommand(DefaultBPAFDataSource.java:73)

          at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.getProcessDefinitions(DefaultBPAFDataSource.java:97)

          at org.jboss.soa.bpel.console.ProcessHistoryPluginImpl.getProcessDefinitions(ProcessHistoryPluginImpl.java:114)

          at org.jboss.bpm.console.server.ProcessHistoryFacade.getProcessDefinitionKeys(ProcessHistoryFacade.java:77)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          at java.lang.reflect.Method.invoke(Method.java:597)

          at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)

          at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)

          at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)

          at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)

          at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)

          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)

          ... 28 more

      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

          at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

          at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)

          at org.jboss.bpm.monitor.model.DefaultBPAFDataSource$1.execute(DefaultBPAFDataSource.java:104)

          at org.jboss.bpm.monitor.model.DefaultBPAFDataSource$1.execute(DefaultBPAFDataSource.java:98)

          at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.executeCommand(DefaultBPAFDataSource.java:68)

          ... 41 more

      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)

          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

          at org.hibernate.loader.Loader.doList(Loader.java:2231)

          at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)

          at org.hibernate.loader.Loader.list(Loader.java:2120)

          at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)

          at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)

          at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)

          at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)

          at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)

          ... 44 more

      Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

       

          at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

          at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)

          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

          at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)

          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051)

          at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)

          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156)

          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415)

          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460)

          at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)

          at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)

          at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)

          at org.hibernate.loader.Loader.doQuery(Loader.java:697)

          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

          at org.hibernate.loader.Loader.doList(Loader.java:2228)

          ... 51 more

      2013-12-15 16:17:48,228 ERROR [org.jboss.web.tomcat.service.jca.CachedConnectionValve] (http-127.0.0.1-8080-6) Application error: Resteasy did not complete its transaction

       

      I have added the entry on hibernate.cfg.xml

      <property name="show_sql">true</property>


      But still cannot show the sql statement....could anyone provide any solution on it... it's very appreciative.


      Regards,


      Hongda