Hibernate sql query error

Question

following is the query:

    Query q = getSession().createQuery("FROM secroles 
                           WHERE secroles.SR_ORG = :srOrg , 
                                 secroles.SR_PROFILE= :srUser, 
                                 ISDELETED=:isDeleted");

error:

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: , near line 1, column 37 [FROM secroles WHERE SR_ORG = :srOrg , SR_PROFILE= :srUser , ISDELETED = :ISDELETED]

complete function:

public String getSecroleByOrgNID(Organization srOrg, Profile srUser){try {
        System.out.println("bug is here0");
        begin();
        Query q = getSession().createQuery("FROM secroles WHERE secroles.SR_ORG = :srOrg , secroles.SR_PROFILE= :srUser , ISDELETED=:isDeleted");
        q.setParameter("srOrg", srOrg);
        q.setParameter("srOrg", srUser);
        q.setBoolean("isDeleted", false);
        Secroles sr = (Secroles) q.uniqueResult();
        Roletable rt = sr.getSrRole();
        commit();
        return rt.getRoleName();
    } catch( HibernateException e ) {
        rollback();
        e.printStackTrace();
        System.out.println("Could not assign role\n Message: "+e.getMessage());
    }
return null;

}

}

Alex Gitelman · Accepted Answer · 2011-05-31 18:42:01Z

2

You put , instead of AND, I presume.

Also you should use class property names not column names. So probably secroles.srOrg instead of secroles.SR_ORG

answered May 31, 2011 at 18:42

Alex Gitelman

24.8k7 gold badges54 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

rahul.jain Over a year ago

not working, getting the error: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: , near line 1, column 37 [FROM secroles WHERE secroles.srOrg = :SR_ORGsrOrg , secroles.srUser= :SR_PROFILE , ISDELETED = :ISDELETED]

Alex Gitelman Over a year ago

Are you sure it's the same error? Are you using property names as I suggested? 'Cause your names look like column names. What I suggest - assign your query to the variable, and print it. Then post output with exact error message.

Alex Gitelman Over a year ago

Also what is secroles? It should be class name.

rahul.jain Over a year ago

initializing the variable to null and then assigned query to the variable and getting nothing in the output.

Alex Gitelman Over a year ago

In HQL you should speak classes and properties language. Not tables and columns. Use its mapped class name instead and corresponding properties.

|

rkg · Accepted Answer · 2011-05-31 18:42:56Z

2

Use AND instead of "," for multiple clauses. Refer to the documentation on how to use WHERE clause: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html

FROM secroles 
WHERE secroles.SR_ORG = :srOrg AND
      secroles.SR_PROFILE= :srUser AND
      ISDELETED=:isDeleted

answered May 31, 2011 at 18:42

rkg

5,6849 gold badges39 silver badges50 bronze badges

Comments

Alex Barnes · Accepted Answer · 2011-05-31 22:03:33Z

0

Also you bind the same parameter twice using different variables according to the code above. I'm pretty sure that won't do what you expect.

    q.setParameter("srOrg", srOrg);
    q.setParameter("srOrg", srUser);

answered May 31, 2011 at 22:03

Alex Barnes

7,2281 gold badge32 silver badges51 bronze badges

Collectives™ on Stack Overflow

Hibernate sql query error

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related