1 Reply Latest reply on Dec 18, 2003 9:06 AM by Mike Shoemaker

    MySQL: Table doesn't exist error, but it does

    Mike Shoemaker Newbie

      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?