In case anyone is curious: the "attribute <foo> not found" error is PostgreSQL specific (or at least it shows up in the console interface) and is fixed by making the column names all lowercase.
-Tom
-----Original Message-----
From: von Schwerdtner, Thomas (GXS, FPI)
Sent: Thursday, March 21, 2002 10:45 AM
To: '[EMAIL PROTECTED]'
Subject: ESQL - mixed case in column names spits "attribute <lowercase-col umn-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
