db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Resolved: (DERBY-63) updateNull doesnot work with Embedded Driver
Date Sat, 11 Dec 2004 05:30:14 GMT
     [ http://nagoya.apache.org/jira/browse/DERBY-63?page=history ]
     
Daniel John Debrunner resolved DERBY-63:
----------------------------------------

    Resolution: Duplicate

> 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 Kaushik
>     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


Mime
View raw message