Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (hermes.apache.org: domain of msatoor@gmail.com designates
 64.233.184.203 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
        b=oJrR84sTKU2KO6+mVoXlrt5jt0Uu3j+pYtfCknv32Liv58vEnc8Qz+wVyDQNfby7FE0Z2DFXf8QCSXh/pv8DyADV42OvbKx/+5y17yOLK0WtExASvmLpLBjEGXqQAuZmTgrnSLOieeScFypw8jMg+5Pwi1csIO0Mr/CcJSuyRKA=
Message-ID: <d9619e4a0503302308719e452f@mail.gmail.com>
Date: Wed, 30 Mar 2005 23:08:13 -0800
From: Mamta Satoor <msatoor@gmail.com>
Reply-To: Mamta Satoor <msatoor@gmail.com>
To: Derby Development <derby-dev@db.apache.org>
Subject: Re: [jira] Created: (DERBY-63) updateNull doesnot work with Embedded
 Driver
In-Reply-To: <1005634301.1100070203838.JavaMail.apache@nagoya>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
References: <1005634301.1100070203838.JavaMail.apache@nagoya>

On Tue, 9 Nov 2004 23:03:23 -0800 (PST), Shreyas (JIRA)
<derby-dev@db.apache.org> wrote:
> updateNull doesnot work with Embedded Driver
> --------------------------------------------
> 
>         Key: DERBY-63
>         URL: http://nagoya.apache.org/jira/browse/DERBY-63
>     Project: Derby
>        Type: Bug
>  Components: JDBC
> Environment: Run from a Java Program will appear across platfroms using the embedded driver
>    Reporter: Shreyas
>    Priority: Minor
> 
> The Embedded Driver for Derby still does not implement the updateNull method defined in the interface java.sql.ResultSet.
> 
> Attaching a Repro and the stack trace for the same
> 
> -----------------------------------------------------
> Reproducible Program
> -----------------------------------------------------
> import java.sql.*;
> 
> public class updateNull{
> 
>   public static void main(String [] args) {
> 
>      String strUrl = "jdbc:derby:;databaseName=testdb;create=true";
>      try {
>         Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
>         Connection con = DriverManager.getConnection(strUrl);
> 
>         Statement stmt = con.createStatement();
>         try {
>            stmt.executeUpdate("drop table test");
>         } catch(SQLException ex) {
>            // Do nothing.
>         }
>         con.commit();
> 
>         Statement stmt1 = con.createStatement();
>         stmt1.executeUpdate("create table test(i_val integer, s_val varchar(10))");
>         stmt1.executeUpdate("insert into test values(1,'shreyas')");
>         con.commit();
> 
>         Statement stmt2 = con.createStatement();
>         ResultSet rs = stmt2.executeQuery("select * from test");
>         rs.next();
>         rs.updateNull(2);
>         rs.updateRow();
> 
>      } catch(ClassNotFoundException cnfe) {
>         System.out.println("Class not found: "+cnfe.getMessage());
>      } catch(SQLException sqle) {
>         System.out.println("SQL:Caught: "+sqle.getMessage());
>         sqle.printStackTrace();
>      } catch(Exception e) {
> 
>      }
> 
>   }
> }
> 
> ---------------------Reproducible Ends----------------------------------
> 
> ------------------------------------
>    Stack Trace of the output
> ------------------------------------
> SQL:Caught: Feature not implemented: no details.
> SQL Exception: Feature not implemented: no details.
>        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
>        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
>        at org.apache.derby.impl.jdbc.Util.notImplemented(Util.java)
>        at org.apache.derby.impl.jdbc.EmbedResultSet20.updateNull(EmbedResultSet20.java)
>        at updateNull.main(updateNull.java:28)
> -----------------------Stack Trace Ends-------------------------------------------------
> 
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
>   http://nagoya.apache.org/jira/secure/Administrators.jspa
> -
> If you want more information on JIRA, or have a bug to report see:
>   http://www.atlassian.com/software/jira
> 
> 


Hi Shreyas,

I have checked in support for update using updatable resultset apis on
forward only updatable resultsets. Can you please test your code again
and close the bug if everything works fine?

thanks,
Mamta