FreeTDS Development Group

[Thomas Pridham <TPridham AT CMCTPA.COM>]

The newer snapshot did the trick.  However, I am now faced with a new
problem.  I set autoCommit to false, performed three inserts and then call
commit.  The commit call is resulting in the following error (but the data
is committed):

SQLException: java.sql.SQLException: This method should only be  used when
auto commit has been disabled.

here is a snippet of the code:
_conn.setAutoCommit(false);
_state.executeUpdate(_strSQL); (3 inserts are performed)
_conn.commit();

If I switch drivers, the code works properly.  It is acting like autoCommit
is true even though I set it to false.

Any ideas?


-----Original Message-----
From: Craig Spannring [mailto:Craig.Spannring AT aedinc.net]
Sent: Tuesday, January 16, 2001 12:15 PM
To: TDS Development Group
Subject: [freetds] Re: NullPointerExceptions




If you're using JDK 1.3 you'll need to grab a snapshot that supports
JDK 1.3, namely one more recent than June 2000.


Tom Pridham writes:
 > We are using the Orion application server and are attempting to connect
to
 > MS SQL Server 7.0 with the free tds jdbc driver.
 > 
 > The driver we are loading is:
 > com.internetcds.jdbc.tds.Driver
 > 
 > Our URL is:
 > jdbc:freetds:sqlserver://localhost:1433/MedHistoryCard sa 
 > 
 > All we get is three NullPointerExceptions....are we using the correct URL
 > and driver to connect?  I am able to connect using other ($$$) commercial
 > drivers.
 > 

=======================================================================
 Life is short.                  | Craig Spannring 
      Bike hard, ski fast.       | cts AT internetcds.com
 --------------------------------+------------------------------------
  When all you've got is Perl, everything feels like a smashed thumb
=======================================================================

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