I have found that the problem ocuurs in many
cases. For example, I use
sqlload userid=scott/tiger control=load log=load.log
to upload my data to the oracle. Once the data file
is very long. The same problem also occurs: it is stuck.
Jeff
>From: "Sterin, Ilya" <[EMAIL PROTECTED]>
>To: jeff knot <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: RE: DBI buffer commit
>Date: Wed, 2 May 2001 21:31:44 -0400
>
>Didn't know that SUN bought Oracle, but these days you never know,
>especially when both of them are more focused on overthrowing Mico$oft than
>their product:-) Kidding...
>
>Did you explicitly set AutoCommit => 0, if not you must do that in order to
>use commit().
>Not sure what is overflowing and why, did you get an error message? How do
>you know it's overflowing? Use trace() (see 'perldoc DBI') to get the
>trace
>output and send to list.
>
>Ilya Sterin
>
>-----Original Message-----
>From: jeff knot [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, May 02, 2001 6:14 PM
>To: [EMAIL PROTECTED]
>Subject: DBI buffer commit
>
>
>Hi,
>I am new to this list and I have the following question:
>
>My database is SUN Oracle. I try to use
>perl DBI to update the record:
>$sth=$dbh->prepare("update mytable set filed=mynewrecord
> where id=?");
>$sth->execute ($i);
>After doing the above over 1000 lines, my database stucks. I guess my
>buffer
> overflow. Then
>I use $dbh->commit; trying to clear the buffer, but
>it is not working. I am wondering if there is a solution.
>
>Jeff
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
