John Thorhauer wrote:
> 
> John McNally wrote:
> >
> > What is really gained by being able to write:
> >
> > Criteria criteria = new Criteria(10)
> >     .add("Table1.col1", "a")
> >     .add("Table2.col1", "b")
> >     .add("Table2.col2", "c")
> >     .add("Table2.col3", "d")
> >     .add("Table3.col1", "c");
> > BasePeer.doInsert(criteria);
> >
> > Over
> >
> > Criteria criteria = new Criteria(5)
> >     .add("Table1.col1", "a");
> > BasePeer.doInsert(criteria);
> >
> > criteria.clear();
> > criteria.add("Table2.col1", "b")
> >     .add("Table2.col2", "c")
> >     .add("Table2.col3", "d");
> > BasePeer.doInsert(criteria);
> >
> > criteria.clear();
> > criteria.add("Table3.col1", "c");
> > BasePeer.doInsert(criteria);
> >
> > ?
> >
> > Or is there some other benefit?
> >
> 
> Like I said I havent gotten to the point of needing this yet but since
> you ask.......
> 
> Is it possible to use the second methodology within one begin/commit
> transaction and if so how?
> 


It is possible:

DBConnection dbCon = BasePeer.beginTransaction(dbName);
Criteria criteria = new Criteria(5)
    .add("Table1.col1", "a");
BasePeer.doInsert(criteria, dbCon);

criteria.clear();
criteria.add("Table2.col1", "b")
    .add("Table2.col2", "c")
    .add("Table2.col3", "d");
BasePeer.doInsert(criteria, dbCon);

criteria.clear();
criteria.add("Table3.col1", "c");
BasePeer.doInsert(criteria, dbCon);

BasePeer.commitTransaction(dbCon);


------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?:           [EMAIL PROTECTED]

Reply via email to