This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

CONCUR_UPDATABLE  RSS feed

 
ram kumar
Ranch Hand
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey JDBC !

I made a code something of this sort

con.createConnection(resultset.TYPE_FORWARD_ONLY,RESULTSET.CONCUR_UPDATABLE)

For getting updatable result sets

Came to know ! that every other result set like con.createConnection();

is READ_ONLY !


My requirement is :

I have to read all the columns in a row one by one and update a column in that row named ROW_STATUS !

Code Snippet


Am not sure of what happens exactly ! behind the scene !

Is JDBC generating queries for updating rows.

AnyHow, to my knowledge a copy of the resultset will be maintained in the JVM.

I think when i say

resultset.updateString("ROW_STATUS","Y")

this local copy is updated !

Only when i say updateRow(); this gets updated to DB!

How come resultset.getString("ROW_STATUS");

immediately would say Y

:roll:
  • Is that from the DB or from the Local copy maintained in the JVM.
  • If not, is the JDBC, writes queries to retrive the column ROW_STATUS
  • when i say resultset.getString("ROW_STATUS")


  • What Happens Exactly !

    Could someone describe in detail the working of this code !

    Please correct me if am not in the right direction !

    [ September 22, 2008: Message edited by: ram kumar ]
    [ September 22, 2008: Message edited by: ram kumar ]
     
    Don't get me started about those stupid light bulbs.
    • Post Reply Bookmark Topic Watch Topic
    • New Topic
    Boost this thread!