yes i'm using DBRE and attribute = field ( old OO naming convention) .
Here a simplified and translated version of what I have in my DBRE.xml.
Code:
<table name="USER">
<column name="ID" primaryKey="true" required="true" scale="0" size="12" type="3,NUMBER"/>
<column name="LOGIN" primaryKey="false" required="true" scale="0" size="20" type="12,VARCHAR2"/>
<column name="PASSWORD" primaryKey="false" required="true" scale="0" size="40" type="1,CHAR"/>
<column name="ROLE" primaryKey="false" required="true" scale="0" size="20" type="12,VARCHAR2"/>
<column name="IDCITY" primaryKey="false" required="true" scale="0" size="12" type="3,NUMBER"/>
<column name="ENABLEDDATE" primaryKey="false" required="false" scale="0" size="7" type="93,DATE"/>
<column name="DISABLEDDATE" primaryKey="false" required="false" scale="0" size="7" type="93,DATE"/>
<column name="USERTYPE" primaryKey="false" required="true" scale="0" size="1" type="3,NUMBER"/>
<column name="NAME" primaryKey="false" required="false" scale="0" size="30" type="12,VARCHAR2"/>
<column name="SURNAME" primaryKey="false" required="false" scale="0" size="30" type="12,VARCHAR2"/>
<column name="DESCRIPTIONUSERTYPE" primaryKey="false" required="true" scale="0" size="3" type="12,VARCHAR2"/>
<foreign-key foreignTable="CITY" name="FK_USERCITY1" onDelete="restrict" onUpdate="cascade">
<option key="exported" value="false"/>
<reference foreign="ID" local="IDCITY"/>
</foreign-key>
<unique name="PK_USER">
<unique-column name="ID"/>
</unique>
<unique name="TC_USER">
<unique-column name="LOGIN"/>
</unique>
</table>
on the generated java class add these personalizations:
Code:
@RooJavaBean
@RooToString
@RooDbManaged(automaticallyDelete = true)
@RooEntity(versionField = "", table = "USER", schema = "XXX", finders = { "findUsersByLoginLike", "findUsersByIdcity" })
public class UtentiDps {
@Id
@SequenceGenerator(name="USER_ID_GENERATOR", sequenceName="USER_SEQ", allocationSize = 20)
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="USER_ID_GENERATOR")
private BigDecimal id;
@Column(name = "PASSWORD", length = 40)
@NotNull
@Pattern(regexp = "{0}|((?=.*[\\d\\W])(?=.*[a-zA-Z]).{8,20})", message="{newpassword}")
private String password;
@Column(name = "ROLE")
@NotNull
@Embedded
private RoleBean ruolo;
@Column(name = "USERTYPE")
@NotNull
@Enumerated(EnumType.ORDINAL)
private UserType usertype;
@Column(name = "ENABLEDDATE")
@Temporal(TemporalType.TIMESTAMP)
@DateTimeFormat(pattern = "dd/MM/yyyy")
private Date enabledate;
@Column(name = "DISABLEDDATE")
@Temporal(TemporalType.TIMESTAMP)
@DateTimeFormat(pattern = "dd/MM/yyyy")
private Date disableddate;
}
You need all the cited classes or is enough?