hi,
Try using the oracle thin driver instead of the jdbc-odbc bridge.
regards
Nagaraj.
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Hai
Ram
Sent: Tuesday, December 19, 2000 9:57 AM
To: [EMAIL PROTECTED]
Subject: out of topic - JDBC Problem
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
