Can't see columns in Postgres database

[ocset]

Hi

I am new to iReport and need some help.

I have a Postgres database where the schema has columns and tables which are case sensitive which means that an sql statement needs to put quotes around table/column names (“AccountName” for example). iReport does not seem to like this because when I use the “Design Query” tool, the columns do not show up for any of the tables.

I have created a test table in the same database where everything is lower case and the columns are successfully displayed in the “Design Query” window.

I have tried also the Postgres JDBC4 driver instead on the JDBC3 driver that comes with iReport, but still no luck.

All help greatly appreciated

Thanks in advance

 

Post Edited by ocset at 07/31/2010 15:51