db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik" <Dag.Wan...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-100) Add support for insert functionality using JDBC 2.0 updatable resultset apis
Date Thu, 22 Dec 2005 17:48:22 GMT

Hi Dan,

>>>>> "Daniel" == Daniel John Debrunner (JIRA) <derby-dev@db.apache.org>
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

Mime
View raw message