Do this.
>1. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>
>2. Connection conn =
>DriverManager.getConnection("jdbc:odbc:DSNName","user","pw");
>
>3. Statement stmt = conn.createStatement("SELECT * FROM MYTable");
>(ResultSet.TYPE_SCROLL_INSENSITIVE,
>ResultSet.CONCUR_UPDATABLE);
>
>4. ResultSet rs = stmt.executeQuery();
>From: Hai Ram <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: out of topic - JDBC Problem
>Date: Tue, 19 Dec 2000 14:26:58 +0530
>MIME-Version: 1.0
>X-Originating-IP: [198.240.212.26]
>Received: from [204.160.241.38] by hotmail.com (3.2) with ESMTP id
>MHotMailBC086E50003D40042A1CCCA0F1268C8B0; Tue Dec 19 00:59:07 2000
>Received: from mail (mail.javasoft.com [204.160.241.28])by
>mail2.java.sun.com (8.10.0.Beta13+Sun/8.10.0.Beta13) with ESMTP id
>eBJ8vbX07666;Tue, 19 Dec 2000 00:57:37 -0800 (PST)
>Received: from JAVA.SUN.COM by JAVA.SUN.COM (LISTSERV-TCP/IP release 1.8d)
>with spool id 2461395 for [EMAIL PROTECTED]; Tue, 19
>Dec 2000 00:59:04 -0800
>Received: from hotmail.com (f209.law11.hotmail.com [64.4.17.209]) by
> mail.java.sun.com (8.10.0.Beta13+Sun/8.10.2) with ESMTP id
>eBJ8x1K29629 for <[EMAIL PROTECTED]>; Tue, 19 Dec 2000
>00:59:02 -0800 (PST)
>Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
>Tue, 19 Dec 2000 00:56:58 -0800
>Received: from 198.240.212.26 by lw11fd.law11.hotmail.msn.com with HTTP;
>Tue, 19 Dec 2000 08:56:58 GMT
>From [EMAIL PROTECTED] Tue Dec 19 01:00:03 2000
>X-OriginalArrivalTime: 19 Dec 2000 08:56:58.0612 (UTC)
> FILETIME=[A5090B40:01C06999]
>Message-ID: <[EMAIL PROTECTED]>
>Sender: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>
>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
_________________________________________________________________________
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
