avatar
Set autocommit off# Database - 数据库
s*m
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.
avatar
m*t
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.

avatar
s*m
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?

avatar
m*t
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.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。