1. Check ur connection with the database.
2. Check Oracle docs if it suppourts scrollable and is insensitive to
updates
>hello all,
>
>I have a small problem. I just want to create an updatable resultset.
>
>1. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>
>2. Connection conn =
>DriverManager.getConnection("jdbc:odbc:DSNName","user","pw");
>
>3. Statement stmt = conn.createStatement
>(ResultSet.TYPE_SCROLL_INSENSITIVE,
>ResultSet.CONCUR_UPDATABLE);
>
>4. ResultSet rs = stmt.executeQuery("SELECT * FROM MYTable");
>
>when I run this I get the foll. error at line 3
>
>java.lang.UnsupportedOperationException
> at sun.jdbc.odbc.JdbcOdbcConnection.createStatement(Unknown Source)
> at myPasswordTest.main(myPasswordTest.java, Compiled Code)
>
>
>I use JDK 1.2 and Oracle database.
>
>any suggesstions?
>
>Thanks in advance
>ram
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>___________________________________________________________________________
>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
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
___________________________________________________________________________
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
