we keep running into snags.why don't you post them here... maybe we can solve them in a simple way
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.
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
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?
Also it was the "hibernate.cfg.xml" file that was causing that issue, I had not modified it. I changed the dialect and datasource.
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
suggestion: Part of this is all basic JEE/JBoss, so instead of paid jBPM support, might I suggest support at a 'lower' level ;-)
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!
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?