I want to use savepoint feature inside a function in PostgreSQL. I read that savepoint cannot be used inside functions in Postgres. But while I rollback, I want to rollback to a specific point be...

Ora-01086 : save point was not established or invalid. KRD_UPD_BORCTAHSILATYAP_SP this SP throws errors . When I test this loop below, I get the error: ora-01086 Normally it works without calling...

We're trying to have a custom User model and behaviors, but then we noticed that even the default Django installation has issue when adding a new User via the Django Admin: The issue happens ev...

I have generic jdbc code that works with all kinds of databases. I have some apis that work with transactions and savepoints. The problem is that some databases require you to release the savepoi...

I'm using JavaEE/JPA managed transactions with Oracle DB und Hibernate and need to achieve some kind of nested transaction. As far as I've learned such thing is not supported out of the box but I s...

I am trying to understand Savepoints and Transactions in SQLite. I had the following commands on a Table/Database and I am using Savepoints. SAVEPOINT aaa; RELEASE aaa; BEGIN; Now, if I execute ...

I have a JDBC code where there are multiple Savepoints present; something like this: 1st insert statement 2nd insert statement savepoint = conn.setSavepoint("S1"); 1st insert statement 2nd update ...

I have multiple updates and insert statements in a procedure. Please refer below example: Procedure Example --code Update 1 insert 1 Update 2 Update 3 --Suppose exception occurs Now i want ...

I have a JavaEE application using Hibernate to connect to the database. In some part of my application I have calls to method which have a @Transactional annotation. In some of these cases, I want ...

I'm attempting to use savepoints with the sqlite3 module built into python 2.6. Every time I try to release or rollback a savepoint, I always recieve an OperationalError: no such savepoint. What am...

The issue is i m using save or update in hibernate on temporary base... now when i finally fire update it will store it in DB permanently otherwise rollback it.. how to make save point using hibe...

My SQLite-based application currently uses transactions - both for being able to rollback and for improving performance. I'm considering replacing all transactions with savepoints. The reason is th...

I'm trying to achieve some kind of nested transaction behavior using NHibernate's transaction control and FlushMode options, but things got a little bit confusing after too much reading, so any con...

Right now the process that we're using for inserting sets of records is something like this: (and note that "set of records" means something like a person's record along with their addresses, phon...