Solved

problelm with JDBC

Posted on 2004-08-02
8
673 Views
Last Modified: 2013-12-01
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
Comment
Question by:Ahmed Merghani
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 11702101
Then keep on using MS Access with JDBC support....
(MS Access locks all records and scrolls using interface controls....)
0
 
LVL 4

Expert Comment

by:alikoank
ID: 11712755
I'd prefer using plain vanilla SQL.
0
 
LVL 62

Expert Comment

by:gheist
ID: 11714645
BTW JDBC does not require scrollable&updateable to work together so SQL exception can be expected.
0
Industry Leaders: 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!

 
LVL 8

Author Comment

by:Ahmed Merghani
ID: 11751038
hi all,
thanx, i had solve it.
0
 
LVL 62

Expert Comment

by:gheist
ID: 11838022
looks like you are right here
0
 
LVL 8

Author Comment

by:Ahmed Merghani
ID: 11839293
hi,
   the solution is to change the driver
thanx
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 11866714
Closed, 125 points refunded.
Netminder
Site Admin
0

Featured Post

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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Where is my Java compiler located 3 1,733
hashcode is calculated on the basis of value object 2 124
WebLogic 12c - "Unexpected CryptoAPI failure" 9 454
starOut java challenge 95 195
Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question