[jboss-user] [JBoss jBPM] - unable to start a process instance in a console

i tried using database oracle 10g.with jbpm4.0.CR1. when i click start button to create a process instance i got the following execption.but when i used hsqldb as database am able to create a process instance. | [JDBCExceptionReporter] SQL Error: -28, SQLState: S0022 | ERROR [JDBCExceptionReporter] Column not found: ROWNUM in statement [select * from ( select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='EndMultiple-3' ) where rownum <= ?] | 16:05:45,290 INFO [DefaultCommandService] exception while executing command org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd@19ac87 | 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.hql.QueryLoader.list(QueryLoader.java:401) | at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) | at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) | at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) | at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835) | at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findDeploymentPropertyByProcessDefinitionId(RepositorySessionImpl.java:184) | at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionById(RepositorySessionImpl.java:171) | at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionById(RepositorySessionImpl.java:45) | at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:53) | at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:37) | at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) | at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54) | at org.jbpm.enterprise.internal.jta.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:73) | at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceById(ExecutionServiceImpl.java:49) | at org.jbpm.integration.console.ProcessManagementImpl.newInstance(ProcessManagementImpl.java:203) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) | at java.lang.reflect.Method.invoke(Unknown Source) | at org.jboss.bpm.console.server.util.InvocationProxy.invoke(InvocationProxy.java:64) | at $Proxy164.newInstance(Unknown Source) | at org.jboss.bpm.console.server.ProcessMgmtFacade.newInstance(ProcessMgmtFacade.java:118) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) | at java.lang.reflect.Method.invoke(Unknown Source) | 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) | 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:803) | 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:828) | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601) | at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) | at java.lang.Thread.run(Unknown Source) | Caused by: java.sql.SQLException: Column not found: ROWNUM in statement [select * from ( select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='EndMultiple-3' ) where rownum <= ?] | at org.hsqldb.jdbc.Util.throwError(Unknown Source) | at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) | at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) | at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:465) | at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:453) | at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243) | at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) | at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) | at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) | at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573) | at org.hibernate.loader.Loader.doQuery(Loader.java:696) | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) | at org.hibernate.loader.Loader.doList(Loader.java:2228) | ... 63 more | 16:05:45,310 ERROR [STDERR] 262595 [http-127.0.0.1-8080-2] ERROR org.jboss.resteasy.core.SynchronousDispatcher - failed to execute | 16:05:45,310 ERROR [STDERR] javax.ws.rs.WebApplicationException: java.lang.RuntimeException: Unexpected invocation exception: null | 16:05:45,311 ERROR [STDERR] at org.jboss.bpm.console.server.ProcessMgmtFacade.newInstance(ProcessMgmtFacade.java:123) | 16:05:45,311 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | 16:05:45,311 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) | 16:05:45,311 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) | 16:05:45,311 ERROR [STDERR] at java.lang.reflect.Method.invoke(Unknown Source) | 16:05:45,311 ERROR [STDERR] at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117) | 16:05:45,311 ERROR [STDERR] at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260) | 16:05:45,311 ERROR [STDERR] at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232) | 16:05:45,311 ERROR [STDERR] at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166) | 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142) | 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356) | 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173) | 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93) | 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68) | 16:05:45,312 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) | 16:05:45,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) | 16:05:45,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | 16:05:45,312 ERROR [STDERR] at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59) | 16:05:45,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | 16:05:45,313 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) | 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235) | 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) | 16:05:45,313 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190) | 16:05:45,313 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) | 16:05:45,313 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92) | 16:05:45,313 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126) | 16:05:45,314 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70) | 16:05:45,314 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) | 16:05:45,314 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) | 16:05:45,314 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) | 16:05:45,314 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) | 16:05:45,314 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330) | 16:05:45,314 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) | 16:05:45,314 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601) | 16:05:45,314 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) | 16:05:45,314 ERROR [STDERR] at java.lang.Thread.run(Unknown Source) | 16:05:45,315 ERROR [STDERR] Caused by: java.lang.RuntimeException: Unexpected invocation exception: null | 16:05:45,315 ERROR [STDERR] at org.jboss.bpm.console.server.util.InvocationProxy.invoke(InvocationProxy.java:80) | 16:05:45,315 ERROR [STDERR] at $Proxy164.newInstance(Unknown Source) | 16:05:45,315 ERROR [STDERR] at org.jboss.bpm.console.server.ProcessMgmtFacade.newInstance(ProcessMgmtFacade.java:118) | 16:05:45,315 ERROR [STDERR] ... 38 more | 16:05:45,316 ERROR [STDERR] Caused by: java.lang.reflect.InvocationTargetException | 16:05:45,316 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | 16:05:45,316 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) | 16:05:45,316 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) | 16:05:45,316 ERROR [STDERR] at java.lang.reflect.Method.invoke(Unknown Source) | 16:05:45,316 ERROR [STDERR] at org.jboss.bpm.console.server.util.InvocationProxy.invoke(InvocationProxy.java:64) | 16:05:45,316 ERROR [STDERR] ... 40 more | 16:05:45,316 ERROR [STDERR] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query | 16:05:45,316 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) | 16:05:45,316 ERROR [STDERR] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) | 16:05:45,317 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2231) | 16:05:45,317 ERROR [STDERR] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) | 16:05:45,317 ERROR [STDERR] at org.hibernate.loader.Loader.list(Loader.java:2120) | 16:05:45,317 ERROR [STDERR] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) | 16:05:45,317 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) | 16:05:45,317 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) | 16:05:45,317 ERROR [STDERR] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) | 16:05:45,317 ERROR [STDERR] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) | 16:05:45,318 ERROR [STDERR] at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835) | 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findDeploymentPropertyByProcessDefinitionId(RepositorySessionImpl.java:184) | 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionById(RepositorySessionImpl.java:171) | 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionById(RepositorySessionImpl.java:45) | 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:53) | 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:37) | 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) | 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54) | 16:05:45,318 ERROR [STDERR] at org.jbpm.enterprise.internal.jta.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:73) | 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceById(ExecutionServiceImpl.java:49) | 16:05:45,319 ERROR [STDERR] at org.jbpm.integration.console.ProcessManagementImpl.newInstance(ProcessManagementImpl.java:203) | 16:05:45,319 ERROR [STDERR] ... 45 more | 16:05:45,319 ERROR [STDERR] Caused by: java.sql.SQLException: Column not found: ROWNUM in statement [select * from ( select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='EndMultiple-3' ) where rownum <= ?] | 16:05:45,319 ERROR [STDERR] at org.hsqldb.jdbc.Util.throwError(Unknown Source) | 16:05:45,319 ERROR [STDERR] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) | 16:05:45,319 ERROR [STDERR] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) | 16:05:45,319 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:465) | 16:05:45,319 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:453) | 16:05:45,319 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243) | 16:05:45,320 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) | 16:05:45,320 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) | 16:05:45,320 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) | 16:05:45,320 ERROR [STDERR] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573) | 16:05:45,320 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:696) | 16:05:45,320 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) | 16:05:45,320 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2228) | 16:05:45,320 ERROR [STDERR] ... 63 more | | Thanks & Regards Maruthi View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4236315#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...