[jboss-user] [JBoss jBPM] - Re: Looking for Paid JBPM MySQL Server Setup

[ChuckP]

kukeeltje: that would be great, let me give that a shot.

I have two issues, the first is an error on launch that reads:

"--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:service=DataSourceBinding,name=MySqlDS
  State: NOTYETINSTALLED
  Depends On Me:
    jboss.mq:service=PersistenceManager

ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
  State: NOTYETINSTALLED
  Depends On Me:
    jboss.ejb:service=EJBTimerService,persistencePolicy=database
    jboss:service=KeyGeneratorFactory,type=HiLo
    jboss.mq:service=StateManager
"

I am almost certian this has something to do with the "mysql-jdbc2-service.xml" and "mysql-jdbc-state-service.xml" files in /server/jbpm/deploy/jms/

then the other error, the one I can never seem to get rid of is:

"00:13:51,701 WARN  [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
00:13:51,702 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 job0_.ID_ as ID1_26_, job0_.VERSION_ as VERSION3_26_, job0_.DUEDATE_ as DUEDAT' at line 1
00:13:51,702 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: could not execute query
00:13:51,705 ERROR [JobExecutorThread] exception in job executor thread. waiting 5000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs"


This I believe might have something to do with the fact that I have not populated the MySQL database with any data. It did auto create the tables, however there is no data in there. I tried to import the jbpmDB.script file, but I guess that is not formatted for MySQL. Or perhaps I have the library setup incorrectly.

I do have "mysql-connector-java-3.1.14-bin.jar" in /server/jbpm/lib

I have tried multiple tutorials online and the second error always seems to be my result.

Thank you,
Chuck Pearce

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

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