Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to set DDLCommitBehavior

energydMay 10 2016 — edited May 14 2016

TimesTen: Release: 11.2.2.6.12

We are writing some scripts to automate schema changes(through ddl and dml files) during our software releases. We are using ttIsql in our script. We want the behavior to be that whenever there is an error in any of the ddl/dml, timesten could exit and rollback. So that we can be sure that either all the scripts are committed or none is.

So, I guess we need to set Autocommit=0 and DDLCommitBehavior=1. (Please correct me if I'm wrong)

While we could set autocommit in the ttIsql connection string, we cannot find how to set DDLCommitBehavior correctly. Please advice how can we set DDLCommitBehavior using ttIsql.

Thanks,

D

This post has been answered by ChrisJenkins-Oracle on May 12 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2016
Added on May 10 2016
9 comments
1,795 views