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


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Problem with updatable ResultSet
 
Similar Threads
Updatable ResultSet and supporting databases
Collection that is synchronized with DataBase
JDBC API 2.0 Help...
NX: cacheless design to keep things simple?
Populating DropDown Boxes