Set autocommit off - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Set autocommit off

Set autocommit off# Database - 数据库

s*m2003-08-27 07:08

1 楼

How do i set auto commit off in VB script if i use oraoledb driver? I want to
do a transaction but the autocommit is on by default.
Thanks.

m*t2003-08-27 07:08

2 楼

Why don't you just explicitly abort(or rollback) if anything goes wrong?

【在 s***m 的大作中提到】

: How do i set auto commit off in VB script if i use oraoledb driver? I want to
: do a transaction but the autocommit is on by default.
: Thanks.

s*m2003-08-27 07:08

3 楼

to
I my case, i need to insert multiple tables. I want to either insert into all
tables or no data is inserted. If i do rollback, it only rolls back the
current insert. Previous insert will not be rolled back. Do i miss something?
Thanks.

【在 m******t 的大作中提到】

:
: Why don't you just explicitly abort(or rollback) if anything goes wrong?

m*t2003-08-27 07:08

4 楼

I'm not familiar with VBS, but there should be a way to explicitly
demarcate a transaction, i.e., something like transaction.begin(), and
at some later point either transaction.commit() or transaction.rollback().
At least that's how it works in Java with Oracle (and IIRC it's similar
in ODBC as well).

【在 s***m 的大作中提到】

:
: to
: I my case, i need to insert multiple tables. I want to either insert into all
: tables or no data is inserted. If i do rollback, it only rolls back the
: current insert. Previous insert will not be rolled back. Do i miss something?
: Thanks.