My datasource looks like this.
<local-tx-datasource>
<jndi-name>MyDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/databasename</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>user</user-name>
pass
</local-tx-datasource>
I can login with the username/password that is contained here and query the tables directly without
any problems. Everytime I try to access the database from within a web app, I get an exception like
the following.
2003-12-18 08:44:33,490 INFO [STDOUT] Exception Occurred:General error, message from server: "Table 'databasename.TABLENAME' doesn't exist"
2003-12-18 08:44:33,492 ERROR [STDERR] java.lang.NullPointerException
Any ideas?
I figured it out, tablename was case sensitive. Damn that was a long process for something that simple :)