db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: [jira] Created: (DERBY-63) updateNull doesnot work with Embedded Driver
Date Thu, 31 Mar 2005 07:08:13 GMT
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

Mime
View raw message