[ http://opensource.atlassian.com/projects/hibernate/browse/HBX-1000?page=c... ] Scott Siu commented on HBX-1000: -------------------------------- I have a table migration from MySQL like that: CREATE TABLE app_tb_table_define ( "tableDefineId" bigint NOT NULL, "name" character varying(225), status character varying(225), "type" bigint, note text, "tableName" character varying(225) ); and have the same problem! Now I want to use a script to change all the fields to lower case. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HBX-1000?page=c... ] Jeff Adama commented on HBX-1000: --------------------------------- I finally found a work-around for using upper case and mixed case column names in postgreSQL with hibernate and Jboss Seam. The post in which I discovered this is at the following link: https://forum.hibernate.org/viewtopic.php?f=1&t=935715&p=2416841#... The backticks information in hibernate reference is here in section 5.4. SQL quoted identifiers: http://docs.jboss.org/hibernate/stable/core/reference/en/html/mapping.html The following is an example of using the work-around and my suggestion: 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 case 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 + ")"; } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HBX-1000?page=c... ] Jeff Adama commented on HBX-1000: --------------------------------- There is an additional issue where the backticks workaround does - not - work. This happens when working with mixed case PostgreSQL sequences associated with auto numbering ids and a sequence generator in the code (JBOSS Seam in my case). The - only - way that I was able to make this work was by changing all sequence names in the PostgreSQL database to lowercase. Consider the following JBOSS Seam entity code: @Id @NotNull //The following version does - NOT - work: (where the sequence name in PostgreSQL is mixed case) @SequenceGenerator(name="discountRate_autoGenerationDefault_seqIdentifier", sequenceName="discountRate_autoGenerationDefault_seq", allocationSize=1) //The following version - DOES - work: (where the sequence name in PostgreSQL is all lowercase) @SequenceGenerator(name="discountRate_autoGenerationDefault_seqIdentifier", sequenceName="discountrate_autogenerationdefault_seq", allocationSize=1) @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="discountRate_autoGenerationDefault_seqIdentifier") @Column(name="`autoGenerationDefault`", unique=true, columnDefinition="bigserial") public Long getId() For developers working with hibernate and PostgreSQL, these issues are significant. Regards, Jeff -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HBX-1000?page=c... ] Jeff Adama commented on HBX-1000: --------------------------------- Thanks Moritz!! That is very helpful! Do you think that workaround can also be used by the entity class to address the mixed case auto sequence generator issue? Or, would that only pertain to reverse engineering? Regards, Jeff -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HBX-1000?page=c... ] Jeff Adama commented on HBX-1000: --------------------------------- Ok, thanks Moritz. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira