-
1. Re: Looking for Paid JBPM MySQL Server Setup
kukeltje Apr 9, 2008 4:54 AM (in response to chuckp)we keep running into snags.
why don't you post them here... maybe we can solve them in a simple way -
2. Re: Looking for Paid JBPM MySQL Server Setup
chuckp Apr 9, 2008 8:03 AM (in response to 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 -
3. Re: Looking for Paid JBPM MySQL Server Setup
kukeltje Apr 9, 2008 10:40 AM (in response to chuckp)the first one is 'simply' caused by not having the MySqlDS configured correctly. See http://wiki.jboss.org/wiki/SetUpAMysqlDatasource for more info.
The second one is most likely caused by not having the correct hibernate dialect.
Additional info can be found on http://docs.jboss.com/jbpm/v3/userguide/thejbpmdatabase.html -
4. Re: Looking for Paid JBPM MySQL Server Setup
chuckp Apr 9, 2008 11:20 AM (in response to chuckp)Thank you for the assistance, I believe I am extremely close. The database connection was made, and data was inserted. Here is a log of what is occurring, it appears somewhere I did not set "JbpmDS" to "DefaultDS". Any idea where I made the issue?
http://www.pastebin.ca/978413
Also it was the "hibernate.cfg.xml" file that was causing that issue, I had not modified it. I changed the dialect and datasource.
Thank you,
Chuck Pearce -
5. Re: Looking for Paid JBPM MySQL Server Setup
kukeltje Apr 9, 2008 12:42 PM (in response to chuckp)Might be that you have duplicate configs.
The hibernate config file should point to JbpmDS, that is the default with the latest versions. But since JbpmDS is not there it and data IS inserted, it probably is pointing directly to the database. There should be a jbpm-ds.xml file pointing to the database and the hibernate config pointing to this datasource. please check those -
6. Re: Looking for Paid JBPM MySQL Server Setup
kukeltje Apr 9, 2008 12:45 PM (in response to chuckp)suggestion: Part of this is all basic JEE/JBoss, so instead of paid jBPM support, might I suggest support at a 'lower' level ;-)
-
7. Re: Looking for Paid JBPM MySQL Server Setup
chuckp Apr 9, 2008 1:01 PM (in response to chuckp)kukeltje: today, you are my hero! Thank you so much for you help, the server is up and running using MySQL, I had deleted "jbpm-ds.xml" and didn't realize that the file was still required even after the mysql-ds.xml went into place.
Strangely the JBPM designer aspect we have pretty well, it is the server that we are lost in. Do you have any recommendations on optimization, or is it pretty well set just on a standard instillation?
Thank you again!
Chuck Pearce -
8. Re: Looking for Paid JBPM MySQL Server Setup
chuckp Apr 9, 2008 3:07 PM (in response to chuckp)Oh one last question, it appears that processes are being deployed to the hypersonic database, and the jbpm-console logs into the hypersonic database. However our webservice connects to the mysql database. Any idea what file I need to change to fix this?