Hello mgazzo,
mgazzo schrieb:
I am new to PostgreSQL and I want to use it from a Java Application with the
Hibernate ORM. I ran into a problem when I created my first simple Hello
Postegres app where I receive a 'relation "X" does not exist' error. It
turns out that the query Hibernate produces seems to be missing some quotes
around the table name as in [select mytable0_.id as col_0_0_ from Mytable
mytable0_]. I can reproduce the exact same error with the PgAdmin query tool
when I apply this query string but I it works once I add the quotes as in
[select mytable0_.id as col_0_0_ from "Mytable" mytable0_].
It seems as if Hibernate is not generating the query string properly despite
that the dialect should be set correctly to
org.hibernate.dialect.PostgreSQLDialect. It could also be that I have not
setup my PostgreSQL db correctly for this to work. If anyone has an idea of
a solution to this problem I would be much obliged. I use PostgreSQL 8.3
with Hibernate Entity Manager 3.4.0 GA.
This problem should be discussed on the Hibernate Mailing list. I can
tell you that it might be possible to extend HibernatePostgreSQLDialect
with your own implementation (I also do it this way in my project) to
add some custom modifications. E.g. the name length is not correct in
Hibernate (states 32, is 64 here).
By the way, please note that PostgreSQL converts every name to
lowercase, and, by enclosing it in quotes, an exact match is to be
found. If you are able to, just use lowercase table names in postgres,
and your problem is solved.
With best regards,
Daniel Migowski
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
