[DERBY-63] updateNull doesnot work with Embedded Driver

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Component/s: JDBC
• Environment: Run from a Java Program will appear across platfroms using the embedded driver
• Assignee: Unassigned
• Reporter: Shreyas
• Created: 10/Nov/04 07:02
• Updated: 13/Dec/07 09:04
• Resolved: 11/Dec/04 05:23

Description

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

Issue Links

• duplicates: DERBY-99 Add support for update functionality using JDBC 2.0 updatable resultset apis