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****n(Main.java:464)
at java.lang.Thread****n(Thread.java:595)

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...

Thanks for reply
can u tell me What is the solution

Hi
There is no table in database. executeupdate command is not running. i dont understand what is the 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!