1. Database Connection Settings Retrieved From a JNDI Connection Pool stackoverflow.comI 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.comwe 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.comHi 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 ... |
5. does Connection commit on close()? coderanch.comHi, 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.comThanks 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 ... |