@Resource injection not working for DataSource

[pulkit mehra]

Hi Ranchers,

I am facing some problem in getting datasource from JNDI using @Resource annotation.
My server is JBoss5.1 and EJB 3.0.
My DS file

     <local-tx-datasource>
                  <jndi-name>titanDatasource</jndi-name> 
                   <use-java-context>false</use-java-context>       <!-- for binding it to Global JNDI Space -->
	    <connection-url>jdbc:postgresql://localhost:5432/titan</connection-url>
                    <driver-class>org.postgresql.Driver</driver-class>
                    <user-name>username</user-name>
                     <password>password</password>
      </local-tx-datasource>  

My Persistence.xml

        <persistence-unit name="titan">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <jta-data-source>titanDatasource</jta-data-source>     /* 'java:/' is not used because of<use-java-context> is false */
        <properties>

            <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
            <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
            <property name="hibernate.hbm2ddl.auto" value="validate"/>
            <property name="jboss.entity.manager.factory.jndi.name" value="java:/titanEntityManagerFactory"/>
            <property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/>
            <property name="hibernate.default_schema" value="titan"/>
        </properties>
    </persistence-unit>

StatelessBean

         
           @Stateless
           @Local(TransactionalScopedStateless.class)
            public class TransactionalScopedStatelessBean implements TransactionalScopedStateless{
    
              @Resource(mappedName = "titanDatasource ")
              DataSource titanDatasource;

               public void check(){
                   System.out.println("datasource : "+titanDatasource);
              }
          }

Web Client(local in Server EAR)

       TransactionalScopedStateless ref = null;
        try {
            Context jndiContext = new javax.naming.InitialContext();
           TransactionalScopedStateless ref = (TransactionalScopedStateless) jndiContext.lookup("aerocar-ear/TransactionalScopedStatelessBean/local");
        } catch (NamingException e) {
            e.printStackTrace();         
       }
        ref.check();

Problem Faced:
1)Not able to get statelessbean instance as resource injection getting failed.I have checked JMX console's JNDI view.
I am able to locate titanDatasource in Global section as well as in stateless bean ENC(linking global JNDI titanDatasource)
ServerError is :

Caused by: java.lang.RuntimeException: Unable to inject jndi dependency: env/com.aerocar.persistence_context.TransactionalScopedStatelessBean/titanDatasource into property com.aerocar.persistence_context.TransactionalScopedStatelessBean.titanDatasource: titanDatasource  not bound
..
Caused by : javax.naming.NameNotFoundException: titanDatasource  not bound
..

2)I am confused between @Resource attribute name and mappedName My understanding is MappedName reference Global JNDI attributes where as name reference ENC attributes;

Please helpe me!!

[pulkit mehra]

Hi Friends ,

My server unexpectedly start working in above said scenario .Cant rely on open source servers but here what i have learned :

1)DS can be binded to java namespace or into Global JNDI section using <use-java-context> in DS file.
2)Always use DI names as per binding:
If used <use-java-context> true then mappedName = 'java:/titanDatasource'
If used <use-java-context> false then mappedName = 'titanDatasource'