I get the same error again. I coundn't create an updatable recordset.
thanks and regards,
ram
>From: tripat kharbanda <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: out of topic - JDBC Problem
>Date: Tue, 19 Dec 2000 14:30:14 +0530
>
>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
_________________________________________________________________________
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
