[eclipselink-users] using mysql functions in queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]

[eclipselink-users] using mysql functions in queries

From: Derek Knapp <derek@xxxxxxxxxxxxxx>
Date: Fri, 23 Oct 2009 14:09:05 -0400
Comment: DomainKeys? See http://domainkeys.sourceforge.net/
Delivered-to: eclipselink-users@eclipse.org
Dkim-signature: v=1; a=rsa-sha1; c=relaxed; d=itracmedia.com; h= message-id:date:from:mime-version:to:subject:content-type; s= default; bh=4B8/2TVMBu93wle584rJjN8rDj4=; b=UKVuCPctk7MIQzzXpNFm Cfu9b7GC82uTUZo5QeXL4cAy5ZhfWFJhXSQSIjoHAvV8ML09SEoTwex+GfhGzBwn GZMjLjnsnnGBzCukz5HQ3H6tVXkRl7YJsBYrVxuf4Tcy
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=itracmedia.com; b=glvDUbxvPY5XVCLXegI9Ff7Qc1ZCmS//449DshYRpRBo0lulkwzaFJGsfWBQ+530jMPbZ+2ZjbWJCORKqQbvjALuagErGkW9cE3i1TQthw14tOUYxWggcW5j3LBnGlbs; h=Received:Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type;
User-agent: Thunderbird 2.0.0.14 (X11/20080721)

is it possible to do something like

select t from Tasklist t where t.userid = :user and t.taskstatus = 'open' and cast(t.duetime as date) = :today order by t.duetime

this is the exception I get when I try. I assume cast is mysql specific?

Exception Description: Syntax error parsing the query [select t from Tasklist t where t.userid = :user and t.taskstatus = 'open' and cast(t.duetime as date) = :today order by t.duetime], line 1, column 78: unexpected token [cast].
Internal Exception: NoViableAltException(66!=[792:1: arithmeticPrimary returns [Object node] : ({...}?n= aggregateExpression | n= variableAccess | n= stateFieldPathExpression | n= functionsReturningNumerics | n= functionsReturningDatetime | n= functionsReturningStrings | n= inputParameter | n= literalNumeric | n= literalString | n= literalBoolean | LEFT_ROUND_BRACKET n= simpleArithmeticExpression RIGHT_ROUND_BRACKET );])
        at org.eclipse.persistence.exceptions.JPQLException.unexpectedToken(JPQLException.java:365)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.handleRecognitionException(JPQLParser.java:319)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.addError(JPQLParser.java:245)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.reportError(JPQLParser.java:362)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticPrimary(JPQLParser.java:8904)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticFactor(JPQLParser.java:8620)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticTerm(JPQLParser.java:8444)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.simpleArithmeticExpression(JPQLParser.java:8351)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticExpression(JPQLParser.java:8292)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.simpleConditionalExpression(JPQLParser.java:7039)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.conditionalPrimary(JPQLParser.java:6997)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.conditionalFactor(JPQLParser.java:2989)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.conditionalTerm(JPQLParser.java:2903)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.conditionalExpression(JPQLParser.java:2805)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.whereClause(JPQLParser.java:2762)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectStatement(JPQLParser.java:356)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.document(JPQLParser.java:261)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.parse(JPQLParser.java:133)
        at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.buildParseTree(JPQLParser.java:94)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:203)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:170)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:134)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:95)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:80)
        at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:740)
        ... 96 more
Caused by: NoViableAltException(66!=[792:1: arithmeticPrimary returns [Object node] : ({...}?n= aggregateExpression | n= variableAccess | n= stateFieldPathExpression | n= functionsReturningNumerics | n= functionsReturningDatetime | n= functionsReturningStrings | n= inputParameter | n= literalNumeric | n= literalString | n= literalBoolean | LEFT_ROUND_BRACKET n= simpleArithmeticExpression RIGHT_ROUND_BRACKET );])
        at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticPrimary(JPQLParser.java:8678)
        ... 116 more

Follow-Ups:
- Re: [eclipselink-users] using mysql functions in queries
  - From: Tim Hollosy

Prev by Date: [eclipselink-users] EclipseLink 1.2.0
Next by Date: Re: [eclipselink-users] using mysql functions in queries
Previous by thread: [eclipselink-users] generating IDs with a stored procedure
Next by thread: Re: [eclipselink-users] using mysql functions in queries
Index(es):
- Date
- Thread