Hibernate: adding underscore to attibute names

[David O'Meara]

We're using annotations to map a class to a table in another schema, but the column names used in the queries generated by Hibernate are wrong, even when the column name is specified.

@Entity
@Table(schema = "portal", name = "User_")
@org.hibernate.annotations.Entity(mutable = false)
public class User implements Serializable {

	@Id
	@Column(name = "userId")
	private Long id;

The hibernate query tries to load 'user_id', similarly the firstName, middleName and lastName are referred to as 'first_name', 'middle_name' and 'last_name' respectively.
The table already exists and is not created by Hibernate (it is SELECT only) and is running in MySQL 5.1 with Hibernate 3 and Spring.
I go around it by pointing it to a view in the remote schema instead, but I'd prefer it to work correctly.

[Jaikiran Pai]

That's a strange one. Are you sure the annotations are being picked up by Hibernate? Any hibernate boot logs?

[David O'Meara]

2010-08-11 10:17:12,040 [INFO ] [main] org.hibernate.tool.hbm2ddl.DatabaseMetadata - table not found: user_
2010-08-11 10:17:12,056 [ERROR] [main] org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table portal.user_ 
 (user_id bigint not null, email_address varchar(255), first_name varchar(255), last_name varchar(255), middle_name varchar(255), primary key (user_id))
2010-08-11 10:17:12,056 [ERROR] [main] org.hibernate.tool.hbm2ddl.SchemaUpdate - CREATE command denied to user 'tmp'@'localhost' for table 'user_' 

Note that this is also related to my other thread, while I believe it is related to the tmp user only having SELECT access on the User_ table so that Hibernate cannot use the DB Metadata to query the table. BUT I'm still confused as to why the annotations are not honoured.

[Jaikiran Pai]

Going by those logs, it seems to be picking up *.hbm.xml file(s) from some place. Do you see any of those around in your application?

[David O'Meara]

I double checked, but no.