RE: VB/ADO/RDO/DAO/OHNO/UHOH and transactions
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 May 2004 13:35:52 -0600
The default for all these is that transactions are handled "stupidly". =20
In both ODBC and OLE DB (which all these API's are built on), the
default is to autocommit, so every successful SQL statement is
automatically committed. All these API's will have an option to disable
autocommit, in which case you will have to call an explicit commit
procedure.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jesse, Rich
Sent: Thursday, May 13, 2004 9:45 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: VB/ADO/RDO/DAO/OHNO/UHOH and transactions
Hey all,
After an interesting TAR on why an SMON process would be eating up 250MB
=3D of memory, I find that we may need to adjust the transactions on our
VB =3D programs. Seeing as the only VB I've done consisted of a
full-screen =3D button that said "Click Me", I have no clue as to how
transactions are =3D handled in the various DB interfaces like ADO, RDO,
DAO, or whatever =3D we're using.
Anyone know a good online resource for this? Google has oodles of =3D
fragments, but I don't know enough to know which might be "better". It
=3D would also help if I knew what DB library(ies) we're using... =
<blush>
TIA,
Rich
Rich Jesse System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
