freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Can't write to DB using stored procedure
- 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
-
[freetds] Can't write to DB using stored procedure,
Bodo Schulze, 05/15/2009
-
Re: [freetds] Can't write to DB using stored procedure,
James K. Lowden, 05/16/2009
-
Re: [freetds] Can't write to DB using stored procedure,
Bodo Schulze, 05/18/2009
-
Re: [freetds] Can't write to DB using stored procedure,
James K. Lowden, 05/18/2009
- Re: [freetds] Can't write to DB using stored procedure, Bodo Schulze, 05/18/2009
-
Re: [freetds] Can't write to DB using stored procedure,
James K. Lowden, 05/18/2009
-
Re: [freetds] Can't write to DB using stored procedure,
Bodo Schulze, 05/18/2009
-
Re: [freetds] Can't write to DB using stored procedure,
James K. Lowden, 05/16/2009
Archive powered by MHonArc 2.6.24.