<div>
Then keep on using MS Access with JDBC support....<br />
(MS Access locks all records and scrolls using interface controls....)
</div>


Then keep on using MS Access with JDBC support....
(MS Access locks all records and scrolls using interface controls....)

<div>
I'd prefer using plain vanilla SQL.
</div>


<div>
BTW JDBC does not require scrollable&amp;updateable to work together so SQL exception can be expected.<br />

</div>


BTW JDBC does not require scrollable&updateable to work together so SQL exception can be expected.


<div>
hi all,<br />
thanx, i had solve it.
</div>


<div>
looks like you are right here
</div>


<div>
hi,<br />
&nbsp; &nbsp;the solution is to change the driver<br />
thanx
</div>


hi,
   the solution is to change the driver
thanx

<div>
<div class="content wysiwyg-content">
Hi every body,<br />
&nbsp;i`am facing a problem with JDBC API method ( deleteRow ). I want to use this method to delete a row of data from the result set which is &quot;scrollable and updatable&quot;.<br />
but i get the following sql exception : <br />
&nbsp; &nbsp; Invalid operation for read only resultset<br />
<br />
&nbsp;i`m using Oracle 9i as a database server, and sending the requests from JSP files.<br />
&nbsp; &nbsp; &nbsp; &nbsp; The connection is stablished via the Oracle driver &quot;oracle.jdbc.driver.Oracle<wbr />Driver&quot;<br />
<br />
actually, i tried this method with MS Access and it`s working probarly. <br />
<br />
Thanx alot
</div>
</div>


Hi every body,
 i`am facing a problem with JDBC API method ( deleteRow ). I want to use this method to delete a row of data from the result set which is "scrollable and updatable".
but i get the following sql exception : 
    Invalid operation for read only resultset

 i`m using Oracle 9i as a database server, and sending the requests from JSP files.
        The connection is stablished via the Oracle driver "oracle.jdbc.driver.OracleDriver"

actually, i tried this method with MS Access and it`s working probarly. 

Thanx alot

problelm with JDBC

Java application servers that support the Java EE platform and features include JOnAS from Object Web, WildFly (formerly JBoss AS) from JBoss, Geronimo from Apache, TomEE from Apache, Resin Java Application Server from Caucho Technology, Blazix from Desiderata Software, Enhydra Server from Enhydra.org, and GlassFish from Oracle. Commercial Java app servers include WebLogic by Oracle, WebSphere from IBM and the open source JBoss Enterprise Application Platform (JBoss EAP) by Red Hat.