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, you’re the one who is smiling and everyone 
around you is crying." 

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

Reply via email to