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
>> 
>> 
>> 
>> 
>> 

Reply via email to