[jboss-user] [JBoss jBPM] - Re: Looking for Paid JBPM MySQL Server Setup
do-not-reply at jboss.com
Wed Apr 9 08:03:17 EDT 2008
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 ---
Depends On Me:
Depends On Me:
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.
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
More information about the jboss-user