It seems like your server is looking for jndi MySqlDS but you have configured as “jdbc/JackalopeDB”, in mysql-ds.xml,
I am not sure if "MySqlDS" is the only valid jndi name for DBSource in JBoss, but certainly server knows this is a MYsql DBSource and looking for it by the name "MySqlDS"..
Try this:
1.change “jdbc/JackalopeDB” back to “MySqlDS” in mysql-ds.xml,
2.seems you are using mysql connector driver, In this case, this would better be changed: <driver-class>org.gjt.mm.mysql.Driver</driver-class> to: <driver-class>com.mysql.jdbc.Driver</driver-class>,
3.drop the mysql-ds.xml in %JOSS_DIST% /server/default/deploy
4.restart the jboss at
http://localhost:8080/jmx-console/, under jboss.jca, make sure this line is there: name=MySqlDS,service=LocalTxCM , or you could check with server log to see if this message is there: 2003-06-21 21:04:17,578 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.MySqlDS] Binding object 'org.jboss.resource.adapter.jdbc.WrapperDataSource@1a76eff' into JNDI at 'java:/MySqlDS',
5.change look up in your code to use “MySqlDS”
good luck.
bill