Solved

problelm with JDBC

Posted on 2004-08-02
8
671 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
JMS Tibco queue/topic : how to get messages count of queue? 7 329
jersey import error 8 106
how to find the dependencies of an EAR or WAR 4 72
xyzMiddle java challenge 33 97
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…
Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

774 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