0 Replies Latest reply on Nov 6, 2008 8:39 AM by Stevo Vukovic

    Problem with Embedded Jboss and MySQL

    Stevo Vukovic Newbie

      There is my problem with Embedded Jboss and MSQL. I trying to solve him more over 2 weeks.
      I obviously can'™t find right mysql-persistance-service.xml for Embedded Jboss beta3 SP2, MySQL 5.0.67, Tomcat 5.5.26.

      I try with 12 different versions of "mysql-persistance-service.xml" and non of them worked correctly.

      Complete error log:

      INFO [org.apache.catalina.core.AprLifecycleListener] The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.li
      brary.path: c:\Program Files\Java\jre1.5.0_14\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\MySQL\MySQL Server 5.0\bin;
      INFO [org.apache.coyote.http11.Http11BaseProtocol] Initializing Coyote HTTP/1.1 on http-8080
      INFO [org.apache.catalina.startup.Catalina] Initialization processed in 859 ms
      WARN [org.jboss.mx.loading.UnifiedLoaderRepository3] Tried to add non-URLClassLoader. Ignored
      WARN [org.jboss.aop.deployment.AspectManagerService] Could not find base-aspects.xml file in the resources of org.apache.catalina.loader.StandardClassLoader@1cb25f1
      INFO [org.jboss.aop.deployers.AspectDeployer] Deploying xml into org.jboss.aop.AspectManager@3a3e1b for org.apache.catalina.loader.StandardClassLoader@1cb25f1
      INFO [org.jboss.resource.deployers.RARDeployment] Required license terms exist, view vfsfile:/C:/work/apache-tomcat-5.5.26/common/classes/deploy/jboss-local-jdbc.rar/META-INF
      /ra.xml
      INFO [org.jboss.resource.deployers.RARDeployment] Required license terms exist, view vfsfile:/C:/work/apache-tomcat-5.5.26/common/classes/deploy/jboss-xa-jdbc.rar/META-INF/ra
      .xml
      INFO [org.jboss.resource.deployers.RARDeployment] Required license terms exist, view vfsfile:/C:/work/apache-tomcat-5.5.26/common/classes/deploy/jms-ra.rar/META-INF/ra.xml
      INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:De
      faultDS'
      ERROR [org.jboss.messaging.util.ExceptionUtil] org.jboss.messaging.core.jmx.JDBCPersistenceManagerService@1cba87 startService
      java.lang.IllegalArgumentException: No such SQL statement: MOVE_REFERENCE
      at org.jboss.messaging.core.impl.JDBCSupport.getSQLStatement(JDBCSupport.java:184)
      at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:124)
      at org.jboss.messaging.core.impl.JDBCPersistenceManager.start(JDBCPersistenceManager.java:129)
      at org.jboss.messaging.core.jmx.JDBCPersistenceManagerService.startService(JDBCPersistenceManagerService.java:92)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:299)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      ...
      ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] Error installing to Start: name=jboss.messaging:service=PersistenceManager state=Create mode=Manual requir
      edState=Installed
      java.lang.IllegalArgumentException: No such SQL statement: MOVE_REFERENCE
      at org.jboss.messaging.core.impl.JDBCSupport.getSQLStatement(JDBCSupport.java:184)
      at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:124)
      at org.jboss.messaging.core.impl.JDBCPersistenceManager.start(JDBCPersistenceManager.java:129)
      at org.jboss.messaging.core.jmx.JDBCPersistenceManagerService.startService(JDBCPersistenceManagerService.java:92)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:299)
      ..
      Caused by: java.lang.RuntimeException: org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

      *** CONTEXTS MISSING DEPENDENCIES: Name -> Dependency{Required State:Actual State}

      jboss.jca:name=JmsXA,service=ConnectionFactoryBinding
      -> jboss.jca:name=JmsXA,service=TxCM{Create:Configured}

      -> jboss.jca:name=JmsXA,service=TxCM{Start:Configured}

      jboss.jca:name=JmsXA,service=ManagedConnectionFactory
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}

      jboss.jca:name=JmsXA,service=ManagedConnectionPool
      -> jboss.jca:name=JmsXA,service=ManagedConnectionFactory{Create:Configured}
      -> jboss.jca:name=JmsXA,service=ManagedConnectionFactory{Start:Configured}

      jboss.jca:name=JmsXA,service=TxCM
      -> jboss.jca:name=JmsXA,service=ManagedConnectionPool{Create:Configured}
      -> jboss.jca:name=JmsXA,service=ManagedConnectionPool{Start:Configured}

      jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=PostOffice{Create:Configured}

      jboss.messaging.connectionfactory:service=ClusteredConnectionFactory
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=PostOffice{Create:Configured}

      jboss.messaging.connectionfactory:service=ConnectionFactory
      -> jboss.messaging:service=PostOffice{Create:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}

      jboss.messaging.destination:name=DLQ,service=Queue
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=PostOffice{Create:Configured}

      jboss.messaging.destination:name=ExpiryQueue,service=Queue
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=PostOffice{Create:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Create:Configured}

      jboss.messaging:service=PostOffice
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}

      jboss.messaging:service=ServerPeer
      -> jboss.messaging:service=PersistenceManager{Create:**ERROR**}
      -> jboss.messaging:service=PersistenceManager{Start:**ERROR**}


      jboss.mq:service=DestinationManager
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Create:Configured}


      *** CONTEXTS IN ERROR: Name -> Error

      jboss.messaging:service=PersistenceManager -> java.lang.IllegalArgumentException: No such SQL statement: MOVE_REFERENCE


      at org.jboss.embedded.tomcat.EmbeddedJBossBootstrapListener.innerStart(EmbeddedJBossBootstrapListener.java:80)
      at org.jboss.embedded.tomcat.EmbeddedJBossBootstrapListener.lifecycleEvent(EmbeddedJBossBootstrapListener.java:54)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:693)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
      ... 6 more
      Caused by: org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

      *** CONTEXTS MISSING DEPENDENCIES: Name -> Dependency{Required State:Actual State}

      jboss.jca:name=JmsXA,service=ConnectionFactoryBinding
      -> jboss.jca:name=JmsXA,service=TxCM{Create:Configured}
      -> jboss.jca:name=JmsXA,service=TxCM{Start:Configured}

      jboss.jca:name=JmsXA,service=ManagedConnectionFactory
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}

      jboss.jca:name=JmsXA,service=ManagedConnectionPool
      -> jboss.jca:name=JmsXA,service=ManagedConnectionFactory{Create:Configured}
      -> jboss.jca:name=JmsXA,service=ManagedConnectionFactory{Start:Configured}

      jboss.jca:name=JmsXA,service=TxCM
      -> jboss.jca:name=JmsXA,service=ManagedConnectionPool{Create:Configured}
      -> jboss.jca:name=JmsXA,service=ManagedConnectionPool{Start:Configured}

      jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=PostOffice{Create:Configured}

      jboss.messaging.connectionfactory:service=ClusteredConnectionFactory
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=PostOffice{Create:Configured}

      jboss.messaging.connectionfactory:service=ConnectionFactory
      -> jboss.messaging:service=PostOffice{Create:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}

      jboss.messaging.destination:name=DLQ,service=Queue
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=PostOffice{Create:Configured}

      jboss.messaging.destination:name=ExpiryQueue,service=Queue
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=PostOffice{Create:Configured}
      -> jboss.messaging:service=PostOffice{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Create:Configured}

      jboss.messaging:service=PostOffice
      -> jboss.messaging:service=ServerPeer{Create:Configured}
      -> jboss.messaging:service=ServerPeer{Start:Configured}

      jboss.messaging:service=ServerPeer
      -> jboss.messaging:service=PersistenceManager{Create:**ERROR**}
      -> jboss.messaging:service=PersistenceManager{Start:**ERROR**}


      jboss.mq:service=DestinationManager
      -> jboss.messaging:service=ServerPeer{Start:Configured}
      -> jboss.messaging:service=ServerPeer{Create:Configured}


      *** CONTEXTS IN ERROR: Name -> Error

      jboss.messaging:service=PersistenceManager -> java.lang.IllegalArgumentException: No such SQL statement: MOVE_REFERENCE


      at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:576)
      at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(MainDeployerImpl.java:559)
      at org.jboss.embedded.Bootstrap.bootstrapURL(Bootstrap.java:149)
      at org.jboss.embedded.Bootstrap.bootstrap(Bootstrap.java:183)
      at org.jboss.embedded.Bootstrap.bootstrap(Bootstrap.java:195)
      at org.jboss.embedded.tomcat.EmbeddedJBossBootstrapListener.innerStart(EmbeddedJBossBootstrapListener.java:74)
      ... 10 more


      mysql-ds.xml

      <datasources>
       <local-tx-datasource>
       <jndi-name>DefaultDS</jndi-name>
       <connection-url>jdbc:mysql://localhost:3306/etjpadb</connection-url>
       <driver-class>com.mysql.jdbc.Driver</driver-class>
       <user-name>root</user-name>
       <password>password</password>
       <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
       </local-tx-datasource>
      </datasources>