wood burning stoves*
The moose likes EJB and other Java EE Technologies and the fly likes EJB 2.1 JDBC resource references Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB 2.1 JDBC resource references" Watch "EJB 2.1 JDBC resource references" New topic

EJB 2.1 JDBC resource references

Dimargio Guedes

Joined: Jul 21, 2011
Posts: 2
Hi all,

Going straight to the point:

EJB 2.1
JBoss 5.1.0 GA

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

In standardjboss.xml I have:

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

Then in the SendMail EJB I have:

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:

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

Joined: Jul 21, 2011
Posts: 2
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:

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.

I agree. Here's the link: http://aspose.com/file-tools
subject: EJB 2.1 JDBC resource references
Similar Threads
Error in deploying stateless session bean 2.1 on Jboss 5 GA
"jndi:ejb not bound" error while deploying EJB
How to get Connection through JNDI Datasource.
Not Finding DataSource in JNDI Tree
JBoss JSTL Datasource issue