Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connection query

 
Prabhleen Kaur
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using JDBC connection to get the resultset. I am using same JDBC connection to update some records of same table. This update is happening in different thread. It is working. My question is:
Should I lock the connection when I do update or resultset.next()
If not, will resultset.next() give me correct data or there can be potential problem
 
L Goundalkar
Ranch Hand
Posts: 395
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
You can use ResultSet.TYPE_SCROLL_SENSITIVE result sets to fetch data. But once it reads from the database, it can't see the changes made from other transactions.
So you can call the refreshRow() to get the latest data from the database.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic