[RESOLVED] trying to get jdbc program to work

[vb_student]

hey i tried to run this java code after compiling it

// JDBC|Test – complete code
public class JDBCTest {

   public static void main(String args[]){

      RunDB runDB = new RunDB();

      try{
         runDB.loadDriver();
         runDB.makeConnection();
         runDB.buildStatement();
         runDB.executeQuery();
      }catch(Exception e){
         e.printStackTrace();
      }

   }
}

&

//RunDB
import java.sql.*;

public class RunDB {

   Connection connection;
   Statement statement;

   public void loadDriver() throws ClassNotFoundException{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   }

   public void makeConnection() throws SQLException {
      connection=
         DriverManager.getConnection("jdbc:odbc:purchaseOrder");
   }

   public void buildStatement() throws SQLException {
      statement = connection.createStatement();
   }

   public void executeQuery() throws SQLException {

      boolean foundResults =
         statement.execute("SELECT * FROM Transaction");
      if(foundResults){
         ResultSet set = statement.getResultSet();
         if(set!=null) displayResults(set);
      }else {
         connection.close();
      }
   }

   void displayResults(ResultSet rs) throws SQLException {
      ResultSetMetaData metaData = rs.getMetaData();
      int columns=metaData.getColumnCount();
      String text="";

      while(rs.next()){
         for(int i=1;i<=columns;++i) {
            text+="<"+metaData.getColumnName(i)+">";
            text+=rs.getString(i);
             text+="</"+metaData.getColumnName(i)+">";
             text+="n";
         }
         text+="n";
      }

      System.out.println(text);

   }

}

and when i tried to rn the code i get the following errors



E:\Work\programming\java\JavaPrograms>java rundb
Exception in thread "main" java.lang.NoClassDefFoundError: rundb (wrong name: Ru
nDB)
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)

E:\Work\programming\java\JavaPrograms>

what have i done wrong

(i got the code of the following site
http://www.developer.com/design/arti...0925_3571661_3

i have got the code in this folder
E:\Work\programming\java\JavaPrograms

and the database in this folder
E:\Work\programming\java\database

[CornedBee]

java RunDB

not

java rundb

Case is important for Java class names, even on the command line.

And you want

java JDBCTest

anyway, because that class contains the main() method.

[vb_student]

thanks for the reply, so rundb (wrong name: RunDB) is basically dumbo use RunDB not rundb


i did java JDBCTest and got the following error message, i have added a purchaseOrder.mdb to the ODBC Data Source Administrator,


E:\Work\programming\java\JavaPrograms>java JDBCTest
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at RunDB.makeConnection(rundb.java:14)
at JDBCTest.main(jdbctest.java:10)

E:\Work\programming\java\JavaPrograms>

i checked in the System DSN, and the database file does seem to have been added

what am i doing wrong?

[CornedBee]

Sorry, I don't use ODBC, so I can't help you there.

[vb_student]

thanks for the help anyway

you think anyone on this forum might be able to help me

[vb_student]

hey i finally got it to work, i needed to add the file to user DSN database, adding it to the System DSN or the File DSN did not work, interestingly eough the article stated that i needed to add it to the File DSN