Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 681
  • Last Modified:

problelm with JDBC

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
0
Ahmed Merghani
Asked:
Ahmed Merghani
1 Solution
 
gheistCommented:
Then keep on using MS Access with JDBC support....
(MS Access locks all records and scrolls using interface controls....)
0
 
alikoankCommented:
I'd prefer using plain vanilla SQL.
0
 
gheistCommented:
BTW JDBC does not require scrollable&updateable to work together so SQL exception can be expected.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Ahmed MerghaniAuthor Commented:
hi all,
thanx, i had solve it.
0
 
gheistCommented:
looks like you are right here
0
 
Ahmed MerghaniAuthor Commented:
hi,
   the solution is to change the driver
thanx
0
 
NetminderCommented:
Closed, 125 points refunded.
Netminder
Site Admin
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now