This is the class-descriptor:
<class-descriptor
class="ch.admin.bit.tabakbier.dto.Zollpartner_t_b"
table="ZOLLPARTNER_T_B"
>
<field-descriptor id="0"
name="ztb_id"
column="ZTB_ID"
jdbc-type="DECIMAL"
primarykey="true"
/>
<field-descriptor id="1"
name="ztb_verband"
column="ZTB_VERBAND"
jdbc-type="VARCHAR"
/>
<field-descriptor id="2"
name="ztb_rechtsform"
column="ZTB_RECHTSFORM"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="ztb_anmeldedatum"
column="ZTB_ANMELDEDATUM"
jdbc-type="DATE"
/>
<field-descriptor id="4"
name="ztb_unterlagenzustelldatum"
column="ZTB_UNTERLAGENZUSTELLDATUM"
jdbc-type="DATE"
/>
<field-descriptor id="5"
name="ztb_gueltigv"
column="ZTB_GUELTIGV"
jdbc-type="DATE"
/>
<field-descriptor id="6"
name="ztb_gueltigb"
column="ZTB_GUELTIGB"
jdbc-type="DATE"
/>
<field-descriptor id="7"
name="ztb_erstuser"
column="ZTB_ERSTUSER"
jdbc-type="VARCHAR"
/>
<field-descriptor id="8"
name="ztb_erstdat"
column="ZTB_ERSTDAT"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="9"
name="ztb_mutuser"
column="ZTB_MUTUSER"
jdbc-type="VARCHAR"
/>
<field-descriptor id="10"
name="ztb_mutdat"
column="ZTB_MUTDAT"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="11"
name="ztb_zpa_id"
column="ZTB_ZPA_ID"
jdbc-type="DECIMAL"
/>
<insert-procedure name="du$zollpartner_t_b.ins">
<runtime-argument field-ref="ztb_id" return="true"/>
<runtime-argument field-ref="ztb_verband" return="true"/>
<runtime-argument field-ref="ztb_rechtsform" return="true"/>
<runtime-argument field-ref="ztb_anmeldedatum" return="true"/>
<runtime-argument field-ref="ztb_unterlagenzustelldatum"
return="true"/>
<runtime-argument field-ref="ztb_gueltigv" return="true"/>
<runtime-argument field-ref="ztb_gueltigb" return="true"/>
<runtime-argument field-ref="ztb_erstuser" return="true"/>
<runtime-argument field-ref="ztb_erstdat" return="true"/>
<runtime-argument field-ref="ztb_mutuser" return="true"/>
<runtime-argument field-ref="ztb_mutdat" return="true"/>
<runtime-argument field-ref="ztb_zpa_id" return="true"/>
</insert-procedure>
</class-descriptor>
Thank you very much for your help!
Regards,
Chris
On Tue, 2004-02-03 at 13:16, Ron Gallagher wrote:
> Chris --
>
> Please provide the class descriptor that contains this insert-procedure
> element.
>
> Ron.
>
> -----Original Message-----
> From: Christoph Bohl [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 02, 2004 1:52 PM
> To: [EMAIL PROTECTED]
> Subject: Stored Procedure / returning primary key
>
>
> Gurus,
>
> I try to use a stored procedure to insert a table. This works perfectly. The
> stored procedure does correctly return the values that get inserted into the
> database.
>
> Unfortunately, the object I am inserting does not change after the insert
> (toString() before and after). Can you please point out what I am doing
> wrong?
> Any help is greatly appreciated!
>
> The repository_user.xml:
> <insert-procedure name="du$zollpartner_t_b.ins">
> <runtime-argument field-ref="ztb_id" return="true"/>
> <runtime-argument field-ref="ztb_verband" return="true"/>
> <runtime-argument field-ref="ztb_rechtsform" return="true"/>
> <runtime-argument field-ref="ztb_anmeldedatum" return="true"/>
> <runtime-argument field-ref="ztb_unterlagenzustelldatum"
> return="true"/>
> <runtime-argument field-ref="ztb_gueltigv" return="true"/>
> <runtime-argument field-ref="ztb_gueltigb" return="true"/>
> <runtime-argument field-ref="ztb_erstuser" return="true"/>
> <runtime-argument field-ref="ztb_erstdat" return="true"/>
> <runtime-argument field-ref="ztb_mutuser" return="true"/>
> <runtime-argument field-ref="ztb_mutdat" return="true"/>
> <runtime-argument field-ref="ztb_zpa_id" return="true"/>
> </insert-procedure>
>
> The Java code tested (Persistence Broker API):
> PersistenceBroker broker = null;
> try
> {
> broker =
> PersistenceBrokerFactory.defaultPersistenceBroker();
> broker.beginTransaction();
> broker.store(ztb);
> broker.commitTransaction();
> }
> finally
> {
> if (broker != null) broker.close();
> }
>
> ODMG API:
> // Implementation odmg = OJB.getInstance();
> // Database db = odmg.newDatabase();
> // try {
> //
> // db.open("TABI",
> Database.OPEN_READ_WRITE);
> // } catch (Exception e) {
> // System.out.println(e.toString());
> // }
> //
> // TransactionExt tx = (TransactionExt) odmg.newTransaction();
> // System.out.println("vor insertf: " + ztb.toString());
> //
> // tx.begin();
> // tx.markDirty(ztb);
> // tx.commit();
>
> Thank you very much!!
>
> Cheers,
> Chris
> --
> "When you were born, you were crying and everyone around you was smiling.
> Live
> your life so that when you die, youre the one who is smiling and everyone
> around you is crying."
>
> ---------------------------------------------------------------------
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
