I use an application that connects to a SqlAnywhere 11 server/database by issuing the following command (taken from the ConsoleLogFile):
I'd like to emulate the way the application issues the
Most importantly I'd like to prevent a
So, how do I execute unprepared statements and/or prevent rollbacks on errors?
If the goal is to prevent a ROLLBACK of uncommitted transactions at the last time the database went down, the short answer is that you can't.
The long answer is that even if you could, you'd have to deal with potential database issues like check constraints and referential integrity (specifically if wait_for_commit is used). However, you may be able to regain some of this data by applying translated SQL for those uncommitted transactions against the database manually.
answered 05 Nov '14, 16:05