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 : <property name="openjpa.ConnectionFactoryProperties" value="PrintParameters=true"/>. It's a change from previous versions, due to concerns about logging sensitive data, there's some content in the infocenter at http://openjpa.apache.org/builds/latest/docs/manual/manual.html#ref_guide_logging_channels, but it's still easy to miss if you're used to the old behavior. Regards, -mike On Thu, Sep 23, 2010 at 4:33 AM, Marc Logemann <[email protected]> wrote: > 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.order_oid WHERE (t0.createdymd IS NULL AND t1.deliverymode = ?) > [params=?] > > Why the where part with "IS NULL" ? Current_date should be applied there > shouldnt it? > > One minor question: What can i do that OpenJPA logs the params real values > instead of "?" ? > > Thanks > > --- > regards > Marc Logemann > http://www.logemann.org > http://www.logentis.de > > > > >
