6:41 a.m.
Csaba K [https://community.jboss.org/people/chabee] created the discussion
"MySQL database connection error"
To view the discussion, visit: https://community.jboss.org/message/802643#802643
--------------------------------------------------------------
*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
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/
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
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
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: *
h1. *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.
----
h3. *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
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/802643#802643]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]