@Column name with Capital and lower case letters ignored

valotas · **Joined:** Tue Sep 08, 2009 5:04 am **Posts:** 4

I'm trying to map an existing table to a Class. The table has only three columns: ID, content, lastUpdateAt.

I created a JPA Annotated class with three fields like:

Code:

@Entity
@Table(name = "keyvaluetable")
public class Property {
  @Id
  @Column(name = "ID", length = 50, nullable = false)
  private String key;

  @Lob
  @Column(name = "content", nullable = false)
  private String value;

  @Column(name = "lastUpdateAt", nullable = false)
  private Date lastUpdateDate;

  //Getter and setters...
}

When I tried to validate the schema hibernate was looking for column with name last_update_at. Changing the jpa annotation to @Column(name = "lastupdateat", nullable = false) the validation took place just fine.

I'm using Hibernate entity manager version 3.2.1.ga

Masterplan79th · **Joined:** Fri Jun 26, 2009 6:59 am **Posts:** 23

what database are you using, include version please.

Cameron McKenzie · **Posted:** Tue Sep 08, 2009 7:54 am

Can you see the SQL/DDL for table creation in the logs if you do a SchemaExport?

valotas · **Joined:** Tue Sep 08, 2009 5:04 am **Posts:** 4

Masterplan79th wrote:

what database are you using, include version please.

I'm using mssql 2008 express edition.

valotas · **Joined:** Tue Sep 08, 2009 5:04 am **Posts:** 4

Actually as I found an easy work around, the only reason to post here is to be sure that there isn't something wrong that I'm doing. If not, should I report a bug?

Masterplan79th · **Joined:** Fri Jun 26, 2009 6:59 am **Posts:** 23

post your workaround first, people will be browsing ehre for solutions to their problems, these posts are monitored by google. so the more solutions there are the better.

valotas · **Joined:** Tue Sep 08, 2009 5:04 am **Posts:** 4

I think that it is clear at my first post. Instead of using the table's real (ex: xxYzzLkk) name at the column definition, I use the name in lowercase (ex: xxyzzlkk).