Hi All,

I dont know how to map columns if there is no relations ship.

table1 contains clientid, clientname, status,customerid

table 2 contains customerid, customername

i want to display table1 columns, with customer name but there is no relationship in these 2 tables. so how will u map the customer name ???

i define like these. and geter and setter
private Table2 customer;

in Table1 mapping file in xml i mapped like
<property name="customer" type="com.test.model.Table2" column="CUSTOMER_ID"/>

but i am not getting values it shows could not read column value from result set
how to get customer name??????

You need to post you mapping files and the full exception. You should have 2 mapping files and customer_id would be an Id on the customer. By the way, you say customerid on the DB description but customer_id in the file. Please post code and mapping files and you'll get a more specific answer.

FIRST MAPPING FILE:

<hibernate-mapping package="com.test.model">

<class name="Customer" table="CUSTOMER" discriminator-value="Customer">
<id name="customerId" column="CUSTOMER_ID" unsaved-value="0" type="string">
<generator class="native"/>
</id>
<property name="customerName" column="CUSTOMER_NAME" not-null="false" type="string"/>
<property name="status" column="STATUS" not-null="false" type="string"/>
<property name="lastUpdateTime" column="LAST_UPDATE_TIME" not-null="false" type="date"/>
</class>
</hibernate-mapping>

SECOND MAPPING FILE:
<hibernate-mapping package="com.test.model">

<class name="ProfileEventLog" table="PROFILE_EVENT" discriminator-value="ProfileEvent">
<id name="triggerId" column="TRIGGER_ID" unsaved-value="0" type="string">
<generator class="native"/>
</id>

<property name="documentId" column="DOCUMENT_ID" not-null="false" type="string"/>
<property name="clientId" column="CLIENT_ID" not-null="false" type="string"/>
<property name="application" column="APPLICATION" not-null="false" type="string"/>
<property name="userId" column="USER_ID" not-null="false" type="string"/>
<property name="eventType" column="EVENT_TYPE" not-null="false" type="string"/>
<property name="messageEventDateTime" column="MESSAGE_EVENT_DATE_TIME" not-null="false" type="date"/>
<property name="customerId" type="com.test.model.Customer" column="CUSTOMER_ID"/>
property name="profileName" column="PROFILE_NAME" not-null="false" type="string"/>
<property name="profileVersion" column="PROFILE_VERSION" not-null="false" type="integer"/>

</class>
</hibernate-mapping>



GETTER AND SETTER:

public Customer getCustomerId() {
return customerId;
}

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


but there is no relation between these two tables for customerID.

i tried giving this..but fails........

i dont know how to get the customerName????????//

if there is a relationship then i can do customerId().getCustomerName();

but no rel...

since i am using spring , if i get the model object(PROFILE_EVENT) ,then i can send it to model and view and i can display the value

So, why dont u have the relationship? This looks a perfect way to map both the tables. In your case, how are you maintaining the integrity if you dont have a relationship.

Anyway, if you are working with a legacy db or some such where you cant change, one way to do this would be to write a listener for the "post-load" event like

Your post load listener will use the customerid from table 1 and retrieve the customer name from the other table. This is definitely bad (as it leads to one SQL everytime u load) but if you dont have a relation, this might work.

Technically profileeventlog is a one to many mapping to customer, since it has the customerid in it. It may be that it's a one to one mapping in reality but that DB schema allows one to many.

So, in the ProfileEventLog.java you should have this and no reference to any customerIds anywhere:


And in the ProfileEventLog mapping have (Instead of your current customerid mapping):


That way you can get the customer from the ProfileEventLog using


It may work as a mapping like so if it is a one to one mapping with the same java code I described as above: