Hi,

I have problems using Hibernate tools when using upper case letters in a PostgreSQL database.

My configuration: Eclipse 3.3.0, Hibernate Tools 3.2.0 beta9a, PostgreSql 8.2 and JDBC driver postgresql-8.2-506.jdbc3.jar.

I can configure Hibernate Tools for my local PostgreSql installation without any problems. I can access the table structure in the view Hibernate Configurations and do reverse engineering by creating XML mappings and beans. No problem.

But when I'm using upper case characters in table names Hibernate Tools can't access the table structures any more. Hibernate Configuration shows the tables, but when I want to see the columns, it doesn't show anything. Reverse engineering also doesn't work any more.

So, the following works:

TABLE cms_clusterMessage

pk_clustermessageid
fk_clusternodeid
messagetype
messagedetail

The following doesn't work:

TABLE cms_clusterMessage

PK_ClusterMessageId
FK_ClusterNodeId
MessageType
MessageDetail

I tried to use different JDBC drivers because I thought it could be a bug of the driver. But it wasn't.

Please note that I'm using PostgreSQL on Windows at the moment. Don't know if it behaves different if installed on Unix/Linux!?

Thanks!

Rüdiger Engelberger

looks like postgressql is inconsistent in its handling of jdbc metadata - report it as an bug if it is still an issue in latest release (b11)

Hi,

I installed the newest Release 3.2.0 Beta11 ... nothing changed.

So I'll report it as a bug.

Thanks!

Rüdiger Engelberger