[news.eclipse.rt.eclipselink] Re: Problem with DB2 --- Urgent

[ajayara1@xxxxxxxxxxx (Ajay Kumar)]

James,
I checked and fieldid is defined as integer with size 4. Here is my 
mapping for the given table

----
@Entity
@Table(name = "field_dispprop")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name = "FIELDID", discriminatorType = 
DiscriminatorType.INTEGER, length = 4)
@DiscriminatorValue(value = "0")
public class VuiDisppropEntity {

   private Integer recordId;
----

Here is the snippet for the filed_dispprop

----
@Entity
@Table(name = "field_dispprop")
public class FieldDisppropEntity {

   protected Integer recordId;

   @Id
   protected Integer schemaId;

   @Id
   protected Integer vuiId;

   @Id
   protected Integer fieldId;

   @Id
   protected Integer listIndex;
   protected String label;
   protected String propShort;
   protected String propLong;
   protected String srvPropShort;
   protected String srvPropLong;

   @SuppressWarnings("unused")
   @ManyToOne
   @JoinColumns(value = {
           @JoinColumn(name = "schemaId", referencedColumnName = 
"SCHEMAID", insertable = false, updatable = false),
           @JoinColumn(name = "fieldId", referencedColumnName = 
"FIELDID", insertable = false, updatable = false, columnDefinition = "INT 
NOT NULL") })
           
------

works fine for the sql server.

But giving problem on DB2.

We are completely blocked by this. Please suggest a way to solve this 
problem.

Thx
Ajay