Hi,

I have generated the reverse engineering files to query an oracle view and populate my pojos. The problem is that the query executes okay, I can see rows of correct data dumping out to the console, but when I look at my composite id object everything is null. I dont see any errors.

I am using composite id's because my oracle view of course does not have any primary keys. But, it looks like every field in the table is in the composite id, and there are no fields outside of the composite id. Is this a problem?

Here are the relevant files, Im really stuck here and need help!

( I am not attaching the SrAllelotypeId composite java class because it is huge, if it helps to see it please let me know and I will post it)

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated May 27, 2008 11:12:11 AM by Hibernate Tools 3.2.0.b9 -->
<hibernate-mapping>
<class name="com.sequenom.datareporter.domain.SrAllelotype" table="SR_ALLELOTYPE">
<composite-id name="id" class="com.sequenom.datareporter.domain.SrAllelotypeId">
<key-property name="customer" type="string">
<column name="CUSTOMER" length="60" />
</key-property>
<key-property name="project" type="string">
<column name="PROJECT" length="60" />
</key-property>
<key-property name="plate" type="string">
<column name="PLATE" length="60" />
</key-property>
<key-property name="experiment" type="string">
<column name="EXPERIMENT" length="60" />
</key-property>
<key-property name="chip" type="java.lang.Long">
<column name="CHIP" precision="22" scale="0" />
</key-property>
<key-property name="well" type="string">
<column name="WELL" length="3" />
</key-property>
<key-property name="sample" type="string">
<column name="SAMPLE" length="60" />
</key-property>
<key-property name="sampleGroup" type="string">
<column name="SAMPLE_GROUP" length="60" />
</key-property>
<key-property name="assayProject" type="string">
<column name="ASSAY_PROJECT" length="60" />
</key-property>
<key-property name="assayGroup" type="string">
<column name="ASSAY_GROUP" length="60" />
</key-property>
<key-property name="assay" type="string">
<column name="ASSAY" length="60" />
</key-property>
<key-property name="genotype" type="string">
<column name="GENOTYPE" length="20" />
</key-property>
<key-property name="status" type="string">
<column name="STATUS" length="30" />
</key-property>
<key-property name="maxShift" type="java.lang.Long">
<column name="MAX_SHIFT" precision="22" scale="0" />
</key-property>
<key-property name="score" type="java.lang.Long">
<column name="SCORE" precision="22" scale="0" />
</key-property>
<key-property name="rasters" type="java.lang.Long">
<column name="RASTERS" precision="22" scale="0" />
</key-property>
<key-property name="oligoType" type="java.lang.Character">
<column name="OLIGO_TYPE" length="1" />
</key-property>
<key-property name="mass" type="java.lang.Long">
<column name="MASS" precision="22" scale="0" />
</key-property>
<key-property name="height" type="java.lang.Long">
<column name="HEIGHT" precision="22" scale="0" />
</key-property>
<key-property name="snr" type="java.lang.Long">
<column name="SNR" precision="22" scale="0" />
</key-property>
<key-property name="resolution" type="java.lang.Long">
<column name="RESOLUTION" precision="22" scale="0" />
</key-property>
<key-property name="noiseStd" type="java.lang.Long">
<column name="NOISE_STD" precision="22" scale="0" />
</key-property>
<key-property name="area" type="java.lang.Long">
<column name="AREA" precision="22" scale="0" />
</key-property>
<key-property name="areaUncertainty" type="java.lang.Long">
<column name="AREA_UNCERTAINTY" precision="22" scale="0" />
</key-property>
<key-property name="frequency" type="java.lang.Long">
<column name="FREQUENCY" precision="22" scale="0" />
</key-property>
<key-property name="frequencyUncertainty" type="java.lang.Long">
<column name="FREQUENCY_UNCERTAINTY" precision="22" scale="0" />
</key-property>
</composite-id>
</class>
</hibernate-mapping>

public class SrAllelotype implements java.io.Serializable {

/**
*
*/
private static final long serialVersionUID = 8452600619136528126L;
private SrAllelotypeId id;

public SrAllelotype() {
}

public SrAllelotype(SrAllelotypeId id) {
this.id = id;
}

public SrAllelotypeId getId() {
return this.id;
}

public void setId(SrAllelotypeId id) {
this.id = id;
}

}