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
