Solved

Cannot find tables using JDBC to MySQL database

Posted on 2002-07-24
8
310 Views
Last Modified: 2010-04-01
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
Comment
Question by:jruit718
  • 2
  • 2
  • 2
  • +1
8 Comments
 
LVL 6

Expert Comment

by:kotan
ID: 7176116
can you provide the code (test.jsp) ?
0
 

Author Comment

by:jruit718
ID: 7177539
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
 
LVL 19

Expert Comment

by:cheekycj
ID: 7178963
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Expert Comment

by:kotan
ID: 7179004
The table and field name in mysql are case sensitive. Please double check.
0
 

Author Comment

by:jruit718
ID: 7180398
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
 
LVL 19

Expert Comment

by:cheekycj
ID: 7180458
ok.

Please as Community Support to delete this question.

CJ
0
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 7181100
This question will be placed in PAQ, and points refunded.

Regards,

ComTech
Community Support Administrator  
Experts-Exchange  
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Original post  on Monitis Blog. Web performance monitoring is broken into two camps: passive and active. Passive monitoring is defined as looking at real-world historical performance by monitoring actual log-ins, site hits, clicks, requests for…
In order to fulfill our mission of inspiring learning in the technology community, Experts Exchange is launching a Course of the Month program. Premium and Team Account members will have access to one course per month as a part of their membership, …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question