FreeTDS Development Group

["Mark O'Donohue" <mark.odonohue AT ludwig.edu.au>]

I have a similar situation to that below.

A problem with prepared statement.

I am using MSSQL6.5, and not in a transaction (autocommit = true).

The first call to a prepared cursor works fine, read through the results
ok.

The second call to the prepared statment ends throwing an exception:
at
com.internetcds.jdbc.tds.PreparedStatement.executeQuery(PreparedStatement.java:325)



The statment is a very simple of the form "select max(x) from table;"



> Hello all,
> 
> I have just started testing the freeTDS within our environment and I have
> already run into an issue.  I was curious if anyone has seen the same
> behavior:
> 
> A section of our code shuts the autocommit off so we can manage a
> transaction boundery.  In other words, we are going to a couple
> updates/inserts and we want them to all commit or all rollback.  One of the
> select statements is a PREPARED statement.
> 
> It appears when the prepared statement is executed, the freeTDS driver just
> "hangs".  It acts as if it is waiting for a response from the database
> server, but it never comes.
> Looking at the code, it appears as if a prepared statement is turned into a
> stored procedure (it is given a name determined by the driver) and the
> driver then attempts to execute the stored procedure.
> 
> Has anyone else seen this behavior.  Remember I am doing all this within one
> database transaction!
> I am using Microsoft SQLServer 7.0.
> 
> Thanks in advance for the help!
> 
> Michael.