[jboss-user] [EJB 3.0] - problem using embeded ejb3.0

[sudam.sahu]

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)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4003883#4003883

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4003883