Using Scrollable resultset
1 posts in topic
Flat View  Flat View

Posted By:   Rajeev_Patkie
Posted On:   Wednesday, August 7, 2002 03:43 AM

I am using Oracle as a database and trying to connect it with Java using JDBC2.Also I am using Oracle driver i.e type 4 drivers.
When I give query like
rs=stmt.executeQuery("select ename from emp")
the code works fine for rs1.moveToInsertRecord();
But when I give
rs=stmt.executeQuery("select * from emp")
it gives error message stating that invalid method for read only resultset.
Don't understand why the same can't work for select * type of query.
Any solution to this probs???
Waiting for the response

Thanks And Regards


Re: Using Scrollable resultset

Posted By:   Anonymous  
Posted On:   Thursday, August 8, 2002 03:41 AM

I encountered the same problem. After searching the internet, I read somewhere that oracle 8 does not support select * from table for updatable resultset. Seems like we have to specify the columns one by one....

Can anyone confirm on this?
About | Sitemap | Contact