commit « Connection « Java Database Q&A

1. Database Connection Settings Retrieved From a JNDI Connection Pool    stackoverflow.com

I have Hosted a data source on the websphere server and i wanted make use of that datasource through my application clients. After retrieving the database connection from the JNDI datasource i ...

2. Auto commit transactions if not explicitly committed or rolledback    stackoverflow.com

we use Weblogic server and always set autoCommit to 'false' when getting Connection to Oracle 10g. I want to know if there is a setting in Weblogic wherein it will automatically ...

3. Does a Connection commit on close?    coderanch.com

Hi It means database is supporting the the autocommit property. So here is what should happen By default autocommit is true, it will commit as soon as sql is fired through java, whether you close the connection or not. Rollback is of no use in this case If autocommit is set to false, only and only if you say conn.commit, the ...

4. is there any condition that a connection stop until another connection commit?    coderanch.com

5. does Connection commit on close()?    coderanch.com

Hi, I tried searching on google about the fact that when we close connection whether it gets commited in database itself. I was unable to locate any mention of this on Java Doc API. So i think it is a moot point and may be left to implementation. I noticed in DB2 it does so , which means that it commit ...

6. Difference between connection.commit and usertransaction.commit    coderanch.com

Thanks Jeanne, If a transaction contains multiple database connections, then its a distributed /XA transaction right? Lets keep it as multiple i/o operations with the same database. which can be commit/rollback either using a single usertransaction or connection. When we use UserTransaction the transaction manager/service uses a default timeout (which if we want, we can overwrite using setTransactionTimeout method) But if ...