File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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
Author

EJB 2.1 JDBC resource references

Dimargio Guedes
Greenhorn

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


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
Greenhorn

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.

Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: EJB 2.1 JDBC resource references