JDBC: Protocol confusion retrieving result of " SELECT @@IDENTITY"
Maraya Michael
maraya-michael at dol.gov
Wed Jul 12 11:16:18 EDT 2000
I believe it's "select convert(decimal(17), @@identity)". Use this
instead of "select @@identity". That should keep the JDBC driver happy
until it gets patched.
> ----------
> From: Emmanuel Blot[SMTP:eblot at jijia12.grenoble.hp.com]
> Sent: Wednesday, July 12, 2000 11:09 AM
> To: TDS Development Group
> Subject: [freetds] Re: JDBC: Protocol confusion retrieving result of
> " SELECT @@IDENTITY"
>
> Sorry, I am a beginner in both SQL and JDBC.
>
> How should I write this cast (and where) ?
>
> Thanks,
> Emmanuel.
>
> ----- Original Message -----
> From: "Maraya Michael" <maraya-michael at dol.gov>
> To: "TDS Development Group" <freetds at franklin.oit.unc.edu>
> Sent: Wednesday, July 12, 2000 4:04 PM
> Subject: [freetds] Re: JDBC: Protocol confusion retrieving result of "
> SELECT @@IDENTITY"
>
>
> > In the meanwhile, a work-around for this is to explicitly cast it as
> DECIMAL
> > 17.
> >
> > > ----------
> > > From: Bob Kline[SMTP:bkline at rksystems.com]
> > > Sent: Wednesday, July 12, 2000 9:38 AM
> > > To: TDS Development Group
> > > Subject: [freetds] Re: JDBC: Protocol confusion retrieving result of
> > > "SELECT @@IDENTITY"
> > >
> > > On Wed, 12 Jul 2000, Emmanuel Blot wrote:
> > >
> > > > 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)
> > > > but the code works fine with MS SQL Server 7.00.623 (Driver
> 3.70.06.90)
> > > !
> > > >
> > > > Any idea ?
> > > >
> > >
> > > This problem is fixed by the latest patches which Craig is in the
> > > process of merging into the repository.
> > >
> > > --
> > > Bob Kline
> > > mailto:bkline at rksystems.com
> > > http://www.rksystems.com
> > >
> > >
> > > ---
> > > You are currently subscribed to freetds as: maraya-michael at dol.gov
> > > To unsubscribe, forward this message to
> > > $subst('Email.Unsub')
> > >
> >
>
>
> ---
> You are currently subscribed to freetds as: maraya-michael at dol.gov
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ibiblio.org/pipermail/freetds/attachments/20000712/7bb0cd8f/attachment.html
More information about the FreeTDS
mailing list