AW: Upgrade to 1.0 small problem

[Geigl Maximilian, R235]

Hi,

it's an old problem (existed in 0.9.8 - and earlier - already). We use the following, 
slightly modified class-descriptor and CREATE TABLE, resprctively.

Regards Max


   <class-descriptor
          class="org.apache.ojb.odmg.collections.DMapEntry"
          table="OJB_DMAP_ENTRIES"
   >
      <field-descriptor
         name="id"
         column="ID"
         jdbc-type="INTEGER"
         primarykey="true"
         autoincrement="true"
      />
      <field-descriptor
         name="dmapId"
         column="DMAP_ID"
         jdbc-type="INTEGER"
      />
      <field-descriptor 
         name="keyOID"
         column="KEY_OID"
         jdbc-type="LONGVARBINARY"
         
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
      />
      <field-descriptor 
         name="valueOID"
         column="VALUE_OID"
         jdbc-type="VARCHAR"
         length="2048"
         
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
      />
   </class-descriptor>


CREATE TABLE "OJB_DMAP_ENTRIES" (
    "ID" NUMBER(10) NOT NULL,
    "DMAP_ID" NUMBER(10),
    "KEY_OID" LONG RAW,
    "VALUE_OID" VARCHAR2(2048)
);

ALTER TABLE "OJB_DMAP_ENTRIES"
    ADD CONSTRAINT "OJB_DMAP_ENTRIE_PK"
        PRIMARY KEY ("ID");


> -----Urspr�ngliche Nachricht-----
> Von: Jason McKerr [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 17. M�rz 2003 21:01
> An: OJB Users List
> Betreff: Upgrade to 1.0 small problem
> 
> 
> I'm trying to upgrade to 1.0 from 0.9.8.  The problem I'm 
> having is that
> I;m on Oracle 8i, and the OJB_DMAP_ENTRIES table is trying to make 2
> LONG RAW types in a single table which Oracle doesn't allow.  Any
> advice?
> 
> Jason
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]