Updatable ResultSet in PostgreSql9.1 - 【StackMirror】|jdbc|postgresql-9.1

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?

Thanks

jdbc
postgresql-9.1

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