On Wed, 30 Mar 2005 23:08:13 -0800, Mamta Satoor <[EMAIL PROTECTED]> wrote: > On Tue, 9 Nov 2004 23:03:23 -0800 (PST), Shreyas (JIRA) > <[email protected]> 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 > > > > > > Hi Shreyas, > > I have checked in support for update using updatable resultset apis on > forward only updatable resultsets. Can you please test your code again > and close the bug if everything works fine? > > thanks, > Mamta >
Oops, never mind. I noticed that Dan has marked this bug as duplicate of Jira-99 Add support for update functionality using JDBC 2.0 updatable resultset apis Mamta
