2 Replies Latest reply on Jun 9, 2008 8:41 AM by Ronald van Kuijk

    Error while trying to connect to Oracle database from jBPM

    Sathish Ba Newbie

      Hello,
      I am trying to connect to an Oracle database from jBPM rather than the default in memory database. I have made the necessary configuration changes for that. I created a PAR file out of the process definition. I am trying to deploy the PAR file using the ant DeployProcessToServer task. When I run the build.xml, I get the following error :

      Buildfile: C:\jBPMworkspace\jBPMFinTran\build.xml
      deployProcess:
      [echo] Deploy the process definition
      [deployToServer] deploying par C:\jBPMworkspace\jBPMFinTran\processes\simple.par\simple.par ...
      [deployToServer] java.io.IOException: Server returned HTTP response code: 500 for URL: http://localhost:8000/jbpm-console/upload
      [deployToServer] at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
      [deployToServer] at org.jbpm.ant.DeployProcessToServerTask.deployProcessWithServlet(DeployProcessToServerTask.java:164)
      [deployToServer] at org.jbpm.ant.DeployProcessToServerTask.execute(DeployProcessToServerTask.java:99)
      [deployToServer] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
      [deployToServer] at org.apache.tools.ant.Task.perform(Task.java:364)
      [deployToServer] at org.apache.tools.ant.Target.execute(Target.java:341)
      [deployToServer] at org.apache.tools.ant.Target.performTasks(Target.java:369)
      [deployToServer] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
      [deployToServer] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
      [deployToServer] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
      [deployToServer] at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
      [deployToServer] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
      [deployToServer] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
      [deployToServer] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)

      BUILD FAILED
      C:\jBPMworkspace\jBPMFinTran\build.xml:8: couldn't deploy process archives : Server returned HTTP response code: 500 for URL: http://localhost:8000/jbpm-console/upload

      Also, when I start the server I get the following error :

      15:02:44,390 ERROR [SessionFactoryImpl] Error in named query: GraphSession.findTokensForProcessInNode
      org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'node.name' [

      select token
      from org.jbpm.graph.exe.Token token
      where token.processInstance.processDefinition.name = :processDefinitionName
      and node.name = :nodeName

      ]
      at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
      at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:225)
      at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158)
      at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:105)
      at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:74)
      at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:53)
      at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
      at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:363)
      at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:327)
      at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1154)
      at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
      at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:95)
      at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:99)
      at org.jbpm.persistence.db.DbPersistenceService.getGraphSession(DbPersistenceService.java:341)
      at org.jbpm.JbpmContext.getGraphSession(JbpmContext.java:571)
      at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
      at org.jbpm.web.ProcessUploadServlet.handleRequest(ProcessUploadServlet.java:91)
      at org.jbpm.web.ProcessUploadServlet.service(ProcessUploadServlet.java:56)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)

      Please let me know how to get rid of these errors and connect successfully to Oracle database from jBPM