|Subject:||prepared_cache invalid after error|
|Date:||Sun, 10 Oct 2010 22:55:28 +0200|
|To:||"bug-DBI [...] rt.cpan.org" <bug-DBI [...] rt.cpan.org>|
|From:||"Atkins, Damon (contracted)" <Damon.Atkins [...] contracted.pmintl.com>|
For example if you prepare_cache('insert....') (Perl on Win32 ODBC to MSSQL) and then insert a NULL into a non-null field, an execute error occurs. Then you come back to do a valid insert, it freezes at the execute. (I thought I had an SQL dead lock) I found the fix was to delete the dbi hash used by the prepare_cache on execute errror, so that when prepare_cache is called again it is completed from scratch (ie no cache). DBD.pm 9530 2007-05-09 13:05:23Z W32ODBC.pm 8696 2007-01-24 23:12:38Z timbo $ This is perl, v5.8.8 built for MSWin32-x86-multi-thread (with 18 registered patches, see perl -V for more detail) Cheers Damon Show quoted text
________________________________ NOTICE: This e-mail may contain confidential information, which should not be copied or distributed without authorization. If you have received this e-mail message by mistake, please inform the sender and delete it from your system. Please note that, for the efficient preservation of Company records that may be required for litigation, e-mail messages sent to the author of this message will be copied and may be retained in a secure repository.