[jboss-user] [jBPM] - [insert-error] jBPM 5.3 with MySQL

[hiroro]

hiroro [https://community.jboss.org/people/hiroro] created the discussion

"[insert-error] jBPM 5.3 with MySQL"

To view the discussion, visit: https://community.jboss.org/message/751217#751217

--------------------------------------------------------------
I try jBPM not only with PostgreSQL but also MySQL.

I try Evaluation Sample with MySQL,
Following Error is occuerd internal.

22:01:51,530 ERROR [stderr] (Thread-16) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION jbpm5.nextval does not exist
22:01:51,530 ERROR [stderr] (Thread-16)           at sun.reflect.GeneratedConstructorAccessor37.newInstance(Unknown Source)
22:01:51,530 ERROR [stderr] (Thread-16)           at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
22:01:51,530 ERROR [stderr] (Thread-16)           at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
22:01:51,639 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
22:01:51,639 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.Util.getInstance(Util.java:386)
22:01:51,639 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
22:01:51,639 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
22:01:51,639 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
22:01:51,639 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
22:01:51,733 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
22:01:51,733 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
22:01:51,733 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
22:01:51,733 ERROR [stderr] (Thread-16)           at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310)
22:01:51,733 ERROR [stderr] (Thread-16)           at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
22:01:51,842 ERROR [stderr] (Thread-16)           at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:98)
22:01:51,842 ERROR [stderr] (Thread-16)           ... 17 more

Because of this Error, nothig is registered to "task" table.
So,I can regist the process,but nothing is shown task menu.(So, I can not Proceed the Task).

Why is this Error occuerd?

Please tell me how to resolve this problem.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/751217#751217]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120731/f75a1239/attachment.html