freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Helen Woods" <hw AT rms-telecomms.com>
- To: freetds AT franklin.oit.unc.edu
- Subject: freetds_jdbc.jar install problems
- Date: Wed, 1 Aug 2001 00:19:37 -0400
I am running SQLServer 7 on NT 4 sp6a.
Have downloaded freetds_jdbc.jar and have put this into classpath via
JBuilder4 - project properties - source.
My test program fails with ClassNotFound Exception. I have done a lot of
looking around to find the problem without success.
Test Prog snippet:
import java.io.*;
import java.util.*;
import java.sql.*;
public class TestTDSDriver {
static void main(String args[]){
TestTDSDriver test = new TestTDSDriver();
test.ftdsjdbc();
}
static void ftdsjdbc () {
try {
java.sql.DriverManager.setLogStream(System.out);
String url = "jdbc:freetds:sqlserver://Rasserver/ACE";
Class.forName("com.internetcds.jdbc.tds.Driver");
//open a connection to the database
Connection connection = DriverManager.getConnection(url, "sa",
"");
.....
And the exception log:
D:\Program Files\JBuilder4\jdk1.3\bin\javaw -classic -classpath
"D:\JavaProj\BillRun\classes;D:\Program
Files\JBuilder4\jdk1.3\demo\jfc\Java2D\Java2Demo.jar;D:\Program
Files\JBuilder4\jdk1.3\jre\lib\i18n.jar;D:\Program
Files\JBuilder4\jdk1.3\jre\lib\jaws.jar;D:\Program
Files\JBuilder4\jdk1.3\jre\lib\rt.jar;D:\Program
Files\JBuilder4\jdk1.3\jre\lib\sunrsasign.jar;D:\Program
Files\JBuilder4\jdk1.3\lib\dt.jar;D:\Program
Files\JBuilder4\jdk1.3\lib\tools.jar;D:\JavaProj\BillRun\classes\freetds_jdbc.jar"
TestTDSDriver D:\Docs\AceWorking\out.txt D:\Docs\AceWorking\local.csv
D:\Docs\AceWorking\IDD.csv
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[className=com.internetcds.jdbc.tds.Driver,com.internetcds.jdbc.tds.Driver@feec445d]
DriverManager.getConnection("jdbc:freetds:sqlserver://Rasserver/ACE")
trying
driver[className=com.internetcds.jdbc.tds.Driver,com.internetcds.jdbc.tds.Driver@feec445d]
java.sql.SQLExceptionException- java.lang.NullPointerException
at
com.internetcds.jdbc.tds.Constructors.newConnection(Constructors.java:305)
at com.internetcds.jdbc.tds.Driver.connect(Driver.java:257)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at TestTDSDriver.ftdsjdbc(TestTDSDriver.java:17)
at TestTDSDriver.main(TestTDSDriver.java:8)
getConnection failed: java.sql.SQLException
java.sql.SQLException
at
com.internetcds.jdbc.tds.Constructors.newConnection(Constructors.java:305)
at com.internetcds.jdbc.tds.Driver.connect(Driver.java:257)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at TestTDSDriver.ftdsjdbc(TestTDSDriver.java:17)
at TestTDSDriver.main(TestTDSDriver.java:8)
Can anyone throw any light on my problem here? Is the driver installed
okay? Is the problem in not connecting to the database? If so, any
suggestions as to what I should do next? My url variable appears to be
correct format as per readme file, see code snippet.
Thanks,
helen
- freetds_jdbc.jar install problems, Helen Woods, 08/01/2001
Archive powered by MHonArc 2.6.24.