EJBQL and Refreshing Data

2010-05-05 Thread Andrew Lindesay
Hello; If an EJBQL query is performed; SELECT f FROM FooBar f WHERE ... I note (fairly obvious) that the to-many relationships of the fetch'ed FooBar-s are not freshened. Is there a way to achieve this with an EJBQLQuery as I note there is no; query.addPrefetch(..) Thanks for

Re: Batch Insert

2010-05-05 Thread Marek Šabo
Hi Michael, thanks, I do it this way as well and it's ok (~ 10k), but I was wondering if there was a batch-insert. Just a thought - let's say: instead of: SelectQuery sel2 = new SelectQuery(OrgIncome.class); List incomes = ctx.performQuery(sel2); for (OrgIncome oi : incom

Re: Session Replication

2010-05-05 Thread Mike Kienenberger
Ok. Found some code. Basically, I'm serializing a "DAO" class whose state is pretty much just a DataContext. private void writeObject(java.io.ObjectOutputStream out) throws IOException { out.writeObject(this.childDataContext); } private void readObject

Re: Session Replication

2010-05-05 Thread Mike Kienenberger
I did find some tests written which explicitly serialized DataContext. Apparently I was serializing DataContext at one point, and had some issue where creating a data object, then deleting that data object without committing, and it was causing an issue with serialized DataContexts. On Wed, May 5,

Re: Session Replication

2010-05-05 Thread Mike Kienenberger
Hmm. Unfortunately, I can't remember if my issue with that project was that the DataContext wasn't being serialized or that it was and I didn't want it to. And this was 1.2, so the behavior may have changed since then. But in either case, it seems pretty trivial. In the case of it being serial

Re: Batch Insert

2010-05-05 Thread Michael Gentry
Hi Marek, I don't know how many objects you are talking about inserting, but I've done mass inserts (tens to thousands of objects) just using dataContext.commitChanges(). mrg On Wed, May 5, 2010 at 4:55 PM, Marek Šabo wrote: > I've been searching for a method to persist list of DataObjects aka

Re: Session Replication

2010-05-05 Thread Michael Gentry
My experience with Tapestry (4 & 5) serializing a DataObject to the HTML (which it does by default when you have a loop in a form) is that the deserializing of the DataObject (on the subsequent request/response) gives you a DataObject that is disassociated from the DataContext (not good). Perhaps

Batch Insert

2010-05-05 Thread Marek Šabo
Hi, I've been searching for a method to persist list of DataObjects aka batch insert or mass insert. Haven't found anything relevant so far. Is there a support for this in cayenne or some optimized way to this? (faster than iterating and single inserting) Regards, -- Marek Šabo

Re: Session Replication

2010-05-05 Thread Mike Kienenberger
No direct experience, but I know you can serialize DataObjects and I'm 99% certain you can serialize DataContexts. I think I did this in one project in the past to preserve state between requests rather than saving state in the sessions. On Wed, May 5, 2010 at 4:37 PM, Michael Gentry wrote: > S

Session Replication

2010-05-05 Thread Michael Gentry
Someone on another project here asked me if Cayenne works with session replication (with 1+ user DataContext objects in the HttpSession) between application servers (such as JBoss). They have a project where they are running N instances of JBoss and they replicate/sync the session data across the

Reverse engineering existing tables... selectively

2010-05-05 Thread MGargano
Hey everybody, When I try to reverse engineer an existing table, I want to only reverse eng. a few of the tables that are related to each other. The problem is that they are named differently. When I put something like this in... "ETL_BATCH" OR "ETL_BATCH_CONFIG" OR "ETL_PARA