Cannot find tables using JDBC to MySQL database
Posted on 2002-07-24
I have set up:
- a JSP connection to a MySQL database using Tomcat
- on my Windows 2000 machine
- I have also downloaded the "MySQL driver mm.mysql-2.0.4-src.jar" and placed it in tomcat/lib.
I have set up a table called "article" and added several columns. I have also set up test.jsp which connects to the database and reads the columns.
My problem is that when I run "test.jsp" I get the following error...
Internal Servlet Error:
javax.servlet.ServletException: General error: Table 'icore.article' doesn't exist
java.sql.SQLException: General error: Table 'icore.article' doesn't exist
My table does exsist and I have checked it using the same SQL statement as in my JSP code.
Any ideas if this is a code error, or config error or something else?