Derby
  1. Derby
  2. DERBY-63

updateNull doesnot work with Embedded Driver

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: JDBC
    • Labels:
      None
    • Environment:
      Run from a Java Program will appear across platfroms using the embedded driver

      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

          Activity

          Shreyas Kaushik created issue -
          Daniel John Debrunner made changes -
          Field Original Value New Value
          Link This issue duplicates DERBY-99 [ DERBY-99 ]
          Daniel John Debrunner made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Duplicate [ 3 ]
          Alan Cabrera made changes -
          Link This issue duplicates DERBY-99 [ DERBY-99 ]
          Alan Cabrera made changes -
          Link This issue duplicates DERBY-99 [ DERBY-99 ]
          Hide
          Andrew McIntyre added a comment -

          This issue has been resolved for over a year with no further movement. Closing.

          Show
          Andrew McIntyre added a comment - This issue has been resolved for over a year with no further movement. Closing.
          Andrew McIntyre made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 38301 ] Default workflow, editable Closed status [ 12801253 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Shreyas Kaushik
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development