Relation names with capital letters in Hibernate?

#1

When I use capital letter(s) in table or view name Hibernate complains
it can't find the relation.

Is this known issue or am I doing something wrong?

JZ

#2

Jaroslav Záruba wrote:

Quote:

When I use capital letter(s) in table or view name Hibernate complains
it can't find the relation.

Is this known issue or am I doing something wrong?

Yes, using capital letters in table or view, or column or whatever
identifiers is sinful and wrong.

#3

Marco Mariani wrote:

Quote:

Jaroslav Záruba wrote:
When I use capital letter(s) in table or view name Hibernate complains
it can't find the relation.

Is this known issue or am I doing something wrong?

Yes, using capital letters in table or view, or column or whatever identifiers is sinful and wrong.

You are saying that the SQL standard is sinful and wrong.
That's not PostgreSQL's position.

To the original question:
PostgreSQL folds all names to lower case unless you surround them
with double quotes. I don't know how this can be done in Hibernate,
but it would be the solution.

Yours,
Laurenz Albe

#4

Laurenz Albe wrote:

Quote:

Yes, using capital letters in table or view, or column or whatever identifiers is sinful and wrong.

You are saying that the SQL standard is sinful and wrong.

Would that be blasphemous? :-)

Actually, I was meaning that using upper/mixed case as identifiers is
bad practice.

#5

On Tue, 01 Dec 2009 12:20:59 +0100, Laurenz Albe wrote:

Quote:

Marco Mariani wrote:
Jaroslav ZÃ¡ruba wrote:
When I use capital letter(s) in table or view name Hibernate complains
it can't find the relation.

Is this known issue or am I doing something wrong?

Yes, using capital letters in table or view, or column or whatever
identifiers is sinful and wrong.

You are saying that the SQL standard is sinful and wrong. That's not
PostgreSQL's position.

But it can condemn your immortal soul to MySQL for all eternity.

--
http://mgogala.byethost5.com

#6

On Dec 1, 12:20*pm, "Laurenz Albe" <inv... (AT) spam (DOT) to.invalid> wrote:

Quote:

Marco Mariani wrote:
Jaroslav Záruba wrote:
When I use capital letter(s) in table or view name Hibernate complains
it can't find the relation.

Is this known issue or am I doing something wrong?

Yes, using capital letters in table or view, or column or whatever identifiers is sinful and wrong.

You are saying that the SQL standard is sinful and wrong.
That's not PostgreSQL's position.

To the original question:
PostgreSQL folds all names to lower case unless you surround them
with double quotes. I don't know how this can be done in Hibernate,
but it would be the solution.

Yes, I'm aware of that PostgresSQL's behaviour.
I hoped someone with Hibernate experience would shed some light on
this. Like whether this is known bug, and who is the one blame -
Hibernate or the PostgreSQL driver?

Quote:

Yours,
Laurenz Albe

Cheers
Jarda

#7

On Dec 1, 11:41*am, Marco Mariani <ma... (AT) sferacarta (DOT) com> wrote:

Quote:

Jaroslav Z ruba wrote:
When I use capital letter(s) in table or view name Hibernate complains
it can't find the relation.

Is this known issue or am I doing something wrong?

Yes, using capital letters in table or view, or column or whatever
identifiers is sinful and wrong.

In my opinion "sinful and wrong" is case-insensitivity.

#8

On Wed, 09 Dec 2009 08:49:46 -0800, Jaroslav ZÃ¡ruba wrote:

Quote:

Yes, I'm aware of that PostgresSQL's behaviour. I hoped someone with
Hibernate experience would shed some light on this.
Like whether this is known bug,

Nope, it's an expected behavior. PostgreSQL can use tables with capital
letters, only enclosed in double quotes.

Quote:

and who is the one blame - Hibernate or the PostgreSQLdriver?

Why, Hibernate of course! This is a PostgreSQL forum, after all. There is
no blame in this case, though. You'll just have to rewrite your queries.

--
http://mgogala.byethost5.com

#9

On Dec 9, 7:48*pm, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:

Quote:

On Wed, 09 Dec 2009 08:49:46 -0800, Jaroslav Záruba wrote:
Yes, I'm aware of that PostgresSQL's behaviour. I hoped someone with
Hibernate experience would shed some light on this.
Like whether this is known bug,

Nope, it's an expected behavior. PostgreSQL can use tables with capital
letters, only enclosed in double quotes.

and who is the one blame - Hibernate or the PostgreSQLdriver?

Why, Hibernate of course! This is a PostgreSQL forum, after all. There is
no blame in this case, though. *You'll just have to rewrite your queries.

--http://mgogala.byethost5.com

How can Irewrite my queries when I do not write any at all?

#10

On Dec 9, 7:48*pm, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:

Quote:

On Wed, 09 Dec 2009 08:49:46 -0800, Jaroslav Záruba wrote:
Yes, I'm aware of that PostgresSQL's behaviour. I hoped someone with
Hibernate experience would shed some light on this.
Like whether this is known bug,

Nope, it's an expected behavior. PostgreSQL can use tables with capital
letters, only enclosed in double quotes.

I don't think it is expected behaviour to get an error message when
you write the relation name properly. One would expect things to work
- i.e. to to enclose relation name within quotes if needed for a
particular db-system.

When speaking about bug I mean bug somewhere in the communication
between Hibernate and PostgreSQL - which also involves the driver. So
either Hibernate or the driver can be blamed for omitting the
enclosing chars.

Purpose of my post was to ask users experienced with Hibernate
+PostgreSQL whether this is known bug (yes, bug) or whether there is
some ?hidden? switch/option that would force Hibernate or the driver
to use the enclosing chars.

Quote:

and who is the one blame - Hibernate or the PostgreSQLdriver?

Why, Hibernate of course! This is a PostgreSQL forum, after all. There is
no blame in this case, though. *You'll just have to rewrite your queries.

How can I rewrite my queries when I do not write any at all?

> --http://mgogala.byethost5.com