FreeTDS Development Group

["Rajeev" <rajeev.k AT recruitlive.com.au>]

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')