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

Mime
View raw message