Cannot find tables using JDBC to MySQL database

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

Root cause:
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?
jruit718Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ComTechConnect With a Mentor Commented:
This question will be placed in PAQ, and points refunded.

Regards,

ComTech
Community Support Administrator  
Experts-Exchange  
0
 
kotanCommented:
can you provide the code (test.jsp) ?
0
 
jruit718Author Commented:
This is the code I'm using.....

<%@ page import="java.sql.*" %>
<%
String connectionURL="jdbc:mysql://localhost/icore?user=icore&password=thepass";
Connection connection = null;
java.sql.Statement statement = null;
ResultSet rs = null;
%>

<html><body>

<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM ARTICLE;");

while (rs.next()) {
out.println(rs.getString("title")+"<br>");
}



rs.close();
%>

</body></html>
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
cheekycjCommented:
are you sure table article exists and your user has permission to view/access it?

Maybe you have to qualify the database.. like test.Article or whatever.

Just ideas.

CJ
0
 
kotanCommented:
The table and field name in mysql are case sensitive. Please double check.
0
 
jruit718Author Commented:
Never Mind... I found the problem... Seems that there was 2 databases of similar names "icore" and "icore;" one was empty and one was not. I must have created it by mistake.

Thanks for your help.
0
 
cheekycjCommented:
ok.

Please as Community Support to delete this question.

CJ
0
All Courses

From novice to tech pro — start learning today.