Error while trying to connect to Oracle database from jBPM
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
