Title: ESQL - mixed case in column names spits "attribute <lowercase-column-name> not found" on SELECT

OK, I have moved from java 1.4 to 1.3.1 and the postgresql jdbc driver is working now, but I've run into another problem.

In short, I have a esql:query like so:

    <esql:query>SELECT * FROM supporttype</esql:query>
and
    <esql:get-string column="Type"/>

which works just fine (resulting page displays the contents of the 'Type' column).

If I change the query to:

SELECT Type FROM supportype

(changing the '*' to 'Type' I get this error:


org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Error executing statement: SELECT Type FROM supporttype: java.sql.SQLException: ERROR: Attribute 'type' not found

Changing 'Type' to anything else (any other existing column anyways), produces the same error except the not-found attribute is always the lowercase version of the column I am trying to select from (which is always mixed-case).

Developers: Is this a bug in CVS?

TIA,
-Tom

Reply via email to