I have done this for oracle, but shd be same for mysql too.
1. place yr db driver in <jboss_home>\server\default\lib
2. copy mssql-service.xml file from <jboss_home>\docs\examples\jca to <jboss_home>\server\default\deploy directory.
3. make the userid/passwd config in this xml, this also had config for the connection pool.
4. lookup this datasource from yr code.
Hope this helps.
What can I do if I do not want to lookup the datasource in my code?
I'm using several entity beans. They all grab their data from an oracle-database over my JBoss 3.0.4.
Now, I got one entity which should grab its data from a MySQL-DataSource.
The Oracle DataSource is defined as default in server/default/conf/standardjbosscmp-jdbc.xml.
How can I define a second datasource especially for this one bean?
How can I tell the bean to use this source then...?
I tried a few times using a special jbosscmp-jdbc.xml file for this bean, but it doesn't work!
Please help me! Thanx!