Updatable ResultSet in PostgreSql9.1

Go To StackoverFlow.com


I am working on Postgresql9.1 DB and JDBC, and want to update column value , but for doing so DB software must support updatable resultset , does 9.1 version support Updatable resultsets?


2012-04-04 06:35
by Ravi Jain
what is your question - Balaswamy Vaddeman 2012-04-04 06:37
I want to update column value in ResultSet but for doing that DB software must support Updateable ResultSet - Ravi Jain 2012-04-04 06:39
for better and faster help edit your questio - Balaswamy Vaddeman 2012-04-04 06:40
You can always use Statement.executeUpdate() which I find much cleaner anyway. But if you are already working with it, it will take you only a couple of minutes to try it out - a_horse_with_no_name 2012-04-04 06:46


yes it does. see ResultSet.CONCUR_UPDATABLE as Parameter of your Statements factory method.

2012-04-05 01:01
by Mar Cel
I tried an updatable ResultSet using a select on view and was unable to edit it. Using Postgresql 9.2 jdbc jar - cavila 2014-05-30 21:58