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]