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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with updatable ResultSet
 
Similar Threads
Collection that is synchronized with DataBase
Updatable ResultSet and supporting databases
NX: cacheless design to keep things simple?
JDBC API 2.0 Help...
Populating DropDown Boxes