This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC auto-commit  RSS feed

 
sam jose
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

Following is my understanding about setAutoCommit(boolean autoCommit) and setTransactionIsolation(int level) (both from java.sql.Connection ) :

'If I create a new db connection and use setAutoCommit(false), then perform some DB manipulation and closes the connection, by default the new connections will be in auto-commit mode.'

But if I am getting the connection object from the db connection pool, then performing the same operations and closes connection , what will be the status of that particular connection object instance when I use it again from the pool; will it be in 'auto-commit' mode or 'non-auto-commit' mode ?

Pls share your ideas

thanks in advance.

Sam
 
Dhanya Palanisamy
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi sam,

As for i know, auto commit will be false even if we get connections from connection pool and you have to commit before closing the connection.

Dhanya
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!