On Mon, Apr 23, 2001 at 10:33:54AM -0500, Glenn Nielsen wrote:
> If a dB has case insensitive column names, shouldn't that be implemented in
> the JDBC driver, not in the JDBC tag lib? As Nick states, some dB's do support
> case sensitve names.
This sounds like it could be a limitation of JDBC. With
getColumnName(), I cannot see how the driver could properly handle
case insensitivity. How does one know if the name retrieved should be
treated as case-insensitive or not? Unless the isCaseSensitive()
method signifies this.
http://java.sun.com/j2se/1.3/docs/api/java/sql/ResultSetMetaData.html#isCaseSensitive(int)
However, this documentation is very vague and implies (to me) that
this is talking about the contents of the column being case
insensitive, not the name. I do not know the JDBC spec inside and
out, though.
-Dave