4 Replies Latest reply on Apr 3, 2013 7:55 PM by chabee

    MySQL database connection error

    chabee

      Hy all!

       

      I am trying to change H2 database to MySQL database. I installed a MySQL server and went through http://docs.jboss.com/jbpm/v5.4/userguide/ch.installer.html#d0e609 on this description. I started jboss AS7 and MySQL server also, I opened http://localhost:8080/jbpm-console/.

      After I logged in I got this error:

       

      2013-03-14 12:21:41,711 [DEBUG] new subscription: appContext.model.listener -> org.jboss.bpm.console.client.task.AssignedTasksView$8@119

      2013-03-14 12:21:41,713 [DEBUG] New Subscription: appContext.model.listener

      2013-03-14 12:21:42,221 [DEBUG] GET: http://localhost:8080/gwt-console-server/rs/tasks/admin

      2013-03-14 12:21:53,134 [ERROR] <ul><li>URL: 'http://localhost:8080/gwt-console-server/rs/tasks/admin'

      <li>Action: 'org.jboss.bpm.console.client.task.LoadTasksAction'

      <li>Exception: 'class com.google.gwt.http.client.RequestException'</ul>

       

      HTTP 500: <html><head><title>JBoss Web/7.0.13.Final - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 500 - </h1><HR size="1" noshade="noshade"><p><b>type</b> Exception report</p><p><b>message</b> <u></u></p><p><b>description</b> <u>The server encountered an internal error () that prevented it from fulfilling this request.</u></p><p><b>exception</b> <pre>org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Session was not initialized, check previous errors in log

      org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:340)

      org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214)

      org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190)

      org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:540)

      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)

      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

      org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

      org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

      </pre></p><p><b>root cause</b> <pre>java.lang.RuntimeException: Session was not initialized, check previous errors in log

      org.jbpm.integration.console.StatefulKnowledgeSessionUtil.getStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:89)

      org.jbpm.integration.console.SessionInitializer.<init>(SessionInitializer.java:25)

      org.jbpm.integration.console.TaskManagement.<init>(TaskManagement.java:52)

      org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:26)

      org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:19)

      org.jboss.bpm.console.server.TaskListFacade.getTaskManagement(TaskListFacade.java:72)

      org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:101)

      sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      java.lang.reflect.Method.invoke(Method.java:616)

      org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:155)

      org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)

      org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)

      org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)

      org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525)

      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)

      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

      org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

      org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

      </pre></p><p><b>note</b> <u>The full stack trace of the root cause is available in the JBoss Web/7.0.13.Final logs.</u></p><HR size="1" noshade="noshade"><h3>JBoss Web/7.0.13.Final</h3></body></html>

      com.google.gwt.http.client.RequestException:

      HTTP 500: 

      HTTP Status 500 -


       

      type Exception report

      message

      description The server encountered an internal error () that prevented it from fulfilling this request.

      exception

       

      org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Session was not initialized, check previous errors in log
           org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:340)
           org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214)
           org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190)
           org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:540)
           org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
           org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
           org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
           org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
           org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
           javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
           org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

       

      root cause

       

      java.lang.RuntimeException: Session was not initialized, check previous errors in log
           org.jbpm.integration.console.StatefulKnowledgeSessionUtil.getStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:89)
           org.jbpm.integration.console.SessionInitializer.<init>(SessionInitializer.java:25)
           org.jbpm.integration.console.TaskManagement.<init>(TaskManagement.java:52)
           org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:26)
           org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:19)
           org.jboss.bpm.console.server.TaskListFacade.getTaskManagement(TaskListFacade.java:72)
           org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:101)
           sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
           sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           java.lang.reflect.Method.invoke(Method.java:616)
           org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:155)
           org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
           org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
           org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
           org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525)
           org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
           org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
           org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
           org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
           org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
           javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
           org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

       

      note The full stack trace of the root cause is available in the JBoss Web/7.0.13.Final logs.

       


      JBoss Web/7.0.13.Final

          at Unknown.$fillInStackTrace_1(JsArrayString.java:42)

       

          at Unknown.$RequestException(StackTraceCreator.java:366)

          at Unknown.onResponseReceived_5(AbstractRESTAction.java:93)

          at Unknown.$fireOnResponseReceived(Request.java:287)

          at Unknown.onReadyStateChange_0(RequestBuilder.java:393)

          at Unknown.anonymous(XMLHttpRequest.java:258)

          at Unknown.entry0(Impl.java:146)

          at Unknown.anonymous(Impl.java:56)

       

       

      As I've seen the error log there are two kind of exceptions:

       

      First:

      2:15:13,030 ERROR [org.reflections.Reflections] (MSC service thread 1-2) could not create Vfs.Dir from url. ignoring the exception and continuing: org.reflections.ReflectionsException: could not create Dir using org.jboss.errai.bus.server.service.metadata.VFSUrlType from url vfs:/content/jbpm-gwt-console.war/WEB-INF/classes/

          at org.reflections.vfs.Vfs.fromURL(Vfs.java:99) [reflections-0.9.5-RC2_jboss-SP1.jar:]

          at org.reflections.vfs.Vfs.fromURL(Vfs.java:89) [reflections-0.9.5-RC2_jboss-SP1.jar:]

          at org.reflections.Reflections.scan(Reflections.java:136) [reflections-0.9.5-RC2_jboss-SP1.jar:]

          at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.<init>(MetaDataScanner.java:83) [errai-bus-1.1-Final.jar:1.1-Final]

          at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.createInstance(MetaDataScanner.java:95) [errai-bus-1.1-Final.jar:1.1-Final]

          at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.createInstance(MetaDataScanner.java:87) [errai-bus-1.1-Final.jar:1.1-Final]

          at org.jboss.errai.bus.server.service.ErraiServiceConfiguratorImpl.<init>(ErraiServiceConfiguratorImpl.java:58) [errai-bus-1.1-Final.jar:1.1-Final]

          at org.jboss.errai.bus.server.service.ErraiServiceConfiguratorImpl$$FastClassByGuice$$b6139751.newInstance(<generated>)

          at com.google.inject.internal.cglib.reflect.FastConstructor.newInstance(FastConstructor.java:40) [guice-2.0.jar:]

          at com.google.inject.DefaultConstructionProxyFactory$1.newInstance(DefaultConstructionProxyFactory.java:60) [guice-2.0.jar:]

          at com.google.inject.ConstructorInjector.construct(ConstructorInjector.java:85) [guice-2.0.jar:]

          at com.google.inject.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:111) [guice-2.0.jar:]

          at com.google.inject.FactoryProxy.get(FactoryProxy.java:56) [guice-2.0.jar:]

          at com.google.inject.SingleParameterInjector.inject(SingleParameterInjector.java:42) [guice-2.0.jar:]

          at com.google.inject.SingleParameterInjector.getAll(SingleParameterInjector.java:66) [guice-2.0.jar:]

          at com.google.inject.ConstructorInjector.construct(ConstructorInjector.java:84) [guice-2.0.jar:]

          at com.google.inject.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:111) [guice-2.0.jar:]

          at com.google.inject.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:45) [guice-2.0.jar:]

          at com.google.inject.InjectorImpl.callInContext(InjectorImpl.java:811) [guice-2.0.jar:]

          at com.google.inject.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:42) [guice-2.0.jar:]

          at com.google.inject.Scopes$1$1.get(Scopes.java:54) [guice-2.0.jar:]

          at com.google.inject.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:48) [guice-2.0.jar:]

          at com.google.inject.FactoryProxy.get(FactoryProxy.java:56) [guice-2.0.jar:]

          at com.google.inject.InjectorImpl$4$1.call(InjectorImpl.java:758) [guice-2.0.jar:]

          at com.google.inject.InjectorImpl.callInContext(InjectorImpl.java:804) [guice-2.0.jar:]

          at com.google.inject.InjectorImpl$4.get(InjectorImpl.java:754) [guice-2.0.jar:]

          at com.google.inject.InjectorImpl.getInstance(InjectorImpl.java:793) [guice-2.0.jar:]

          at org.jboss.errai.bus.server.servlet.AbstractErraiServlet.buildService(AbstractErraiServlet.java:133) [errai-bus-1.1-Final.jar:1.1-Final]

          at org.jboss.errai.bus.server.servlet.AbstractErraiServlet.init(AbstractErraiServlet.java:104) [errai-bus-1.1-Final.jar:1.1-Final]

          at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3655) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContext.start(StandardContext.java:3873) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.6.0_24]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]

          at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]

       

      And the second is a MySQL exception, there a lots of tables missings like:

      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.6.0_24]

          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.6.0_24]

          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.6.0_24]

          at java.lang.reflect.Constructor.newInstance(Constructor.java:532) [rt.jar:1.6.0_24]

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

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

          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

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

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

          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)

          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)

          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

          at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)

          at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)

          at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:149) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:70) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:63) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:457) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:84) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:904) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:889) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:73) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

          at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:162) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(PersistenceUnitServiceImpl.java:85) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.6.0_24]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]

          at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]

       

      My questions are:

      Should I create the MySQL DB schema (I thin I should), and if I should where can I find an SQL script for this?

      The first error  also caused by the DB error?

       

      Thanks for your help!

       

      Best Regards,

       

      Csaba

        • 1. Re: MySQL database connection error
          pzoli

          And the second is a MySQL exception, there a lots of tables missings like:

          com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.6.0_24]

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.6.0_24]

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.6.0_24]

              at java.lang.reflect.Constructor.newInstance(Constructor.java:532) [rt.jar:1.6.0_24]

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

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

              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

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

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

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)

              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

              at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)

              at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)

              at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:149) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:70) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:63) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:457) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:84) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:904) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:889) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

              at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:73) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

              at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:162) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]

              at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(PersistenceUnitServiceImpl.java:85) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.6.0_24]

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]

              at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]

           

          My questions are:

          Should I create the MySQL DB schema (I thin I should), and if I should where can I find an SQL script for this?

          The first error  also caused by the DB error?

           

          Thanks for your help!

           

          Best Regards,

           

          Csaba

           

          Kedves Csaba!

           

          Az entitás tárolókat (adatbázis táblákat) automatikusan létrehozza a perzisztencia kezelő (lehet rá írni külön telepítő klienst, de az update bőven elegendő)

          persistence.xml:

          <property name="hibernate.hbm2ddl.auto" value="update" />

          .

          A sequences táblát azért keresi, mert egyedi azonosítója van egy entitás osztálynak, de nincs -vagy rossz- generálási stratégiával van ellátva.

           

          Próbáld ki ezt:

          @Entity -> @Id -> @GeneratedValue(strategy=GenerationType.IDENTITY)

          Újraidítás előtt dobd el a táblákat, hogy újra létrehozza ezeket az entitás tárolókat, és beállítsa a primary key mezőt a táblára.

           

          üdv.,

          Zoltán

          • 2. Re: MySQL database connection error
            chabee

            Thank you for your answer, I tried, but it did not work.

             

            I attached my server.log file, and the files in my jbpm/db directory.

            It seems, that it can not create the connection with the mysql server at all..

            What is missing/wrong?

             

            Thank you!

             

            Csaba

            • 3. Re: MySQL database connection error
              pzoli

              Okay, let's speak english. I use JBoss 7.1.1, and my jBPM knowledge is poor. But it seams that jbpm5 doesn't accessible from your datasource.

               

              My sample-ds.xml in a JBoss-tools generated JPA/CDI project:

               

              <datasources xmlns="http://www.jboss.org/ironjacamar/schema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                  xsi:schemaLocation="http://www.jboss.org/ironjacamar/schema http://docs.jboss.org/ironjacamar/schema/datasources_1_0.xsd">

                  <!-- The datasource is bound into JNDI at this location. We reference

                     this in META-INF/persistence.xml -->

                 <datasource jndi-name="java:jboss/datasources/sample-multi-tierDS"

                    pool-name="{artifactId}" enabled="true"

                    use-java-context="true">

                      <connection-url>jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&amp;autoReconnect=true&amp;characterEncoding=UTF-8</connection-url>

                      <driver>com.mysql</driver>

                      <security>

                          <user-name>username</user-name>

                          <password>password</password>

                      </security>

                 </datasource>

              </datasources>

               

              Did you install mysql driver to JBoss modules/com/mysql/main subdirectory?

               

              <module xmlns="urn:jboss:module:1.0" name="com.mysql">

                <resources>

                  <resource-root path="mysql-connector-java-5.1.21-bin.jar"/>

                </resources>

                <dependencies>

                  <module name="javax.api"/>

                </dependencies>

              </module>

               

              Your task-persistence-JPA1/2 is connected to an Oracle server. Is this tasks for Oracle-MySql synchronization? Did you installed oracle drivers, too?

              • 4. Re: MySQL database connection error
                chabee

                Yes, the problem was the connection to the datasource. I used AS7 but in the config file there was a link to a xxx-ds.xml file, and it belongs to AS5. I switched it to a JBMOrm,xml file and now it is working fine.

                 

                Thanks for your help!

                 

                BR,

                 

                Csaba