[jboss-user] [JBoss jBPM] - Trying to run jbpm outside tomcat on mysql

[dingo001]

I am trying to run the HelloWorldDbTest at http://docs.jboss.com/jbpm/v3.2/userguide/html/tutorial.html

Now, I set up my hibernate.cfg.xml as 

  | <!-- hibernate dialect -->
  |     <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
  | 
  |     <!-- JDBC connection properties (begin) -->
  |     <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  |     <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpmtest</property>
  |     <property name="hibernate.connection.username">root</property>
  |     <property name="hibernate.connection.password"></property>
  |     <!-- JDBC connection properties (end) -->
  | 
  |     <!-- DataSource properties (begin) ===
  |     <property name="hibernate.connection.datasource">java:/JbpmDS</property>
  |     ==== DataSource properties (end) -->
  | 

I create the db manually from the script at /db/jbpm.jpdl.mysql.sql because of the JIRA issue here.

But when I run the code, I get this error


  | [ 10 Aug 2007 14:36:12,822],[ERROR], org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:300), Error in named query: GraphSession.deleteJobsForProcessInstance
  | org.hibernate.hql.ast.QuerySyntaxError: unexpected token: job near line 3, column 36 [
  |     
  |       delete from org.jbpm.job.Job job
  |       where job.processInstance = :processInstance
  |     
  |   ]
  | 	at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:63)
  | 	at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:215)
  | 	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
  | 	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
  | 	at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
  | 	at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:388)
  | 	at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:291)
  | 	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
  | 	at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:94)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getGraphSession(DbPersistenceService.java:336)
  | 	at org.jbpm.JbpmContext.getGraphSession(JbpmContext.java:571)
  | 	at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
  | 	at org.jbpm.examples.HelloWorldDbTest.deployProcessDefinition(HelloWorldDbTest.java:108)
  | 	at org.jbpm.examples.HelloWorldDbTest.testSimplePersistence(HelloWorldDbTest.java:80)
  | 	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 junit.framework.TestCase.runTest(TestCase.java:154)
  | 	at junit.framework.TestCase.runBare(TestCase.java:127)
  | 	at junit.framework.TestResult$1.protect(TestResult.java:106)
  | 	at junit.framework.TestResult.runProtected(TestResult.java:124)
  | 	at junit.framework.TestResult.run(TestResult.java:109)
  | 	at junit.framework.TestCase.run(TestCase.java:118)
  | 	at junit.framework.TestSuite.runTest(TestSuite.java:208)
  | 	at junit.framework.TestSuite.run(TestSuite.java:203)
  | 	at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
  | 	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
  | 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
  | 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
  | 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
  | 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
  | Caused by: line 3:36: unexpected token: job
  | 	at org.hibernate.hql.antlr.HqlBaseParser.deleteStatement(HqlBaseParser.java:242)
  | 	at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:139)
  | 	at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:209)
  | 	... 32 more
  | 

Any ideas why this is happening?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4073191#4073191

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4073191