org.hibernate.exception.SQLGrammarException: could not execute query?

Question

I got this exception when i try to get the list using NamedQuery:

org.hibernate.exception.SQLGrammarException: could not execute query

Below I mentioned code:

Entity Class Code:

@Table(name = "tbl_users")
@XmlRootElement
@NamedQueries({@NamedQuery(name = "TblUsers.findAll", query = "SELECT t FROM TblUsers t")});

DAO implement Code:

org.hibernate.Query query = session.getNamedQuery("TblUsers.findAll");
List list = query.list();

Please provide solution for this exception.

Have you tried just "from TblUsers t"? This is the correct HQL syntax. — Olaf
– Olaf, Commented Aug 1, 2011 at 14:10
You need to show the whole stack trace. SQLGrammarException means SQL (as translated by Hibernate) was not accepted by your database. Make sure that the table exists (in proper schema). — ChssPly76
– ChssPly76, Commented Aug 1, 2011 at 17:08

Dnavir · Accepted Answer · 2013-02-20 18:12:02Z

11

Was facing same issue for a while and figured out that the problem was due to the Table name being different from the class(or Entity) name in the database. Added the @Table(name = actual_table_name) annotation and it worked.

answered Feb 20, 2013 at 18:12

Dnavir

5644 silver badges11 bronze badges

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

Comments

Ryan Stewart · Accepted Answer · 2011-08-01 17:13:52Z

5

Get the SQL query that Hibernate is generating (using hibernate.show_sql or, preferably, Hibernate's SQL logging), and execute it against the database yourself. That will most likely help steer you in the right direction.

answered Aug 1, 2011 at 17:13

Ryan Stewart

130k22 gold badges183 silver badges201 bronze badges

1 Comment

cbmeeks Over a year ago

I've tried using hibernate.show_sql but all I get is insert into table (column) values (?) How can we actually see the REAL SQL and not just a bunch of ? marks?

Angad Bansode · Accepted Answer · 2018-08-10 08:17:14Z

1

Try this one it could work. It Perfectly worked for me.

1) Class level annotation.

@NamedQuery(name="UserDetails.byId" , query="from UserDetails where userId = ?")

2) Get record using NamedQuery

Query qry2 = sf.getCurrentSession().getNamedQuery("USER_DETAILS.byName")    ;
        qry2.setString(0, "Angad Bansode");
        List<UserDetails> user = qry2.list();
        for (UserDetails userDetails : user) {
            System.out.println("User Details by named native query  name = " + userDetails.getUserName() + ", aadhaar no  = " + userDetails.getAadharNo());
        }

answered Aug 10, 2018 at 8:17

Angad Bansode

1,02310 silver badges18 bronze badges

Comments

user4270323 · Accepted Answer · 2018-08-09 15:11:22Z

0

seems like this question is little old but any way once i added below line to hibernate config files it worked for me.

<property name="show_sql">true</property>

answered Aug 9, 2018 at 15:11

user4270323

Comments

Nainesh Patel · Accepted Answer · 2021-04-05 21:56:50Z

0

For me it was missing access to sequence for auto-increment primary key. After adding this error was resolved.

GRANT USAGE, SELECT ON ALL
    SEQUENCES IN SCHEMA public
    TO "${user-name}";;

answered Apr 5, 2021 at 21:56

Nainesh Patel

6382 gold badges7 silver badges19 bronze badges

Collectives™ on Stack Overflow

org.hibernate.exception.SQLGrammarException: could not execute query?

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related