File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Error :java.sql.SQLException: No suitable driver" Watch "SQL Error :java.sql.SQLException: No suitable driver" New topic
Author

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
Greenhorn

Joined: Dec 28, 2001
Posts: 26
Hi,

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,
Suraj
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Error :java.sql.SQLException: No suitable driver