Iam facing a problem in HQL querry
when I write Query [SELECT COUNT(msg.id) FROM msg in class com.ebw.cds.persistence.db.Message where ( msg.parsingStatus = 1 or msg.parsingStatus = 5 ) AND msg.receivedDateTime >=to_date('02/10/2006 00:00:00','mm/dd/yyyy HH24:mi:ss') AND msg.receivedDateTime <= to_date('02/10/2006 23:59:59','mm/dd/yyyy HH24:mi:ss') AND TRIM(UPPER(msg.rawText)) LIKE UPPER('%----- BAS UTILITIES OPEN INVESTMENT GRADE CDS CURVES%')]

it works but when I write Querry and : found in TRIM(UPPER(msg.rawText)) LIKE UPPER('%----- BAS UTILITIES OPEN : INVESTMENT GRADE CDS CURVES%')]
I got folowing exception


Exception net.sf.hibernate.QueryException: Not all named parameters have been set: [] [SELECT COUNT(msg.id) FROM msg in class com.ebw.cds.persistence.db.Message where ( msg.parsingStatus = 1 or msg.parsingStatus = 5 ) AND msg.receivedDateTime >=to_date('02/10/2006 00:00:00','mm/dd/yyyy HH24:mi:ss') AND msg.receivedDateTime <= to_date('02/10/2006 23:59:59','mm/dd/yyyy HH24:mi:ss') AND TRIM(UPPER(msg.rawText)) LIKE UPPER('%----- BAS UTILITIES OPEN : INVESTMENT GRADE CDS CURVES%')]

I looks to me that hibernate sees the ':' of your date in your query as named parameters.

I think you should set the dates in your query as named parameters:

eg:

[SELECT COUNT(msg.id) FROM msg in class com.ebw.cds.persistence.db.Message where ( msg.parsingStatus = 1 or msg.parsingStatus = 5 ) AND msg.receivedDateTime >= :date1 AND msg.receivedDateTime <= :date2 AND TRIM(UPPER(msg.rawText)) LIKE UPPER('%----- BAS UTILITIES OPEN INVESTMENT GRADE CDS CURVES%')]

followed by

query.setParameter("date1",02/10/2006 00:00:00');
query.setParameter("date2",02/10/2006 23:59:59);



PS:don't forget to rate