How to get the datasource from Bean through deployment descriptor

[Mike Thomson]

I am using MySql with JBoss4.2.2.GA. I have configured the web.xml and jboss-web.xml and mysql-ds.xml properly and I can able to get the datasource from the Servlet without any problem.

In the same way, when I tried to retrieve the datasource from the Entity bean, I am getting the following exception:

11:14:56,190 INFO  [EJBDeployer] Undeploying: file:/C:/Mike/Software/jboss-4.2.2.GA/jboss-4.2.2.GA/server/default/tmp/deploy/tmp56552HelloApp.ear-contents/HelloEJB.jar
11:14:56,381 INFO  [EARDeployer] Undeploying J2EE application, destroy step: file:/C:/Mike/Software/jboss-4.2.2.GA/jboss-4.2.2.GA/server/default/deploy/HelloApp.ear
11:14:56,381 INFO  [EARDeployer] Undeployed J2EE application: file:/C:/Mike/Software/jboss-4.2.2.GA/jboss-4.2.2.GA/server/default/deploy/HelloApp.ear
11:14:56,400 INFO  [EARDeployer] Init J2EE application: file:/C:/Mike/Software/jboss-4.2.2.GA/jboss-4.2.2.GA/server/default/deploy/HelloApp.ear
11:14:57,020 WARN  [NestedThrowable] Duplicate throwable nesting of same base type: class org.jboss.deployment.DeploymentException is assignable from: class org.jboss.deployment.DeploymentException
11:14:57,028 ERROR [MainDeployer] Could not initialise deployment: file:/C:/Mike/Software/jboss-4.2.2.GA/jboss-4.2.2.GA/server/default/deploy/HelloApp.ear
org.jboss.deployment.DeploymentException: Failed to parse WEB-INF/jboss-web.xml; - nested throwable: (org.jboss.deployment.DeploymentException: ejb-ref jdbc/test found in jboss-web.xml but not in web.xml)
	at org.jboss.web.AbstractWebContainer.parseMetaData(AbstractWebContainer.java:768)
	at org.jboss.web.AbstractWebContainer.init(AbstractWebContainer.java:356)
	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.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
	at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
	at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
	at org.jboss.deployment.SubDeployerInterceptorSupport.init(SubDeployerInterceptorSupport.java:119)
	at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.init(SubDeployerInterceptorSupport.java:172)
	at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:87)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy45.init(Unknown Source)
	at org.jboss.deployment.MainDeployer.init(MainDeployer.java:872)
	at org.jboss.deployment.MainDeployer.init(MainDeployer.java:895)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:809)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
	at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy9.deploy(Unknown Source)
	at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
	at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:610)
	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)
	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225)
Caused by: org.jboss.deployment.DeploymentException: ejb-ref jdbc/test found in jboss-web.xml but not in web.xml
	at org.jboss.metadata.WebMetaData.importJBossWebXml(WebMetaData.java:1111)
	at org.jboss.metadata.WebMetaData.importXml(WebMetaData.java:770)
	at org.jboss.web.AbstractWebContainer.parseMetaData(AbstractWebContainer.java:763)
	... 42 more

My web.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app >
   <distributable/>
   <servlet>
      <servlet-name>Compute</servlet-name>
      <display-name>Name for Compute</display-name>
      <description><![CDATA[Description for Compute]]></description>
      <servlet-class>com.web.ComputeServlet</servlet-class>
   </servlet>

   <servlet-mapping>
      <servlet-name>Compute</servlet-name>
      <url-pattern>/Compute</url-pattern>
   </servlet-mapping>

   <resource-ref >
      <description><![CDATA[DB Connection]]></description>
      <res-ref-name>jdbc/test</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
   </resource-ref>

   <ejb-ref >
      <description><![CDATA[Reference to the Hello EJB]]></description>
      <ejb-ref-name>ejb/Hello</ejb-ref-name>
      <ejb-ref-type>Session</ejb-ref-type>
      <home>com.interfaces.HelloHome</home>
      <remote>com.interfaces.Hello</remote>
   </ejb-ref>
   <ejb-ref >
      <description><![CDATA[Reference to the Hello Stateful EJB]]></description>
      <ejb-ref-name>ejb/HelloStateful</ejb-ref-name>
      <ejb-ref-type>Session</ejb-ref-type>
      <home>com.interfaces.HelloStatefulHome</home>
      <remote>com.interfaces.HelloStateful</remote>
   </ejb-ref>
</web-app>

