Uwe Heldt writes:
> Hi Venu,
>
> it ' s hard to send you sample code. The database access is coded over more
> then one class which dynamicly build sql statements. The only thing i know
> is, that first a simple select is performed. After that one update on the
> same table row and then a select again. Could id be that there is a lock on
> this row if the statements appear to quickly? What does means "Communication
> Link failure" in this context?
>
> Thanks Uwe
>
>
To answer you shortly : No, it is not possible that there is a lock on
the row. If you use MyISAM tables, then you should know that there are
no row locks in MyISAM.
Second, we need a full test case, including tables and code in order
to fix a bug, if there is any.
"Communication ..." error may come up if there was an incongruency in
code sequence. This can happen if all rows from result set have not
been fetched and you have issued another query.
In that case that is an error in application code.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
