Skip to Content.
Sympa Menu

freetds - Latest JDBCDriver??

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rajeev" <rajeev.k AT recruitlive.com.au>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: Latest JDBCDriver??
  • Date: Thu, 12 Jul 2001 09:30:18 +1000



Hi All
Can anyone tell me the latest version of FreeTDS JDBC driver . The date in
dd/mm/yy when it was released.
Any help will be appreciated.

cheers
Rajeev

-----Original Message-----
From: bounce-freetds-132882 AT franklin.oit.unc.edu
[mailto:bounce-freetds-132882 AT franklin.oit.unc.edu]On Behalf Of Sean
Sent: Thursday, July 12, 2001 6:41 AM
To: TDS Development Group
Subject: [freetds] CallableStatement - setString method


1. Information:
(1)We are using the latest freetds_jdbc_snapshot.jar dated 03/08/2001.
(2)The version of the TDS protocol: not specified, therefore defaults to
TDS 4.2., also tried setting version to 7.0 in the URL
(3)The version of the JVM: 1.2.2
(4)DBMS: SQL Server 7.0, Platform: WinNT(4.0) Server.
(5)Client machine: Redhat 7.1. Web Server: tomcat 3.2.

2. Details of the problem:
I'm having problems while calling any stored procedure which takes a
varchar and I attempt to use the setString method. If I use the setInt
(although it takes a varchar) to test it, everything works fine but
setString fails. Using setString with a PreparedStatement works fine
however.


BELOW IS A SNIPPLET OF THE CODE CAUSING THE PROBLEM:


Class.forName("com.internetcds.jdbc.tds.Driver").newInstance();
Connection conn =
DriverManager.getConnection("jdbc:freetds:sqlserver://server:1433/S1;TDS=7.0
","user","pass");

CallableStatement stmt = conn.prepareCall("{ sp_ValidateUser(?)");
stmt.setString(1,"username");
ResultSet rs = stmt.executeQuery();
rs.next();
System.out.println("ID: " + rs.getString("custID"));


FAILS WITH THE FOLLOWING ERROR:


java.lang.NullPointerException
at com.internetcds.jdbc.tds.Tds.executeProcedure(Tds.java:2595)
at
com.internetcds.jdbc.tds.PreparedStatement_base.executeCall(PreparedStatemen
t_base.java:199)

at
com.internetcds.jdbc.tds.CallableStatement_base.execute(CallableStatement_ba
se.java:394)

at
com.internetcds.jdbc.tds.PreparedStatement_base.executeQuery(PreparedStateme
nt_base.java:320)

at testee.main(testee.java:21)
Error: java.lang.NullPointerException


Any Help would be much appreciated.

---
You are currently subscribed to freetds as: [rajeev.k AT recruitlive.com.au]
To unsubscribe, forward this message to
$subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page