I've successfully connected uengine to mysql but in the process manager whenever i try to deploy a process or create a form an exception is thrown.The exception is the following:
after executing the new script i got the following exception whenever i create a new form
ProcessManagerError: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 'SEQ_BPM_ProcDef as keyNumber from dual' at line 1; nested exception is: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'SEQ_BPM_ProcDef as keyNumber from dual' at line 1
please advice.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
In my experience the script is updated only for the hsqldb database. The other scripts have not been updated frequently.
Here is what I have done..
1. Run the inital server using the default settings i.e with hsqldb
2. Setup a Mysql Server instance
3. Use the HSQLDb/Mysql migrate tool to directly import from the hsqldb instance to the Mysql server.
The way to run the hsqldb in server mode is mentioned in the uengine manual.
If you need further help I can dump my running mysql table script and email it to you.
cheers and all the best
Krishna Iyer
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
good day gents,
I've successfully connected uengine to mysql but in the process manager whenever i try to deploy a process or create a form an exception is thrown.The exception is the following:
ProcessManagerError:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
Table 'lportal.bpm_seq' doesn't exist; nested exception is: java.lang.RuntimeException:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal.bpm_seq' doesn't exist
the Table 'lportiral.bpm_seq' doesn't exist , and this table is not in the list of sql quries that are supplied to be created when connecting to mysql
please advise
thank you and have a good day
Gents,
after executing the new script i got the following exception whenever i create a new form
ProcessManagerError: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 'SEQ_BPM_ProcDef as keyNumber from dual' at line 1; nested exception is: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'SEQ_BPM_ProcDef as keyNumber from dual' at line 1
please advice.
Tarik,
In my experience the script is updated only for the hsqldb database. The other scripts have not been updated frequently.
Here is what I have done..
1. Run the inital server using the default settings i.e with hsqldb
2. Setup a Mysql Server instance
3. Use the HSQLDb/Mysql migrate tool to directly import from the hsqldb instance to the Mysql server.
The way to run the hsqldb in server mode is mentioned in the uengine manual.
If you need further help I can dump my running mysql table script and email it to you.
cheers and all the best
Krishna Iyer
hi
I connected Uengine to mysql successfully only once time with some error like Tarik Chehab,and next time faced to this error:
Could not get JDBC Connection;nested exeption is org.apache.tomcat.dbcp.SQLNestedExeption:cannot create PoolableconnectionFactory
can you help me?
thanks