File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes updateable and scrollable resultset for oracle driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "updateable and scrollable resultset for oracle driver" Watch "updateable and scrollable resultset for oracle driver" New topic
Author

updateable and scrollable resultset for oracle driver

sinasi susam
Ranch Hand

Joined: Jul 15, 2005
Posts: 67
I created an updateable and scrollable Resultset for Oracle database.
I can update a specific column and scroll down and up too.
I can insert a row in insert row too.

If i commit (its setted to autocommiting to false) the connection then it places the row to table too.

But The problem is ;
for some reason i can't see the inserted row when i scrolled back to the first row and print the rows in a loop.

Here is how i am tring to do that ,


Is there something wrong with my code ?
Its thin driver.Or something wrong with my driver?

Thank you.
[ September 12, 2006: Message edited by: sinasi susam ]
sinasi susam
Ranch Hand

Joined: Jul 15, 2005
Posts: 67
Anybody did'nt have any opinion?

Any experience about this?

Do i have to set some more things to achieve that?
Rajesh Agarwal
Ranch Hand

Joined: Aug 01, 2005
Posts: 79
I somehow feel that the row could have been inserted, but what makes you say that this would be the first row.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: updateable and scrollable resultset for oracle driver
 
Similar Threads
Updating a ResultSet
Updateable ResultSet just for doing inserts: good idea?
oracle thin driver scrollable resultset.absolute(1) is not returing the first row
ResultSet is not updateable.
JDBC API 2.0 Help...