Solved

problelm with JDBC

Posted on 2004-08-02
8
672 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
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
Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

 
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

-Xmx and -Xms are the two JVM options often used to tune JVM heap size.   Here are some common mistakes made when using them:   Assume BigApp is a java class file for the below examples. 1.         Missing m, M, g or G at the end …
There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

827 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