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

[catherine matthews]

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.

    
import java.awt.*;
import java.util.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
 
public class TableDemo extends JFrame{
public TableDemo(){
Container contentpane=getContentPane();
contentpane.setLayout(new BorderLayout());
String[] colHeads={"Black","White"};
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
ArrayList values=new ArrayList();
try{
System.out.println("Starting DB");
String filename = "d:/java/mdbTEST.mdb";
String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";DriverID=22;READONLY=true}";
con = DriverManager.getConnection(database, "","");
stmt=con.createStatement();
rs=stmt.executeQuery("SELECT * FROM  Formula");
ResultSetMetaData md = rs.getMetaData();
while(rs.next()){
values.add(rs.getString("Black"));
values.add(rs.getString("White"));
    }
 
System.out.println("size of array"+values.size());
System.out.println("Ending DB");
}catch(SQLException e){
System.out.println("SQL Error :"+e);
}catch(Exception e){
System.out.println("Error :"+e);
}
finally{
try{
if(con!=null){
con.close();
}
}catch(SQLException e) {
System.out.println(e);
}
}
 
int noOfRows=(values.size())/colHeads.length;
int no=0;
Object[][] data=new Object[noOfRows][colHeads.length];
System.out.println("no of records : "+noOfRows);
for(int i=0;i<noOfRows;i++){
for(int j=0;j<colHeads.length;j++){
String s=(String)values.get(no++);
System.out.println("the values" + s );
data[j][no]=s;
}
}
 
JTable table=new JTable(data,colHeads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
contentpane.add(jsp,BorderLayout.CENTER);
setVisible(true);
setSize(200,300);
setTitle("Table Demo");
}
public static void main(String args[]){
TableDemo t=new TableDemo();
 
     }
}

[Freddy Wong]

Have you included the JDBC driver in your application?

[catherine matthews]

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

  import java.awt.*;
import java.util.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
 
public class TableDemo extends JFrame{
public TableDemo(){
Container contentpane=getContentPane();
contentpane.setLayout(new BorderLayout());
String[] colHeads={"Black","White"};
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
ArrayList values=new ArrayList();
try{
[B]Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");[/B]
System.out.println("Starting DB");
String filename = "d:/java/mdbTEST.mdb";
String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";DriverID=22;READONLY=true}";
con = DriverManager.getConnection(database, "","");
stmt=con.createStatement();
rs=stmt.executeQuery("SELECT * FROM  Formula");
ResultSetMetaData md = rs.getMetaData();
while(rs.next()){
values.add(rs.getString("Black"));
values.add(rs.getString("White"));
    }
 

System.out.println("size of array"+values.size());
System.out.println("Ending DB");
}catch(SQLException e){
System.out.println("SQL Error :"+e);
}catch(Exception e){
System.out.println("Error :"+e);
}
finally{
try{
if(con!=null){
con.close();
}
}catch(SQLException e) {
System.out.println(e);
}
}
 
int noOfRows=(values.size())/colHeads.length;
int no=0;
Object[][] data=new Object[noOfRows][colHeads.length];
System.out.println("no of records : "+noOfRows);
for(int i=0;i<noOfRows;i++){
for(int j=0;j<colHeads.length;j++){
String s=(String)values.get(no++);
System.out.println("the values" + s );
data[j][no]=s;
}
}
 
JTable table=new JTable(data,colHeads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
contentpane.add(jsp,BorderLayout.CENTER);
setVisible(true);
setSize(200,300);
setTitle("Table Demo");
}
public static void main(String args[]){
TableDemo t=new TableDemo();
 
     }
}  

[Suraj Berwal]

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