Hi

I am using MYSQL Database.
I having problem adding object to POJO (Class created by Hibernate reverse engineering).
I have two tables customer and title. I have created One-to-Many relationship in MYSQL between this two tables.
titleId is foreign key in customer table. so one to many relation exist.

When I run reverse engineering, I get two object STitle.java and Customer.java.
Also get two Customer.hbm.xml and Stitle.hbm.xml.
But I am getting titleId in Customer object as an Integer and not as STitle object.

Here is my hibernate-reverse-engineering file.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >

<hibernate-reverse-engineering>
<table-filter match-catalog="PMS1" match-name="stitle"/>
<table-filter match-catalog="PMS1" match-name="customer"/>

<!-- PMS1 schema -->
<table schema="PMS1" name="customer">
<primary-key>
<generator class="native" />
</primary-key>
<foreign-key constraint-name="FK_TitleId">
<many-to-one property="stitle"/>
<set property="customer"/>
</foreign-key>
</table>

<table schema="PMS1" name="stitle">
<primary-key>
<generator class="native" />
</primary-key>
</table>
</hibernate-reverse-engineering>


JAVA object it created

public class Customer implements java.io.Serializable {


private Integer customerId;
private Integer titleId;
private String firstName;

public Customer() {
}


public Integer getCustomerId() {
return this.customerId;
}

public void setCustomerId(Integer customerId) {
this.landlordId = landlordId;
}

public Integer getTitleId() {
return this.titleId;
}

public void setTitleId(Integer titleId) {
this.titleId = titleId;
}
public String getFirstName() {
return this.firstName;
}

public void setFirstName(String firstName) {
this.firstName = firstName;
}
}


I don't understand why it is creating titleId as integer. It suppose to be object for table sTitle.

Please can someone help me.

Many thanks

I didn't understand whether Stitle.java is generated.
If not - this is a problem, I guess your table named in a different case in Database and filtered by your <table-filter>

I am getting two objects,

When I run reverse engineering, I get two object STitle.java and Customer.java.
Also get two Customer.hbm.xml and Stitle.hbm.xml.
But I am getting titleId in Customer object as an Integer and not as STitle object.