When a table has upper case name the generates sql needs to quote the table name, like select * from "MTD_USER", otherwise the server will try to find a lower case table...

I saw the generated sql (show_sql=true) and it isn't quoted. The mapping file has the correct name (upper).

I solved lowering my tables... but it's truly a bug :)


Hibernate version: 2.1.6 (9.8.2004)

Name and version of the database you are using: postgresql-server-7.4.2-1

Mauromartini,

this is not a bug - in PostgreSQL you need to quote your identifiers in order to preserve the upper casing. You say that your mapping file does have the names in uppercase, but I imagine that they are missing the quotes. Hibernate accommodates this:

http://www.hibernate.org/hib_docs/reference/en/html/mapping.html#mapping-quotedidentifiers

I did find that the backtick did not work for the schema or sequence names (if you are using uppercase names) - so I resorted to using the standard xml predefined entity for a quote (") for those cases:


This all works well for me.

Grainne.

I have a very large PostgreSQL database that I will be using with JBoss Seam. The database uses mixed-case column names per naming convensions at Sun Microsystems and IBM. Until finding this post, I was very surprised by the potential need to have to change all column names in the PostgreSQL database to lowercase in order for hibernate and PostgreSQL to successfully interact. Per this post, the backtick marks (`) solved the problem.

However, I would strongly suggest that either modifying Hibernate to allow for interacting with uppercase (and mixed case) in PostgreSQL without the backtick marks) and/or making it very clear in appropriate sections of hibernate, seam and postgresql documentation that backticks are required for upper case and mixed cast column names.

The workaround solution to this issue was as follows:
In the entity I added an @Column(name="`mixedCaseColumnName`").
For example:

@Entity
@Name("cat")
@Table(name="cats")

public class Cat implements Serializable
{
private Integer id;
private String name;
private String distinguishingFeatures;

public Cat() {}

public Cat(Integer id, String name, String distinguishingFeatures)
{
this.id = id;
this.name = name;
this.distinguishingFeatures = distinguishingFeatures;
}

(The definition statements for the id and name variables)

@Column(name="`distinguishingFeatures`")
public String getDistinguishingFeatures()
{
return distinguishingFeatures;
}

public void setDistinguishingFeatures(String distinguishingFeatures)
{
this.distinguishingFeatures = distinguishingFeatures;
}

@Override
public String toString()
{
return "Cat(" + id + "," + name + "," + distinguishingFeatures + ")";
}