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 Wed, 27 Jun 2012 14:20:26 GMT
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