Hello all,

  I am having a problem with the Oracle database and servlets.
I created a statement which is CONCUR_UPDATABLE. But after i execute the
query when i try to update a column in the result set. I am getting an
exception saying that "you cannot update a read-only result set.

I am using the latest jdbc driver for oracle and the oracle database version
is 8.1.7. I tried with an application but the result is same.

My code is as follows...

try{
  connect to the database..
  Statement stmt =
con.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE);
 ResultSet rs = ..
}

When i try to display the state of the result set i am getting it as
CONCUR_READ_ONLY.

Any suggestions?

Thanks in advance
Rosh

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to