My jboss-web.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jboss-web PUBLIC "-//JBoss//DTD Web Application 2.3//EN" "http://www.jboss.org/j2ee/dtd/jboss-web_3_0.dtd">

<jboss-web>
   <!-- EJB References -->
   <ejb-ref>
      <ejb-ref-name>ejb/Hello</ejb-ref-name>
      <jndi-name>ejb/Hello</jndi-name>
   </ejb-ref>
   <ejb-ref>
      <ejb-ref-name>ejb/HelloStateful</ejb-ref-name>
      <jndi-name>ejb/HelloStateful</jndi-name>
   </ejb-ref>
   <ejb-ref>
      <ejb-ref-name>jdbc/test</ejb-ref-name>
      <jndi-name>java:MySqlDS</jndi-name>
   </ejb-ref>

  <!-- EJB Local References -->
</jboss-web>

[/code
My ejb-jar.xml
[code]
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd">

<ejb-jar >
   <description><![CDATA[No Description.]]></description>
   <display-name>Generated by XDoclet</display-name>
   <enterprise-beans>

      <!-- Session Beans -->
      <session >
         <description><![CDATA[Description for Hello]]></description>
         <display-name>Name for Hello</display-name>

         <ejb-name>Hello</ejb-name>

         <home>com.interfaces.HelloHome</home>
         <remote>com.interfaces.Hello</remote>
         <ejb-class>com.ejb.HelloBean</ejb-class>
         <session-type>Stateless</session-type>
         <transaction-type>Container</transaction-type>

      </session>

      <session >
         <description><![CDATA[Description for HelloStateful]]></description>
         <display-name>Name for HelloStateful</display-name>

         <ejb-name>HelloStateful</ejb-name>

         <home>com.interfaces.HelloStatefulHome</home>
         <remote>com.interfaces.HelloStateful</remote>
         <ejb-class>com.ejb.HelloStatefulBean</ejb-class>
         <session-type>Stateful</session-type>
         <transaction-type>Container</transaction-type>

      </session>

      <!-- Entity Beans -->
      <entity >
         <description><![CDATA[Description for HelloBMPEntity]]></description>
         <display-name>Name for HelloBMPEntity</display-name>

         <ejb-name>HelloBMPEntity</ejb-name>

         <home>com.interfaces.HelloBMPEntityHome</home>
         <remote>com.interfaces.HelloBMPEntity</remote>

         <ejb-class>com.ejb.HelloBMPEntityBean</ejb-class>
         <persistence-type>Bean</persistence-type>
         <prim-key-class>java.lang.Integer</prim-key-class>
         <reentrant>False</reentrant>

      </entity>
   </enterprise-beans>

   <assembly-descriptor >

   </assembly-descriptor>

</ejb-jar>

My jboss.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jboss PUBLIC "-//JBoss//DTD JBOSS 3.0//EN" "http://www.jboss.org/j2ee/dtd/jboss_3_0.dtd">
<jboss>
   <enterprise-beans>
      <entity>
         <ejb-name>HelloBMPEntity</ejb-name>
         <jndi-name>ejb/HelloBMPEntity</jndi-name>    
	 <ejb-ref>
            <ejb-ref-name>ejb/jdbc/test</ejb-ref-name>
            <jndi-name>java:MySqlDS</jndi-name>
         </ejb-ref>	 
      </entity>
      <session>
         <ejb-name>Hello</ejb-name>
         <jndi-name>ejb/Hello</jndi-name>
      </session>
      <session>
         <ejb-name>HelloStateful</ejb-name>
         <jndi-name>ejb/HelloStateful</jndi-name>
      </session>
   </enterprise-beans>
   <resource-managers>
   </resource-managers>
</jboss>

How to get the datasource from deployment descriptor from the Entity Bean. Whether we need to configure in both ejb-jar.xml and jboss.xml, as we did for web.xml and jboss-web.xml?

Between, the forums new look and feel and features are amazing!!!
And I have also looked for this attachment feature for the long time!!

[Jaikiran Pai]

This in jboss-web.xml is incorrect:

 <ejb-ref>
      <ejb-ref-name>jdbc/test</ejb-ref-name>
      <jndi-name>java:MySqlDS</jndi-name>
   </ejb-ref>

You are mapping a datasource here, so this should have been a resource-ref and not a ejb-ref.

Between, the forums new look and feel and features are amazing!!!
And I have also looked for this attachment feature for the long time!!

Yes, the new forum has brought in a lot of good features If you have any words of encouragement, suggestions feel free to post them in this thread