Are you try change type of cursor?
----- Original Message -----
From: "Rosh Nair" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 9:54 AM
Subject: Servlets and Oracle
> 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
___________________________________________________________________________
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
