Re: [jira] Created: (DERBY-63) updateNull doesnot work with Embedded Driver

[Mamta Satoor <ma...@Remulak.Net>]

Hi,

I am working on updatable resultset support in Derby. The first phase
will support delete using updatable resultset api and next phase of
implementation will provide support for update using updatable
resultset apis.

thanks,
Mamta

"Shreyas (JIRA)" 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