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

Crazy Coder

I have for to login my site

<form method="post" action="login">
    <input type="text" placeholder="Email" name="email">
    <input type="password" placeholder="Password" name="password">
    <button type="submit">Login</button>
</form>

in controller I have

@RequestMapping(value="/login",method=RequestMethod.POST)
    public String loginUser(@RequestParam("email") String email,
            @RequestParam("password") String password,Model model,HttpSession session){

        User persistedUser = userService.getUserByEmail(email);

        if(persistedUser!=null && persistedUser.getPassword().equals(password)){
            session.setAttribute("user", persistedUser);
            return "home";
        }else{
            model.addAttribute("error", "Incorrect username or password, Please try again!");
            return "login";
        }

    }

and in UserService I getUserByEmail() as

public User getUserByEmail(String email) {
        return (User) em.createQuery("SELECT * FROM User u WHERE  u.email = :email").setParameter(email, "Not Found");
    }

when i try to log in I get

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [SELECT * FROM com.rhcloud.giveme.entity.User u WHERE  u.email = :email]
    at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:91)
    at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:109)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:304)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:126)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:88)
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:190)
    at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
    at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
    at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1800)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:328)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:344)
    at $Proxy76.createQuery(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:291)
    at $Proxy70.createQuery(Unknown Source)
    at com.rhcloud.giveme.service.UserService.getUserByEmail(UserService.java:33)
    at com.rhcloud.giveme.service.UserService$$FastClassBySpringCGLIB$$11c5f2a8.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:649)
    at com.rhcloud.giveme.service.UserService$$EnhancerBySpringCGLIB$$79be29e2.getUserByEmail(<generated>)
    at com.rhcloud.giveme.controller.LoginController.loginUser(LoginController.java:31)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Unknown Source)

How can I write correct query for getUserByEmail(), so that I can get rid of this exception.

BackSlash

You have to omit the SELECT * part, it's implicit:

return (User) em.createQuery("FROM User u WHERE  u.email = :email").setParameter(email, "Not Found");

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: 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

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.ast.QuerySyntaxException: unexpected token:

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 - org.hibernate.hql.internal.ast.QuerySyntaxException: Client is not mapped

From Java

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

From Dev

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

From Dev

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

From Dev

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

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: 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

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

hql.ast.QuerySyntaxException: unexpected token running a query

From Dev

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

From Dev

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

From Dev

HQL Related issue unexpected token: InnerJoin near line 1, column 257

From Dev

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

From Dev

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

From Dev

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

From Dev

Hibernate HQL unexpected token with Likes

From Dev

What does org.hibernate.hql.internal.ast.tree.Node means in jmap heap dump

Related Related

  1. 1

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

  2. 2

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

  3. 3

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

  4. 4

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

  5. 5

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

  6. 6

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

  7. 7

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

  8. 8

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

  9. 9

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

  10. 10

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

  11. 11

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

  12. 12

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

  13. 13

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

  14. 14

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

  15. 15

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

  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

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

  20. 20

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

  21. 21

    hql.ast.QuerySyntaxException: unexpected token running a query

  22. 22

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

  23. 23

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

  24. 24

    HQL Related issue unexpected token: InnerJoin near line 1, column 257

  25. 25

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

  26. 26

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

  27. 27

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

  28. 28

    Hibernate HQL unexpected token with Likes

  29. 29

    What does org.hibernate.hql.internal.ast.tree.Node means in jmap heap dump

HotTag

Archive