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 <l...@logemann.org> wrote: > 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, > > > > 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 <l...@logemann.org> 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 > >> > >> > >> > >> > >> > >
