Solved

problelm with JDBC

Posted on 2004-08-02
8
670 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 61

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 61

Expert Comment

by:gheist
ID: 11714645
BTW JDBC does not require scrollable&updateable to work together so SQL exception can be expected.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 8

Author Comment

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Configure Web Service (server application) I. Configure security for Web Services methods First, we need to protect Session bean which implements the service: 1. Open EJB deployment descriptor (ejb-jar.xml) in the EJB project that contains you…
This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now