aspose file tools*
The moose likes JDBC and the fly likes Problem with updatable ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with updatable ResultSet" Watch "Problem with updatable ResultSet" New topic
Author

Problem with updatable ResultSet

Vrushali Gore
Ranch Hand

Joined: Oct 17, 2005
Posts: 40
Dear Sir,

My Resultset is of type sensitive & updatable, So if I try updating the
String field in Resultset then it is writing it as a Integer value in Oracle table(For each Inetger one value, I guess writing unicode).

One more problem I was facing that was I was not able to update any field at a random i.e. 2nd or 3rd directly. Then it gives some error for setPos(.....) at runtime.

Why this happens. Do i have to have serial access on the fields in Resultset? Can't we refer to any field directly?

If anyone can give me solution for this I would be really thankful.

Vrushali
 
wood burning stoves
 
subject: Problem with updatable ResultSet