THIS IS A REPLY TO THIS THREAD:
http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ I am missing something (aside from not knowing what JBoss/Tomcat versions you are running) I'd say you only need to do this:
Change this:
dataSource = (DataSource)ic.lookup("jdbc/Agency");
To This:
dataSource = (DataSource)ic.lookup("java:/agencyDS");
I should note that in all my comparable examples and projects I DID NOT have any support in my ejb-jar.xml file. I also was not *required* to create jboss.xml so I didn't! (meaning it worked without one, so I didn't bother)
I simply defined the datasource in mysql-service.xml and then used the exact name that is output when deploying that xml file. (Of course not as my first try, but it made sense and worked immediately when I did.) It seems you are all set on the -service.xml file, if not let me know and I can gather more info.
As always, please post a follow up and let others know what works or what does not.
thanks & good luck,
Ryan