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