This week's book giveaway is in the JDBC forum.
We're giving away four copies of Make it so: Java DB Connections & Transactions and have Marcho Behler on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with updatable ResultSet" Watch "Problem with updatable ResultSet" New topic

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.

I agree. Here's the link:
subject: Problem with updatable ResultSet
jQuery in Action, 3rd edition