cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: How to create a EJBLQuery with a named parameterized query stored in the mapping?
Date Fri, 29 Jun 2012 14:10:06 GMT
This was just fixed on 3.1 and 3.2 (aka trunk) branches - https://issues.apache.org/jira/browse/CAY-1715


On Jun 27, 2012, at 5:20 PM, Andrus Adamchik wrote:

> I'll open a bug report. Thanks!
> 
> On Jun 27, 2012, at 4:20 PM, gilbertoca wrote:
> 
>> Confirmed:
>> 
>> EJBQLQuery query = new EJBQLQuery("delete from LegalEntity l where l.id =
>> :id");
>> query.setParameter("id", 1010L);
>> 
>> 
>> 
>>> Jun 27, 2012 10:13:01 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logConnect
>>> INFO: Opening connection:
>>> jdbc:h2:file:data/parkDB;create=true;MODE=PostgreSQL;DB_CLOSE_DELAY=-1
>>>       Login: click
>>>       Password: *******
>>> Jun 27, 2012 10:13:01 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logConnectSuccess
>>> INFO: +++ Connecting: SUCCESS.
>>> Jun 27, 2012 10:13:01 AM org.apache.cayenne.log.CommonsJdbcEventLogger log
>>> INFO: Detected and installed adapter: org.apache.cayenne.dba.h2.H2Adapter
>>> Jun 27, 2012 10:13:01 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logBeginTransaction
>>> INFO: --- transaction started.
>>> Jun 27, 2012 10:13:01 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logQuery
>>> INFO: DELETE FROM PERSON WHERE PERSON.ID = ? [bind: 1:1010]
>>> Jun 27, 2012 10:13:01 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logQueryError
>>> 
>> 
>> NamedQuery query = new NamedQuery("LegalEntity.deleteById",
>> Collections.singletonMap("id", new Long[]{1010L}));
>> 
>> 
>> 
>>> Jun 27, 2012 10:12:25 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logConnect
>>> INFO: Opening connection:
>>> jdbc:h2:file:data/parkDB;create=true;MODE=PostgreSQL;DB_CLOSE_DELAY=-1
>>>       Login: click
>>>       Password: *******
>>> Jun 27, 2012 10:12:25 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logConnectSuccess
>>> INFO: +++ Connecting: SUCCESS.
>>> Jun 27, 2012 10:12:25 AM org.apache.cayenne.log.CommonsJdbcEventLogger log
>>> INFO: Detected and installed adapter: org.apache.cayenne.dba.h2.H2Adapter
>>> Jun 27, 2012 10:12:25 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logBeginTransaction
>>> INFO: --- transaction started.
>>> Jun 27, 2012 10:12:26 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logQuery
>>> INFO: DELETE FROM PERSON WHERE PERSON.ID = ? [bind: 1:NULL]
>>> Jun 27, 2012 10:12:26 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logUpdateCount
>>> INFO: === updated 0 rows.
>>> Jun 27, 2012 10:12:26 AM org.apache.cayenne.log.CommonsJdbcEventLogger
>>> logCommitTransaction
>>> 
>> 
>> I can not see the Query.setParameter() pattern in the NamedQuery as well.
>> 
>> [1]
>> http://code.google.com/p/construtor/source/browse/trunk/park-samples/park-cayenne/src/test/java/park/model/LegalEntityTest.java
>> 
>> --
>> View this message in context: http://cayenne.195.n3.nabble.com/How-to-create-a-EJBLQuery-with-a-named-parameterized-query-stored-in-the-mapping-tp4024333p4024335.html
>> Sent from the Cayenne - User mailing list archive at Nabble.com.
>> 
> 
> 


Mime
View raw message