transaction « postgresql « Java Database Q&A





1. Restrict postges access from java clients by using java program on a server    stackoverflow.com

Perhaps this question is not very clear but I didn't find better words for the heading, which describes the problem I like to deal with shortly. I want to restrict access from ...

2. JDBC: Can I share a connection in a multithreading app, and enjoy nice transactions?    stackoverflow.com

It seems like the classical way to handle transactions with JDBC is to set auto-commit to false. This creates a new transaction, and each call to commit marks the beginning the ...

3. Concurrent process inserting data in database    stackoverflow.com

Consider following schema in postgres database.

CREATE TABLE employee
(
  id_employee serial NOT NULL PrimarKey,
  tx_email_address text NOT NULL Unique,
  tx_passwd character varying(256)
)
I have a java class which does following
conn.setAutoComit(false);

ResultSet ...

4. Can a transaction have many threads?    stackoverflow.com

Generally We have some business logic that is causing a bottle neck within a transaction. The business logic queries the database for a set of data (read only), processes it, and returns ...

5. How to set the transaction isolation level of a    stackoverflow.com

How do I set the global transaction isolation level for a postgres data source. I'm running on jboss and I'm using hibernate to connect. I know that I can set the isolation level ...

6. Problem in inserting more number of records if it is transaction based    stackoverflow.com

In our application we allow user to enter email ids comma separated. We take the email ids separate it and insert as records in a table. When they enter email ids less than ...

7. Nested transactions - Rollback scenario    stackoverflow.com

A(){
con.begin;
.........
.........
B();
........
........(con.rollback;)
con.commit;
}

B{
con.begin;
.......
.......
con.commit;
}
In the above code, I begin a new DB transaction at A(). It executes some transaction successfully. After that B() starts executing and it also executes some transaction successfully now the ...

8. Continue Postgres transaction with exceptions in Java    stackoverflow.com

The insert method below insert links on a table in the database (PostgreSQL), but if a error occurs, the rest of transaction is affected and dont works. The exception is because ...