0 Replies Latest reply on Jan 19, 2007 11:00 AM by sudam sahu

    problem using embeded ejb3.0

    sudam sahu Newbie

      hi,
      i m using embeded ejb 3.0 with hibernate entity manager to test junit test cases.
      i have already configured all the files to deal with mysql database.
      but while i m running the test cases i m getting the following errors.
      is it necessary to chanfge any code in the jboss-jms-beans.xml file.
      i have already configured embeded-jboss-beans.xml,persistence.xml file.
      is there any more files need to be change.
      if any one feel so then please suggest me.
      if any one feel any confusion then please let me know i will send acrross the entire code.

      b]21:14:31,819 WARN [BeanSchemaBinding] You should use the 2.0 version of the Microcontainer xml. xmlns='urn:jboss:bean-deployer:2.0'
      21:14:32,272 INFO [LocalTxDataSource] Bound datasource to JNDI name 'java:/DefaultDS'
      21:14:33,256 ERROR [AbstractKernelController] Error installing to Start: name=jboss.mq:service=PersistenceManager state=Create
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Every derived table must have its own alias)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:442)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1571)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.jboss.joinpoint.plugins.reflect.ReflectMethodJoinPoint.dispatch(ReflectMethodJoinPoint.java:72)
      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions.dispatchJoinPoint(KernelControllerContextActions.java:96)
      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$LifecycleAction.installAction(KernelControllerContextActions.java:476)
      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$KernelControllerContextAction.install(KernelControllerContextActions.java:171)
      at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
      at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:226)
      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:593)
      at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:346)
      at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:438)
      at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:379)
      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:225)
      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:151)
      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBean(AbstractKernelDeployer.java:291)
      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBeans(AbstractKernelDeployer.java:261)
      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deploy(AbstractKernelDeployer.java:117)
      at org.jboss.kernel.plugins.deployment.xml.BeanXMLDeployer.deploy(BeanXMLDeployer.java:95)
      at org.jboss.ejb3.embedded.EJB3StandaloneBootstrap.deployXmlResource(EJB3StandaloneBootstrap.java:82)
      at com.wmg.gcdm.JUnitTest.GCDMTest.startupEmbeddedJboss(GCDMTest.java:73)
      at com.wmg.gcdm.JUnitTest.GCDMTest.setUp(GCDMTest.java:62)
      at junit.framework.TestCase.runBare(TestCase.java:125)
      at junit.framework.TestResult$1.protect(TestResult.java:106)
      at junit.framework.TestResult.runProtected(TestResult.java:124)
      at junit.framework.TestResult.run(TestResult.java:109)
      at junit.framework.TestCase.run(TestCase.java:118)
      at junit.framework.TestSuite.runTest(TestSuite.java:208)
      at junit.framework.TestSuite.run(TestSuite.java:203)
      at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
      at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
      at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
      Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Every derived table must have its own alias
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:403)
      ... 40 more
      21:14:33,303 ERROR [AbstractKernelController] Error installing to Configured: name=jboss.mq:service=StateManager state=Instantiated
      java.lang.IllegalArgumentException: Null value metadata
      at org.jboss.kernel.plugins.config.Configurator.getPropertySetterJoinPoint(Configurator.java:487)
      at org.jboss.kernel.plugins.config.Configurator.getPropertySetterJoinPoint(Configurator.java:434)
      at org.jboss.kernel.plugins.config.Configurator.getPropertySetterJoinPoints(Configurator.java:398)
      at org.jboss.kernel.plugins.config.AbstractKernelConfigurator.getPropertySetterJoinPoints(AbstractKernelConfigurator.java:112)
      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$ConfigureAction.installAction(KernelControllerContextActions.java:337)
      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$KernelControllerContextAction.install(KernelControllerContextActions.java:171)
      at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
      at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:226)
      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:593)
      at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:346)
      at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:438)
      at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:379)
      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:225)
      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:151)
      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBean(AbstractKernelDeployer.java:291)
      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBeans(AbstractKernelDeployer.java:261)
      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deploy(AbstractKernelDeployer.java:117)
      at org.jboss.kernel.plugins.deployment.xml.BeanXMLDeployer.deploy(BeanXMLDeployer.java:95)
      at org.jboss.ejb3.embedded.EJB3StandaloneBootstrap.deployXmlResource(EJB3StandaloneBootstrap.java:82)
      at com.wmg.gcdm.JUnitTest.GCDMTest.startupEmbeddedJboss(GCDMTest.java:73)
      at com.wmg.gcdm.JUnitTest.GCDMTest.setUp(GCDMTest.java:62)
      at junit.framework.TestCase.runBare(TestCase.java:125)
      at junit.framework.TestResult$1.protect(TestResult.java:106)
      at junit.framework.TestResult.runProtected(TestResult.java:124)
      at junit.framework.TestResult.run(TestResult.java:109)
      at junit.framework.TestCase.run(TestCase.java:118)
      at junit.framework.TestSuite.runTest(TestSuite.java:208)
      at junit.framework.TestSuite.run(TestSuite.java:203)
      at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
      at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
      at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)