Skip to Content.
Sympa Menu

freetds - Re: JDBC: Protocol confusion retrieving result of "SELECT @@IDENTITY"

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Emmanuel Blot" <eblot AT sablet.grenoble.hp.com>
  • To: freetds
  • Subject: Re: JDBC: Protocol confusion retrieving result of "SELECT @@IDENTITY"
  • Date: Wed, 12 Jul 2000 6:13:32


Hello.

I get the same message while invoking a stored procedure:
java.sql.SQLException:
Protocol confusion- Was expecting a length of 17, got 5
at
com.internetcds.jdbc.tds.ResultSet_base.next(ResultSet_base.java:1542)

with this call:

Statement st = m_connection.createStatement();

if ( st.execute(proc.toString()) )
{
ResultSet rs = st.getResultSet();

while( rs.next() )
// ...

Where proc.toString() returns:
"exec sp_Engine_Order_Create
'8435971295032424','SWDOc963330516781','2000-Jul-11 11:48:36'"

This problem occurs with the mid-may snapshot of FreeTDS JDBC (using the
2.0 files) and also with the last available snapshot.

However, this problem occurs with MS SQL Server 7.00.839 (Driver
3.70.08.20)

but the code works fine with MS SQL Server 7.00.623 (Driver 3.70.06.90) !

Any idea ?





Archive powered by MHonArc 2.6.24.

Top of Page