OK Jeff, lets try one more time...
What is the error message you are getting if any? Use trace() (for proper
usage see 'perldoc DBI'), then submit the trace ouput to the list.
Ilya Sterin
-----Original Message-----
From: jeff knot
To: Sterin, Ilya
Cc: [EMAIL PROTECTED]
Sent: 05/02/2001 10:48 PM
Subject: RE: DBI buffer commit
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
