JpaIdentityStore bug: error mapping @UserPrincipal property or field to table column

[yangenping]

In 2.1SP1, JpaIdentityStore cann't map the @UserPrincipal property/field to database column.


The user entity:
'
public class User {
   ...
   @UserPrincipal
   private String _loginId;
   ...
}
'
The ORM definition:
'
  property loginId, column login_id
'
The generated SQL statement:
'

"INFO: Hibernate: select user0_._record_id as column1_133_, user0_.active as active133_, user0_._create_by as column3_133_, user0_._create_time as column4_133_, user0_.first_name as first5_133_, user0_.last_name as last6_133_, user0_.login_id as login7_133_, user0_._modify_by as column8_133_, user0_._modify_time as column9_133_, user0_.password as password133_, user0_._record_version as column11_133_ from "user" user0_ where _loginId=?"

'
See the where phrase, it should be "
"where _login_id=?"
".

[stefanotravelli]

What do you mean by The ORM definition?

If you want a column 'login_id' for the property '_loginId', you should annotate that property with:

@UserPrincipal
@Column(name = "login_id")
private String _loginId;

[yangenping]

yes, I defined the ORM in orm.xml, map the property to column "login_id", but the JpaIdentityStore did't recognize that.