0 Replies Latest reply on Jul 31, 2012 9:17 AM by hiroro

    [insert-error] jBPM 5.3 with MySQL

    hiroro

      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.