[freetds] Can't write to DB using stored procedure
Bodo Schulze
bobesch at letras.net
Mon May 18 18:13:01 EDT 2009
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
More information about the FreeTDS
mailing list