Define "does not work"
Have you used jndiview on the management
console to check jndi.
I don't recognise the class name.
Do you have the resource-ref in ejb-jar.xml?
I tried with and without the classname, and it didn't have any effect. "does not work" is defined as the jndi lookup not getting the correct datasource. I believe it is getting the default datasource becasue the sql statement does run but the codes throws an sql exception saying the table does not exist.
I know it's not a database problem, or a database user problem, or a permission problem because when I take the <resource-manager> tag out of the jboss.xml file and put it into the conf/standardjboss.xml file, then I get the expected datasource and the query succeeds.