Results 1 to 5 of 5
  1. #1
    Join Date
    May 2007
    Posts
    5

    Unanswered: java.sql.SQLException: Table already exists: JMS_TRANSACTIONS in statement [CREATE CA

    Hi,
    I got the following exception on jboss startup. I ve copied jdbc driver for mysql into server lib directory. what else i need to change can anybody help


    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
    at org.hsqldb.jdbc.Util.throwError(Unknown Source)
    at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdat e(Unknown Source)
    at org.jboss.resource.adapter.jdbc.CachedPreparedStat ement.executeUpdate(CachedPreparedStatement.java:9 5)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.executeUpdate(WrappedPreparedStatement.java :251)
    at org.jboss.mq.pm.jdbc2.PersistenceManager.createSch ema(PersistenceManager.java:259)
    at org.jboss.mq.pm.jdbc2.PersistenceManager.startServ ice(PersistenceManager.java:1563)
    at org.jboss.system.ServiceMBeanSupport.jbossInternal Start(ServiceMBeanSupport.java:289)
    at org.jboss.system.ServiceMBeanSupport.jbossInternal Lifecycle(ServiceMBeanSupport.java:245)
    at sun.reflect.GeneratedMethodAccessor2.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
    at org.jboss.system.ServiceController$ServiceProxy.in voke(ServiceController.java:978)
    at $Proxy0.start(Unknown Source)
    at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:417)
    at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:435)
    at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:435)
    at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:435)
    at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:435)
    at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:435)
    at sun.reflect.GeneratedMethodAccessor9.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
    at $Proxy4.start(Unknown Source)
    at org.jboss.deployment.SARDeployer.start(SARDeployer .java:302)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
    at org.jboss.mx.interceptor.AbstractInterceptor.invok e(AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterc eptor.invoke(ModelMBeanOperationInterceptor.java:1 42)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
    at $Proxy42.start(Unknown Source)
    at org.jboss.deployment.XSLSubDeployer.start(XSLSubDe ployer.java:197)
    at org.jboss.deployment.MainDeployer.start(MainDeploy er.java:1007)
    at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:808)
    at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:771)
    at sun.reflect.GeneratedMethodAccessor55.invoke(Unkno wn Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
    at org.jboss.mx.interceptor.AbstractInterceptor.invok e(AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterc eptor.invoke(ModelMBeanOperationInterceptor.java:1 42)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
    at $Proxy8.deploy(Unknown Source)
    at org.jboss.deployment.scanner.URLDeploymentScanner. deploy(URLDeploymentScanner.java:421)
    at org.jboss.deployment.scanner.URLDeploymentScanner. scan(URLDeploymentScanner.java:634)
    at org.jboss.deployment.scanner.AbstractDeploymentSca nner$ScannerThread.doScan(AbstractDeploymentScanne r.java:263)
    at org.jboss.deployment.scanner.AbstractDeploymentSca nner.startService(AbstractDeploymentScanner.java:3 36)
    at org.jboss.system.ServiceMBeanSupport.jbossInternal Start(ServiceMBeanSupport.java:289)
    at org.jboss.system.ServiceMBeanSupport.jbossInternal Lifecycle(ServiceMBeanSupport.java:245)
    at sun.reflect.GeneratedMethodAccessor2.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
    at org.jboss.system.ServiceController$ServiceProxy.in voke(ServiceController.java:978)
    at $Proxy0.start(Unknown Source)
    at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:417)
    at sun.reflect.GeneratedMethodAccessor9.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
    at $Proxy4.start(Unknown Source)
    at org.jboss.deployment.SARDeployer.start(SARDeployer .java:302)
    at org.jboss.deployment.MainDeployer.start(MainDeploy er.java:1007)
    at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:808)
    at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:771)
    at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:755)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
    at org.jboss.mx.interceptor.AbstractInterceptor.invok e(AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterc eptor.invoke(ModelMBeanOperationInterceptor.java:1 42)
    at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
    at $Proxy5.deploy(Unknown Source)
    at org.jboss.system.server.ServerImpl.doStart(ServerI mpl.java:482)
    at org.jboss.system.server.ServerImpl.start(ServerImp l.java:362)
    at org.jboss.Main.boot(Main.java:200)
    at org.jboss.Main$1.run(Main.java:464)
    at java.lang.Thread.run(Thread.java:595)

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    The answer is in the very first line of your error message :
    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]

    your SQL statement is attempting to create a table that ALREADY exists...

  3. #3
    Join Date
    May 2007
    Posts
    5
    Thanks for reply
    can u tell me What is the solution

  4. #4
    Join Date
    May 2007
    Posts
    5
    Hi
    There is no table in database. executeupdate command is not running. i dont understand what is the problem

  5. #5
    Join Date
    Jul 2007
    Posts
    1

    Cool No problem!

    If you check the logging level more carefully, you'll notice this is a *debug* stacktrace not a warning or error.

    http://www.dbforums.com/register.php...162&i=65164807

    So you can ignore this!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •