You can find the answer in the archives. Use the attached
repository_internal.xml to fix your problem.
----- Original Message -----
From: "CP Agrawal" <[EMAIL PROTECTED]>
To: "'OJB Users List'" <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 8:12 AM
Subject: Newbie: Running junit target on Oracle fails for OJB (0.9.7)
> I am trying to run thru junit tests and tutorial examples, but ran into
> few problems.
> First problem was, prepare-testdb target had error when inserting
> ojbcore-schema.sql. It fails in creating
> CREATE TABLE OJB_DMAP_ENTRIES
> (
> ID NUMBER NOT NULL,
> DMAP_ID NUMBER NOT NULL,
> KEY_OID LONG RAW,
> VALUE_OID LONG RAW
> );
> Because oracle allows only one column to be long raw per table. I
> checked previous versions of OJB (0.9.6), same problem exists. Please
> let me know what should be the fix.
>
> When I tried to ignore above problem and plow thru the unit tests, I get
> bunch of transactions exceptions. I think I am not setting things
> correctly.
> To walk thru these examples I am not running any application server
> (jboss or weblogic), is it a pre-requisite to run these examples? Please
> find OJB.properties and test.xml files attached.
>
> Thanks
> -- CP Agrawal
>
----------------------------------------------------------------------------
----
> --
> To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
<!-- OJB INTERNAL MAPPINGS START HERE, DO NOT EDIT -->
<!-- The OJB HIGH/LOW SequenceManagerTable -->
<class-descriptor
class="org.apache.ojb.broker.util.sequence.HighLowSequence"
table="OJB_HL_SEQ"
>
<field-descriptor id="1"
name="tableName"
column="TABLENAME"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="fieldName"
column="FIELDNAME"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="3"
name="maxKey"
column="MAX_KEY"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="grabSize"
column="GRAB_SIZE"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- The OJB Lock Table -->
<class-descriptor
class="org.apache.ojb.odmg.locking.LockEntry"
table="OJB_LOCKENTRY"
>
<field-descriptor id="1"
name="oidString"
column="OID_"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="transactionId"
column="TX_ID"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="3"
name="timestamp"
column="TIMESTAMP_"
jdbc-type="BIGINT"
/>
<field-descriptor id="4"
name="isolationLevel"
column="ISOLATIONLEVEL"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="lockType"
column="LOCKTYPE"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- THIS IS THE OJB NAMED ROOTS TABLE, DO NOT EDIT-->
<class-descriptor
class="org.apache.ojb.odmg.NamedRootsEntry"
table="OJB_NRM"
>
<field-descriptor id="1"
name="name"
column="NAME"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="oid"
column="OID_"
jdbc-type="LONGVARBINARY"
/>
</class-descriptor>
<!-- THIS IS THE OJB DLIST IMPLEMENTATION, DO NOT EDIT-->
<class-descriptor
class="org.apache.ojb.odmg.collections.DListImpl"
table="OJB_DLIST"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="size"
column="SIZE_"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="elements"
element-class-ref="org.apache.ojb.odmg.collections.DListEntry"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- THIS IS THE OJB DLIST ENTRY IMPLEMENTATION, DO NOT EDIT-->
<class-descriptor
class="org.apache.ojb.odmg.collections.DListEntry"
table="OJB_DLIST_ENTRIES"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="dlistId"
column="DLIST_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="position"
column="POSITION_"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="oid"
column="OID_"
jdbc-type="LONGVARBINARY"
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>
</class-descriptor>
<!-- THIS IS THE OJB DBAG IMPLEMENTATION, DO NOT EDIT-->
<class-descriptor
class="org.apache.ojb.odmg.collections.DBagImpl"
table="OJB_DLIST"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="size"
column="SIZE_"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="elements"
element-class-ref="org.apache.ojb.odmg.collections.DListEntry"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- THIS IS THE OJB DSET IMPLEMENTATION, DO NOT EDIT-->
<class-descriptor
class="org.apache.ojb.odmg.collections.DSetImpl"
table="OJB_DSET"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="size"
column="SIZE_"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="elements"
element-class-ref="org.apache.ojb.odmg.collections.DSetEntry"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- THIS IS THE OJB DSET ENTRY IMPLEMENTATION, DO NOT EDIT-->
<class-descriptor
class="org.apache.ojb.odmg.collections.DSetEntry"
table="OJB_DSET_ENTRIES"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="dlistId"
column="DLIST_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="position"
column="POSITION_"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="oid"
column="OID_"
jdbc-type="LONGVARBINARY"
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>
</class-descriptor>
<!-- THIS IS THE OJB DMAP IMPLEMENTATION, DO NOT EDIT-->
<class-descriptor
class="org.apache.ojb.odmg.collections.DMapImpl"
table="OJB_DMAP"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="size"
column="SIZE_"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="entries"
element-class-ref="org.apache.ojb.odmg.collections.DMapEntry"
collection-class="org.apache.ojb.broker.util.collections.ManageableHashSet"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- THIS IS THE OJB DMAP ENTRY IMPLEMENTATION, DO NOT EDIT-->
<class-descriptor
class="org.apache.ojb.odmg.collections.DMapEntry"
table="OJB_DMAP_ENTRIES"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="dmapId"
column="DMAP_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="keyOID"
column="KEY_OID"
jdbc-type="LONGVARBINARY"
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>
<field-descriptor id="4"
name="valueOID"
column="VALUE_OID"
jdbc-type="BLOB"
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>
</class-descriptor>
<!-- END OF OJB INTERNAL MAPPINGS-->
--
To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
