FreeTDS Development Group

[qasim AT mail.com]

Hi, I am using the following code (below) and its compiling OK and I get
following from javac. But when I run the DBDriver1 class I get "Class Not
Found: com.internetcds.jdbc.tds.Driver". I am baffled as to the error. Any
help would be greatly appreciated. Thanks in advance.

C:\javaproj>javac -g -verbose -classpath C:\jdk1.3.1\lib\freetds_jdbc.jar
DBDriv
er1.java
[parsed DBDriver1.java in 310 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/sql/DriverManager.class) in 20 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/sql/Connection.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/sql/SQLException.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/Object.class) in 10 ms]
[checking class TableMaker]
[loaded
C:\jdk1.3.1\lib\freetds_jdbc.jar(com/internetcds/jdbc/tds/Statement.clas
s) in 20 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/Throwable.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/io/Serializable.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/sql/Statement.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/Exception.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/String.class) in 10 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/Comparable.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/System.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/Class.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/ClassNotFoundException.class)
in 0
ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/io/PrintStream.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/io/FilterOutputStream.class) in 0
ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/io/OutputStream.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/io/IOException.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/Error.class) in 0 ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/RuntimeException.class) in 0
ms]
[loaded c:\jdk1.2.2\jre\lib\rt.jar(java/lang/StringBuffer.class) in 10 ms]
[wrote TableMaker.class]
[checking class DBDriver1]
[wrote DBDriver1.class]
Note: DBDriver1.java uses or overrides a deprecated API.  Recompile with
"-depre
cation" for details.
1 warning
[done in 772 ms]
--------------------------------------------------------------------------

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import com.internetcds.jdbc.tds.*;

class TableMaker{
Connection con = null;
Statement stmt;
        
public boolean createCatalog(){
boolean result = true;
String dbURL = "jdbc:freetds:sqlserver://99.999.999.9:1433/DBNAME";
                
try{
DriverManager.setLogStream(System.out);
try{
Class.forName("com.internetcds.jdbc.tds.Driver");
con = DriverManager.getConnection(dbURL);
}
catch (ClassNotFoundException cnfe){
System.out.println("Class Not Found: " + cnfe.getMessage());
}
catch(SQLException sqle){
System.out.println("SQL Exception: " + sqle.getMessage());
return false;
}
}
catch(Exception e){
System.out.println("Exception: " + e.getMessage());
return false;
}               
return true;
}
}
public class DBDriver1{
public static void main (String[] args){
TableMaker tmOne = new TableMaker();
tmOne.createCatalog();
}
}