Problem with bulk persist with programmatic transaction in OpenJpa 1.2.1 jar

2009-11-09 Thread amitm
Hi, I have updated OpenJpa jar to version 1.2.1 from 1.0.1. I am facing a strange problem. I have an object which is having a OneToMany field. This object is being persisted in database in bulk. I am reading a CSV file and populating this object and then saving the objects in batch. For this I h

Re: IllegalArgumentException on persist, but only on first attempt

2009-11-09 Thread aprestwich
Thank you very much, that was the ticket. I was using MySQL Driver 5.1.6 which I had downloaded some time ago, once replaced everything worked perfectly. It is odd that it would only fail on the first time...guess I was focusing in the wrong place (OpenJPA rather than MySQL). Thanks again for sa

Re: IllegalArgumentException on persist, but only on first attempt

2009-11-09 Thread Michael Dick
Hi, It looks like you're hitting this problem : http://bugs.mysql.com/bug.php?id=37645 . Grabbing the latest MySQL driver should resolve the problem for you. That it happens only the first time is a bit unusual. If I had to guess I'd say that subsequent calls are caching the prepared statement in

IllegalArgumentException on persist, but only on first attempt

2009-11-09 Thread aprestwich
I've been having a strange issue for awhile where I receive an IllegalArgumentException the first time I submit my Request form, but if I hit the back button and try again (same data, no changes) it works fine (data stored in the DB). After the first failure (for each request type) I can submit mu

Re: Unexpected ArgumentException using 'IN' operator

2009-11-09 Thread Fay Wang
Running against openjpa 1.2, I got the same error as you did. Apparently, this problem is fixed in the trunk code. - Original Message From: Fay Wang To: users@openjpa.apache.org Sent: Mon, November 9, 2009 9:09:04 AM Subject: Re: Unexpected ArgumentException using 'IN' operator Hi,

Re: Unexpected ArgumentException using 'IN' operator

2009-11-09 Thread Fay Wang
Hi, I tried the following using openjpa trunk, and it works fine. I will try it using openjpa 1.2. Query q = em.createQuery("Select m from Manager m, IN (m.employees) emps where emps = :emp"); Employee emp = new Employee(); emp.setId(1); q.setParamet

Re: overriding datasource in the persistent unit

2009-11-09 Thread Daryl Stultz
On Sat, Nov 7, 2009 at 11:41 PM, rtselvan wrote: > > Correct, you need to create a separate instance of the EntityManagerFactory > for each organization by passing in the datasource name. Thanks for sharing your solution. I'm sure it will come in handy when it comes time to add this feature to