db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: [PATCH]Derby-229
Date Mon, 02 May 2005 17:59:30 GMT
>>>>>>>>>>>> Daniel John Debrunner wrote (2005-05-02 09:23:59):
> The JDBC tutorial (second edition) books says for this method
>  "Checks whether the database treats mixed ..."
> note the *database*, not the driver. I think this method is describing
> how identifiers behave in SQL statements, not in JDBC method calls.
> Also section 26.1.5 of JDBC tutorial book (second edition) describes how
>  duplicate column names are handled, and it says if there are identical
> names the application needs to use a column index to obtain the correct
> value. Nothing about quoted names in JDBC method calls.

I admit I refferd to the tutorial (third ed.) not the spec. 

That said, quoted and unquoted are not identical in SQL (unless the
quoted variant is all upper case and a legal SQL identifier, so "I", I
and i are identical while "i" is another identifier). I find it
reasonable to be able to access quoted identifires (e.g. "i") with the
column name too (e.q. like getInt("\"i\"")). 

Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Norway

View raw message