File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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