Skip to Content.
Sympa Menu

freetds - Re: [freetds] Can't write to DB using stored procedure

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bodo Schulze <bobesch AT letras.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Can't write to DB using stored procedure
  • Date: Mon, 18 May 2009 22:13:01 +0000

Thanks again for your help. We tracked the error down. Indeed it was not
a FreeTDS issue, but a matter of correctly using DBD::Sybase with
placeholders AND an output param that returns error codes. The docs
aren't very clear on this point, IMHO.

Thanks again,

Bodo

> Bodo Schulze wrote:
> > util.c:162:Changed query state from READING to IDLE
> > token.c:2232: rows_affected = 0
> > util.c:110:logic error: cannot change query state from IDLE to PENDING
> > ct.c:1157:ct_results() process_result_tokens returned 1 (type 4053)
> > </freetds.log>
> >
> > So there's a "logic error". Lines 2216-2221 indicate that the state is
> > changed from READING to IDLE on certain conditions
>
> That "logic error" line is just a note to the developers and other
> hackers.
>
> The client tracks the state of the TDS connection so that it can return
> errors to the client if requests are made out of order. (That also helps
> avoid the server spanking us by dropping the connection for sending
> invalid packets.) In this case, the client is behaving correctly, but the
> library isn't tracking the state correctly; somewhere we missed an update
> to the state from IDLE to "sending query" or something like that.
>
> HTH.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page