File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQL Error :java.sql.SQLException: No suitable driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Error :java.sql.SQLException: No suitable driver" Watch "SQL Error :java.sql.SQLException: No suitable driver" New topic

SQL Error :java.sql.SQLException: No suitable driver

catherine matthews
Ranch Hand

Joined: Jan 22, 2006
Posts: 78
As i run the code below to get the values for "black" and "white" columns, i am getting the errors as below. Please give me some giudance on how to get the value from each column and place it in a Jtable. Thank YOu soo much.
Freddy Wong
Ranch Hand

Joined: Sep 11, 2006
Posts: 959

Have you included the JDBC driver in your application?

SCJP 5.0, SCWCD 1.4, SCBCD 1.3, SCDJWS 1.4
My Blog
catherine matthews
Ranch Hand

Joined: Jan 22, 2006
Posts: 78
Hi, i have added the highlighted code. Is the JDBC driver you meant?
But i still get error as below

Starting DB
SQL Error :java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine could not find the object 'White'. Make sure the object exists and that you spell its name and the path name correctly.
no of records : 0

White is my column name. I cant understand this error message

Suraj Berwal

Joined: Dec 28, 2001
Posts: 26

Is WHITE column existing in the table Formula?

Please can you run the query on your MS-Access DB and check whether you are getting data for both BLACK and WHITE columns...

Kind Regards,
subject: SQL Error :java.sql.SQLException: No suitable driver
It's not a secret anymore!