EJB 2.1 JDBC resource references

[Dimargio Guedes]

Hi all,

Going straight to the point:

EJB 2.1
MSSQL
JBoss 5.1.0 GA

In the EJB deployment descriptor (ejb-jar.xml) I have:

<session id="Session_SendMail">
         <description><![CDATA[An EJB used to send e-mail notifications]]></description>
         <display-name>SendMail</display-name>

         <ejb-name>SendMail</ejb-name>

         <home>pt.linguistica.ejb.mail.SendMailHome</home>
         <remote>pt.linguistica.ejb.mail.SendMail</remote>
         <local-home>pt.linguistica.ejb.mail.SendMailLocalHome</local-home>
         <local>pt.linguistica.ejb.mail.SendMailLocal</local>
         <ejb-class>pt.linguistica.ejb.mail.SendMailSession</ejb-class>
         <session-type>Stateless</session-type>
         <transaction-type>Container</transaction-type>

         <resource-ref id="ResRef_1">
            <res-ref-name>jdbc/TESTEDS</res-ref-name>
            <res-type>javax.sql.DataSource</res-type>
            <res-auth>Container</res-auth>
         </resource-ref>

      </session>

In standardjboss.xml I have:

<enterprise-beans>
  <session>
    <ejb-name>SendMail</ejb-name>
    <resource-ref>
      <res-ref-name>jdbc/TESTEDS</res-ref-name>
      <jndi-name>java:TESTE</jndi-name>
    </resource-ref>
  </session>
</enterprise-beans>

In the deploy root I have a file named mssql-ds.xml which relevant content is:

<local-tx-datasource>
    <jndi-name>TESTE</jndi-name>
    <connection-url>jdbc:jtds:sqlserver://localhost:2423/TESTE;tds=8.0;lastupdatecount=true</connection-url>
    <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
    <user-name>uteste</user-name>
    <password>dbuteste</password>
   <!--
    	sql to call on an existing pooled connection when it is obtained from pool
    -->
    <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>      
  </local-tx-datasource>

Then in the SendMail EJB I have:

Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/TESTEDS");
Connection cnn = ds.getConnection();
Statement stmt = cnn.createStatement();   
ResultSet rs = stmt.executeQuery("SELECT 1");

Which throws an Execption because it's expecting the FROM keyword in the statement. This is falling to DefaultDS (Hypersonic) and not using the jdbc/TESTEDS.
Exception message is: java.sql.SQLException: Unexpected token , requires FROM in statement [SELECT 1]

If I lookup for the DataSource using:

DataSource ds = (DataSource) ctx.lookup("java:TESTE");

It works... but things are not done like this.

Can anyone point me the right direction to get this up and running please?

Thanks in advance

[Dimargio Guedes]

Hi all,

After taking a break and coming back up to this, I found a solution.

I created a file named jboss.xml in the META-INF folder and moved inside it the contents I previously added to standardjboss.xml:

<jboss>
  <enterprise-beans>
      <session>
         <ejb-name>SendMail</ejb-name>
         <resource-ref>
             <res-ref-name>jdbc/TESTEDS</res-ref-name>
             <jndi-name>java:/TESTE</jndi-name>
        </resource-ref>
     </session>
  </enterprise-beans>
</jboss>

Now everything works, but I think that there should be a better way of doing this. This way I'm configuring the DataSource inside the EJB JAR, making it JBoss dependent. If I move this to another App Server things will not work again I suppose.

But for now it's ok to me.

Thanks