3 Replies Latest reply on Dec 2, 2012 11:02 PM by thomas.setiabudi

    i run ant start.demo.db and error

    lone

      I work with jbpm 5.3 . i run ant start.demo.db and  get below error. Can anyone show me how to fix it? Thanks

       

      D:\OpenSource\BPM\jbpm-installer>ant start.demo.db

      Buildfile: D:\OpenSource\BPM\jbpm-installer\build.xml

       

       

      check.jboss.version:

       

       

      download.db.driver.check:

           [echo] Checking if db driver jar has been downloaded ...

       

       

      download.mysql.driver:

       

       

      install.db.files:

       

       

      start.jboss:

       

       

      check.jboss.version:

       

       

      start.jboss5:

       

       

      check.jboss.version:

       

       

      start.jboss7:

       

       

      start.human.task:

          [javac] D:\OpenSource\BPM\jbpm-installer\build.xml:844: warning: 'includeant

      runtime' was not set, defaulting to build.sysclasspath=last; set to false for re

      peatable builds

           [java] 1    23/11 13:37:56,140[main] ERROR tool.hbm2ddl.SchemaExport.execut

      e  - schema export unsuccessful

           [java] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown d

      atabase 'task'

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native

      Method)

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC

      onstructorAccessorImpl.java:57)

           [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del

      egatingConstructorAccessorImpl.java:45)

           [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:52

      5)

           [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

           [java]     at com.mysql.jdbc.Util.getInstance(Util.java:386)

           [java]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052

      )

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943)

           [java]     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113)

           [java]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)

           [java]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java

      :2336)

           [java]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImp

      l.java:2369)

           [java]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java

      :2153)

           [java]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)

       

       

           [java]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47

      )

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native

      Method)

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC

      onstructorAccessorImpl.java:57)

           [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del

      egatingConstructorAccessorImpl.java:45)

           [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:52

      5)

           [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

           [java]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java

      :381)

           [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri

      ver.java:305)

           [java]     at java.sql.DriverManager.getConnection(DriverManager.java:579)

           [java]     at java.sql.DriverManager.getConnection(DriverManager.java:190)

           [java]     at org.hibernate.connection.DriverManagerConnectionProvider.getC

      onnection(DriverManagerConnectionProvider.java:133)

           [java]     at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnecti

      onHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)

           [java]     at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.

      java:252)

           [java]     at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.j

      ava:211)

           [java]     at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryIm

      pl.java:353)

           [java]     at org.hibernate.cfg.Configuration.buildSessionFactory(Configura

      tion.java:1341)

           [java]     at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory

      (AnnotationConfiguration.java:867)

           [java]     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory

      (Ejb3Configuration.java:669)

           [java]     at org.hibernate.ejb.HibernatePersistence.createEntityManagerFac

      tory(HibernatePersistence.java:126)

           [java]     at javax.persistence.Persistence.createEntityManagerFactory(Pers

      istence.java:52)

           [java]     at javax.persistence.Persistence.createEntityManagerFactory(Pers

      istence.java:34)

           [java]     at org.jbpm.DemoTaskService.main(Unknown Source)

           [java] 1053 23/11 13:37:57,192[main] ERROR hibernate.util.JDBCExceptionRepo

      rter.logExceptions  - Unknown database 'task'

           [java] 1055 23/11 13:37:57,194[main] WARN  service.persistence.TaskLocalTra

      nsactionManager.begin  - Unable to begin transaction

           [java] javax.persistence.PersistenceException: org.hibernate.exception.SQLG

      rammarException: Cannot open connection

           [java]     at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceE

      xception(AbstractEntityManagerImpl.java:614)

           [java]     at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:

      41)

           [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager

      .begin(TaskLocalTransactionManager.java:42)

           [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.begi

      nTransaction(TaskPersistenceManager.java:79)

           [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.getU

      nescalatedDeadlines(TaskPersistenceManager.java:144)

           [java]     at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedD

      eadlines(TaskServiceSession.java:231)

           [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java

      :116)

           [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java

      :101)

           [java]     at org.jbpm.task.service.TaskService.<init>(TaskService.java:79)

       

       

           [java]     at org.jbpm.DemoTaskService.main(Unknown Source)

           [java] Caused by: org.hibernate.exception.SQLGrammarException: Cannot open

      connection

           [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateCon

      verter.java:90)

           [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep

      tionHelper.java:66)

           [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep

      tionHelper.java:52)

           [java]     at org.hibernate.jdbc.ConnectionManager.openConnection(Connectio

      nManager.java:449)

           [java]     at org.hibernate.jdbc.ConnectionManager.getConnection(Connection

      Manager.java:167)

           [java]     at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:14

      2)

           [java]     at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransacti

      on.java:85)

           [java]     at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.j

      ava:1354)

           [java]     at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:

      38)

           [java] Exception in thread "main" java.lang.RuntimeException: Unable to beg

      in transaction

           [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager

      .begin(TaskLocalTransactionManager.java:46)

           [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.begi

      nTransaction(TaskPersistenceManager.java:79)

           [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.getU

      nescalatedDeadlines(TaskPersistenceManager.java:144)

           [java]     at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedD

      eadlines(TaskServiceSession.java:231)

           [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java

      :116)

           [java]     ... 8 more

           [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java

      :101)

           [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

      : Unknown database 'task'       at org.jbpm.task.service.TaskService.<init>(Task

      Service.java:79)

           [java]

           [java]     at org.jbpm.DemoTaskService.main(Unknown Source)

           [java] Caused by: javax.persistence.PersistenceException: org.hibernate.exc

      eption.SQLGrammarException: Cannot open connection

           [java]     at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceE

      xception(AbstractEntityManagerImpl.java:614)

           [java]     at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:

      41)

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native

      Method)

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC

      onstructorAccessorImpl.java:57)

           [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del

      egatingConstructorAccessorImpl.java:45)

           [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:52

      5)

           [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

           [java]     at com.mysql.jdbc.Util.getInstance(Util.java:386)

           [java]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052

      )

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943)

           [java]     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113)

           [java]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)

           [java]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java

      :2336)

           [java]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImp

      l.java:2369)

           [java]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java

      :2153)

           [java]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)

       

       

           [java]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47

      )

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native

      Method)

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC

      onstructorAccessorImpl.java:57)

           [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del

      egatingConstructorAccessorImpl.java:45)

           [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:52

      5)

           [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

           [java]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java

      :381)

           [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri

      ver.java:305)

           [java]     at java.sql.DriverManager.getConnection(DriverManager.java:579)

           [java]     at java.sql.DriverManager.getConnection(DriverManager.java:190)

           [java]     at org.hibernate.connection.DriverManagerConnectionProvider.getC

      onnection(DriverManagerConnectionProvider.java:133)

           [java]     at org.hibernate.jdbc.ConnectionManager.openConnection(Connectio

      nManager.java:446)

           [java]     ... 13 more

           [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager

      .begin(TaskLocalTransactionManager.java:42)

           [java]     ... 7 more

           [java] Caused by: org.hibernate.exception.SQLGrammarException: Cannot open

      connection

           [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateCon

      verter.java:90)

           [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep

      tionHelper.java:66)

           [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep

      tionHelper.java:52)

           [java]     at org.hibernate.jdbc.ConnectionManager.openConnection(Connectio

      nManager.java:449)

           [java]     at org.hibernate.jdbc.ConnectionManager.getConnection(Connection

      Manager.java:167)

           [java]     at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:14

      2)

           [java]     at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransacti

      on.java:85)

           [java]     at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.j

      ava:1354)

           [java]     at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:

      38)

           [java]     ... 8 more

           [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

      : Unknown database 'task'

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native

      Method)

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC

      onstructorAccessorImpl.java:57)

           [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del

      egatingConstructorAccessorImpl.java:45)

           [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:52

      5)

           [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

           [java]     at com.mysql.jdbc.Util.getInstance(Util.java:386)

           [java]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052

      )

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

           [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943)

           [java]     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113)

           [java]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)

           [java]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java

      :2336)

           [java]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImp

      l.java:2369)

           [java]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java

      :2153)

           [java]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)

       

       

           [java]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47

      )

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native

      Method)

           [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC

      onstructorAccessorImpl.java:57)

           [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del

      egatingConstructorAccessorImpl.java:45)

           [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:52

      5)

           [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

           [java]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java

      :381)

           [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri

      ver.java:305)

           [java]     at java.sql.DriverManager.getConnection(DriverManager.java:579)

           [java]     at java.sql.DriverManager.getConnection(DriverManager.java:190)

           [java]     at org.hibernate.connection.DriverManagerConnectionProvider.getC

      onnection(DriverManagerConnectionProvider.java:133)

           [java]     at org.hibernate.jdbc.ConnectionManager.openConnection(Connectio

      nManager.java:446)

           [java]     ... 13 more

           [java] Java Result: 1

       

       

      start.demo.db:

       

       

      BUILD SUCCESSFUL

      Total time: 8 seconds