JBoss Community

[insert-error] jBPM 5.3 with MySQL

created by hiroro in jBPM - View the full discussion

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

Start a new discussion in jBPM at Community