HQL Query

davidwsica · **Joined:** Thu Jul 28, 2005 1:22 pm **Posts:** 3

I've got a query I need to execute on an Informix database. The SQL given to me to implement in my HQL contains the following clause:

Code:

OR (p.swdatecreated + 120 UNITS DAY) >= CURRENT

I get the following error for this query:

Code:

org.hibernate.hql.ast.QuerySyntaxError: unexpected token: DAY near line 51, column 90 [   

Any ideas how I can implement this type of clause with HQL?

Thanks,
David

jd001982 · **Posted:** Mon Nov 14, 2005 6:27 pm

HQL has its own syntax while your query is Informix-specific. Try Session.createSQLQuery(...) instead.

jd

davidwsica · **Joined:** Thu Jul 28, 2005 1:22 pm **Posts:** 3

jd001982 wrote:

HQL has its own syntax while your query is Informix-specific. Try Session.createSQLQuery(...) instead.

jd

Thanks for the feedback. Is there some way for me to rewrite this clause logic in HQL (i.e. date1 + 120 days >= date2)?

David

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

you will must use native sql for informix, probably

hhuber · **Posted:** Tue Nov 15, 2005 4:04 am

davidwsica wrote:

I've got a query I need to execute on an Informix database. The SQL given to me to implement in my HQL contains the following clause:

Code:

OR (p.swdatecreated + 120 UNITS DAY) >= CURRENT

I get the following error for this query:

Code:

org.hibernate.hql.ast.QuerySyntaxError: unexpected token: DAY near line 51, column 90 [   

Any ideas how I can implement this type of clause with HQL?

Is CURRENT some built in function for the current date?

Then you're lucky.

Code:

OR p.swdatecreated >= :current

and

Code:

Calendar c = new GregorianCalendar();
c.add(Calendar.DATE, -120);
q.setCalendar("current", c);

[/code]

davidwsica · **Joined:** Thu Jul 28, 2005 1:22 pm **Posts:** 3

hhuber wrote:

davidwsica wrote:

I've got a query I need to execute on an Informix database. The SQL given to me to implement in my HQL contains the following clause:

Code:

OR (p.swdatecreated + 120 UNITS DAY) >= CURRENT

I get the following error for this query:

Code:

org.hibernate.hql.ast.QuerySyntaxError: unexpected token: DAY near line 51, column 90 [   

Any ideas how I can implement this type of clause with HQL?

Is CURRENT some built in function for the current date?

Then you're lucky.

Code:

OR p.swdatecreated >= :current

and

Code:

Calendar c = new GregorianCalendar();
c.add(Calendar.DATE, -120);
q.setCalendar("current", c);

[/code]

Thanks, actually this solution occured to me just prior to reading your suggestion. I'm glad I can avoid native SQL.