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]
Can anyone point me the right direction to get this up and running please?
Thanks in advance
Joined: Jul 21, 2011
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.