Hi Dan, >>>>> "Daniel" == Daniel John Debrunner (JIRA) <[email protected]> wrote:
Daniel> Each column in the insert row that does not allow null as a value and does not Daniel> have a default value must be given a value using the appropriate update method. Daniel> Daniel> Daniel> nullable has default Daniel> Daniel> no no needs user supplied value (enforced by engine, exception) Daniel> no yes no user supplied value needed (handled by engine, set to default) Daniel> yes no no user supplied value needed (handled by engine, set to null) Daniel> yes yes no user supplied value needed (handled by engine, set to default) Daniel> Daniel> So I believe that this code does not implement the spec Daniel> correctly, in the case of no user supllied values. I agree with this interpretation. Interestingly, the tutorial book has another condition, which I did not find in the standard specification, either in 3.0 or the draft 4.0, cf. p 713 of the tutorial book (3rd ed.): "Also, if the result set is missing a column, that, too, will cause an SQLException to be thrown unless the column allows for null values." Not sure what to make of that.... I don't see why this should be a necessary condition, though. Dag Daniel> Daniel> > Add support for insert functionality using JDBC 2.0 updatable resultset apis Daniel> > ---------------------------------------------------------------------------- Daniel> > Daniel> > Key: DERBY-100 Daniel> > URL: http://issues.apache.org/jira/browse/DERBY-100 Daniel> > Project: Derby Daniel> > Type: New Feature Daniel> > Components: JDBC Daniel> > Versions: 10.1.1.0 Daniel> > Reporter: Mamta A. Satoor Daniel> > Assignee: Fernanda Pizzorno Daniel> > Attachments: DERBY-100.diff, DERBY-100.stat Daniel> > Daniel> > The JDBC 2.0 API introduced the ability to update/delete/insert rows from a resultset using methods in the Java programming language rather than having to send an SQL command. This Jira entry is to track the insert rows functionality using JDBC 2.0 apis. Daniel> Daniel> -- Daniel> This message is automatically generated by JIRA. Daniel> - Daniel> If you think it was sent incorrectly contact one of the administrators: Daniel> http://issues.apache.org/jira/secure/Administrators.jspa Daniel> - Daniel> For more information on JIRA, see: Daniel> http://www.atlassian.com/software/jira Daniel> -- Dag H. Wanvik Sun Microsystems, Database Technology Group (DBTG) Haakon VII gt. 7b, N-7485 Trondheim, Norway Tel: x43496/+47 73842196, Fax: +47 73842101
