Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
catherine matthews
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 959
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you included the JDBC driver in your application?
 
catherine matthews
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic