aspose 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 Spring in Action this week in the Spring 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: updateable and scrollable resultset for oracle driver