CURRENT_DATE and OpenJPA 2

2010-09-23 Thread Marc Logemann
Hi, The following query: Query query = em.createQuery("select count(d) from Order o, IN(o.deliveryAddress) d " + "where o.createdYmd = CURRENT_DATE and d.deliveryMode = ?1"); generates the following SQL: SELECT COUNT(t1.oid) FROM orders t0 INNER JOIN address t1 ON t0.oid = t1.

Re: CURRENT_DATE and OpenJPA 2

2010-09-23 Thread Michael Dick
Hi Marc, I'm not familiar with the current_date function but what you're saying sounds right. To answer your minor question on parameter logging, you need to add the following property to persistence.xml : . It's a change from previous versions, due to concerns about logging sensitive data, ther

Re: CURRENT_DATE and OpenJPA 2

2010-09-23 Thread Marc Logemann
Thx for the property hint. Should i file a bug because of CURRENT_DATE ? Cant think that this doesnt work because this would be quite a killer bug right? :-) --- regards Marc Logemann http://www.logemann.org http://www.logentis.de Am 23.09.2010 um 15:34 schrieb Michael Dick: > Hi Marc, > >

Re: CURRENT_DATE and OpenJPA 2

2010-09-23 Thread Michael Dick
Go ahead and file a bug. I don't see any unit tests that use the CURRENT_DATE keyword. Even if there's something unique about your environment we can use the JIRA to add a testcase, or documentation. Regards, -mike On Thu, Sep 23, 2010 at 8:47 AM, Marc Logemann wrote: > Thx for the property hin

Re: How to reset OpenJPA cache

2010-09-23 Thread Rick Curtis
http://openjpa.apache.org/builds/latest/docs/manual/manual.html#ref_guide_cache_use_JPA If you are working on pre-2.0. code you'll have to look at section 1.2.2 and use the OpenJPA specific APIs. Thanks, Rick On Thu, Sep 23, 2010 at 4:31 PM, nasseria1 wrote: > > Hi all, > After reading OpenJPA

RE: How to reset OpenJPA cache

2010-09-23 Thread C N Davies
Em.clear(); seems to do the job for me. chris -Original Message- From: nasseria1 [mailto:nasser.f...@gmail.com] Sent: Friday, 24 September 2010 7:32 AM To: users@openjpa.apache.org Subject: How to reset OpenJPA cache Hi all, After reading OpenJPA, I could not find a clear way to cle

Re: How to reset OpenJPA cache

2010-09-23 Thread Kevin Sutter
It depends on which cache is being requested to be cleared... The EntityManager / Persistence Context can be cleared via the em.clear() invocation. This is also known as a Level 1 cache. If you are asking about the Level 2 cache, then as Rick pointed out, it depends on whether you are using pre-