Hi Thomas,
My repository.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE descriptor-repository SYSTEM "repository.dtd" [
<!ENTITY user SYSTEM "repository_user.xml">
<!ENTITY internal SYSTEM "repository_internal.xml">
]>
<descriptor-repository version="1.0" isolation-level="read-uncommitted">
<jdbc-connection-descriptor
jcd-alias="calapp"
default-connection="true"
platform="MySQL"
jdbc-level="2.0"
driver="com.mysql.jdbc.Driver"
protocol="jdbc"
subprotocol="mysql"
dbalias="//192.168.1.2/calapp"
username="root"
password=""
batch-mode="false"
>
<connection-pool maxActive="21" validationQuery="" />
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl">
</sequence-manager>
</jdbc-connection-descriptor>
<!-- include user defined mappings here -->
&user;
<!-- include ojb internal mappings here -->
&internal;
</descriptor-repository>
++++++++++++++++++++++++++++++++++++++++++++++++
repository_user.xml:
<!-- Definitions for LocationTO -->
<class-descriptor class="LocationTO" table="location">
<object-cache class="org.apache.ojb.broker.cache.ObjectCacheEmptyImpl">
<!--<attribute attribute-name="timeout" attribute-value="600"/>-->
</object-cache>
<field-descriptor id="0"
name="locationId"
column="locationId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
access="readonly"
/>
<field-descriptor id="1"
name="shortSymbol"
column="shortSymbol"
jdbc-type="VARCHAR"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="zip"
column="zip"
jdbc-type="VARCHAR"
/>
<field-descriptor id="4"
name="city"
column="city"
jdbc-type="VARCHAR"
/>
<field-descriptor id="5"
name="street"
column="street"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="email"
column="email"
jdbc-type="VARCHAR"
/>
<field-descriptor id="7"
name="phoneOffice"
column="phoneOffice"
jdbc-type="VARCHAR"
/>
<field-descriptor id="8"
name="fax"
column="fax"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="locationSchedule"
element-class-ref="LocationScheduleEntry">
<inverse-foreignkey field-ref="location_Id"/>
</collection-descriptor>
</class-descriptor>
<class-descriptor class="Vehicle" table="vehicle">
<object-cache class="org.apache.ojb.broker.cache.ObjectCacheEmptyImpl">
<!--<attribute attribute-name="timeout" attribute-value="600"/>-->
</object-cache>
<field-descriptor id="27"
name="vehicleId"
column="vehicleId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
access="readonly"
/>
<field-descriptor id="26"
name="vehicleType"
column="vehicleType"
jdbc-type="VARCHAR"
/>
<field-descriptor id="28"
name="vehiclemaker"
column="vehiclemaker"
jdbc-type="VARCHAR"
/>
<field-descriptor id="29"
name="vehicleModel"
column="vehicleModel"
jdbc-type="VARCHAR"
/>
<field-descriptor id="30"
name="shortSymbol"
column="shortSymbol"
jdbc-type="VARCHAR"
/>
<field-descriptor id="31"
name="licenseNumber"
column="licenseNumber"
jdbc-type="VARCHAR"
/>
<field-descriptor id="32"
name="yearOfConstruction"
column="yearOfConstruction"
jdbc-type="VARCHAR"
/>
<field-descriptor id="33"
name="licensingDate"
column="licensingDate"
jdbc-type="DATE"
/>
<field-descriptor id="34"
name="power"
column="power"
jdbc-type="INTEGER"
/>
<field-descriptor id="35"
name="fuel"
column="fuel"
jdbc-type="VARCHAR"
/>
<field-descriptor id="36"
name="serviceAtMilage"
column="serviceAtMilage"
jdbc-type="INTEGER"
/>
<field-descriptor id="37"
name="serviceAtDate"
column="serviceAtDate"
jdbc-type="DATE"
/>
<field-descriptor id="38"
name="nextExpertise"
column="nextExpertise"
jdbc-type="DATE"
/>
<field-descriptor id="39"
name="vignette"
column="vignette"
jdbc-type="CHAR"
/>
<field-descriptor id="40"
name="vehicleOwner"
column="vehicleOwner"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="fixedLocationId"
column="fixedLocation"
jdbc-type="INTEGER"
/>
<field-descriptor id="42"
name="insuranceNumber"
column="insuranceNumber"
jdbc-type="VARCHAR"
/>
<field-descriptor id="43"
name="vehicleDealer"
column="vehicleDealer"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="locationSchedule"
element-class-ref="LocationScheduleEntry"
>
<inverse-foreignkey field-ref="vehicle_Id"/>
</collection-descriptor>
</class-descriptor>
<!-- Definitions for LocationScheduleEntry -->
<class-descriptor class="LocationScheduleEntry" table="veh_loc">
<object-cache class="org.apache.ojb.broker.cache.ObjectCacheEmptyImpl">
<!--<attribute attribute-name="timeout" attribute-value="600"/>-->
</object-cache>
<field-descriptor
name="location_Id"
column="locationId"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor
name="vehicle_Id"
column="vehicleId"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor
name="habitationStart"
column="habitationStart"
jdbc-type="DATE"
/>
<field-descriptor
name="habitationEnd"
column="habitationEnd"
jdbc-type="DATE"
/>
<reference-descriptor
name="location"
class-ref="LocationTO"
>
<foreignkey field-ref="location_Id"/>
</reference-descriptor>
<reference-descriptor
name="vehicle"
class-ref="Vehicle"
>
<foreignkey field-ref="vehicle_Id"/>
</reference-descriptor>
</class-descriptor>
+++++++++++++++++++++++++++++++++++++++++++++
for the sake of completeness:
public class LocationScheduleEntry {
public int location_Id;
public int vehicle_Id;
public LocationTO location;
public Vehicle vehicle;
public Date habitationStart;
public Date habitationEnd;
public LocationScheduleEntry(){
}
public LocationScheduleEntry(LocationTO lTO, Vehicle v){
this.location=lTO;
this.vehicle=v;
}
public LocationScheduleEntry(LocationTO lTO, Vehicle v,
Date hStart, Date hEnd){
this.location=lTO;
this.vehicle=v;
this.habitationStart=hStart;
this.habitationEnd=hEnd;
}
}
the collection locationSchedule in Vehicle and LocationTO are both of Type
Vector.
Thanks in advance
Greetings
Oliver
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
