org.hibernate.hql.ast.QuerySyntaxException: unexpected token:

Amit Kumar

My HQL : "from UserLocation where user.username =:username and timestamp > NOW() - INTERVAL :timeOffSet MINUTE";

I am getting following error:

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 101 [from jbossews.entities.UserLocation where user.username =:username and timestamp > NOW() - INTERVAL :timeOffSet MINUTE]
    at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
    at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
    at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
    at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
    at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
    at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:98)
    at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
    at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
    at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1760)
    at jbossews.dao.UserLocationDao.findUserLocations(UserLocationDao.java:44)
    at jbossews.process.LocationProcess.getUserLocation(LocationProcess.java:116)
    at jbossews.action.basic.UserRoaming.executeGetLocations(UserRoaming.java:69)
    at jbossews.action.basic.UserRoaming.getLocations(UserRoaming.java:58)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
    at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
    at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
    at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1527)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1484)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)

I am new to HQL. I want to set the Interval value dynamically through code. I have set parameter values where there is equal to comparison. I have read http://www.mkyong.com/hibernate/hibernate-parameter-binding-examples/ post but I am not sure how to set timeOffSet value where there is no other symbol.

Thnaks.

EDIT:

I tried with ? Positional parameters and its working fine but I want to do this with Named parameters.

Amit Kumar

For future readers,

I have solved this problem by using following HQL:

from UserLocation where user.username =:username and TIMESTAMPDIFF(MINUTE, timestamp, NOW()) <:timeOffSet

This will compare the two dates which will be computed on DB server removing any dependency from App server to calculate and send the timestamp to compare the date with.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token

From Dev

Selecting nested Hibernate immutable objects throws org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: new

From Dev

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1

From Dev

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: Apr near line 1, column 81

From Dev

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: distinct near line 1, column 17

From Dev

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: order near line 1, column 17 for absolutely unclear reasons

From Dev

Hibernate - org.hibernate.hql.internal.ast.QuerySyntaxException: Client is not mapped

From Dev

hql.ast.QuerySyntaxException: unexpected token running a query

From Java

org.hibernate.hql.internal.ast.QuerySyntaxException: table is not mapped

From Dev

How to solve org.hibernate.hql.ast.QuerySyntaxException: Exception

From Dev

org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped

From Dev

org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor

From Dev

I got an org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped exception

From Dev

Spring, Spring Data JPA: org.hibernate.hql.internal.ast.QuerySyntaxException: Test is not mapped

From Dev

org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: '1.id'

From Dev

org.hibernate.hql.internal.ast.QuerySyntaxException: EdbmsEmployee is not mapped [from EdbmsEmployee edbmsEmployee where edbmsEmployee.employeeid=?]

From Dev

Spring boot org.hibernate.hql.internal.ast.QuerySyntaxException: Utilisateur is not mapped (with MYSQL)

From Dev

Spring boot multiple module project org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped

From Dev

org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class

From Dev

org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: '1.id'

From Dev

Spring boot org.hibernate.hql.internal.ast.QuerySyntaxException: Utilisateur is not mapped (with MYSQL)

From Dev

I got an org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped exception

From Dev

java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException MS-Sql Server

From Dev

org.hibernate.hql.ast.QuerySyntaxException:on near line 1, column 102 [FROM com.strutsProject.dto.EventClubTb

From Dev

org.hibernate.hql.ast.QuerySyntaxException:on near line 1, column 102 [FROM com.strutsProject.dto.EventClubTb

From Dev

Hibernate HQL unexpected token with Likes

From Dev

QuerySyntaxException: Unexpected token *

From Dev

HQL unexpected AST node: :

From Dev

No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL

Related Related

  1. 1

    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token

  2. 2

    Selecting nested Hibernate immutable objects throws org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: new

  3. 3

    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1

  4. 4

    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: Apr near line 1, column 81

  5. 5

    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: distinct near line 1, column 17

  6. 6

    Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: order near line 1, column 17 for absolutely unclear reasons

  7. 7

    Hibernate - org.hibernate.hql.internal.ast.QuerySyntaxException: Client is not mapped

  8. 8

    hql.ast.QuerySyntaxException: unexpected token running a query

  9. 9

    org.hibernate.hql.internal.ast.QuerySyntaxException: table is not mapped

  10. 10

    How to solve org.hibernate.hql.ast.QuerySyntaxException: Exception

  11. 11

    org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped

  12. 12

    org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor

  13. 13

    I got an org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped exception

  14. 14

    Spring, Spring Data JPA: org.hibernate.hql.internal.ast.QuerySyntaxException: Test is not mapped

  15. 15

    org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: '1.id'

  16. 16

    org.hibernate.hql.internal.ast.QuerySyntaxException: EdbmsEmployee is not mapped [from EdbmsEmployee edbmsEmployee where edbmsEmployee.employeeid=?]

  17. 17

    Spring boot org.hibernate.hql.internal.ast.QuerySyntaxException: Utilisateur is not mapped (with MYSQL)

  18. 18

    Spring boot multiple module project org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped

  19. 19

    org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class

  20. 20

    org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: '1.id'

  21. 21

    Spring boot org.hibernate.hql.internal.ast.QuerySyntaxException: Utilisateur is not mapped (with MYSQL)

  22. 22

    I got an org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped exception

  23. 23

    java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException MS-Sql Server

  24. 24

    org.hibernate.hql.ast.QuerySyntaxException:on near line 1, column 102 [FROM com.strutsProject.dto.EventClubTb

  25. 25

    org.hibernate.hql.ast.QuerySyntaxException:on near line 1, column 102 [FROM com.strutsProject.dto.EventClubTb

  26. 26

    Hibernate HQL unexpected token with Likes

  27. 27

    QuerySyntaxException: Unexpected token *

  28. 28

    HQL unexpected AST node: :

  29. 29

    No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL

HotTag

Archive