Peter Johnson wrote:DBCP??
For connection to MySQL, you will need a *-ds.xml file for MySQL. There is an example one at docs/examples/jca. Change it to match your database and give it a unique JNDI name.
In your app, you can look up the data source via the JNDI name, and from there get the JDBC session and from there on its is all JDBC.