Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

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?
0
jruit718
Asked:
jruit718
  • 2
  • 2
  • 2
  • +1
1 Solution
 
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
 
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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
 
ComTechCommented:
This question will be placed in PAQ, and points refunded.

Regards,

ComTech
Community Support Administrator  
Experts-Exchange  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now