Hibernate Exception while executing query

Question

Following is my code snippet:

ApplicationContext ctx = new ClassPathXmlApplicationContext(
                    "classpath*:META-INF/spring/applicationContext*.xml");
            JpaTransactionManager jpatm = (JpaTransactionManager) ctx
                    .getBean("transactionManager");
            EntityManager em = jpatm.getEntityManagerFactory()
                    .createEntityManager();
String sqlQuery = "SELECT suc FROM SubUsrCont suc, UDMap uDMap WHERE suc.userid = uDMap.userid AND uDMap.parentuserid = :parentuserid";
TypedQuery<SubUsrCont> query = (TypedQuery<SubUsrCont>) em.createQuery(sqlQuery, SubUsrCont.class);
query.setParameter("parentuserid", parentid);
ArrayList<SubUsrCont> listContent = (ArrayList<SubUsrCont>) query.getResultList();

But when ever executed I get the following error:

[http-8080-1] ERROR org.hibernate.hql.PARSER - line 1:92: expecting OPEN, found '.'

Can anybody help???

Debopam Mitra · Accepted Answer · 2013-01-16 07:45:21Z

1

Well, I found it and successfully tested it as well. It was due to my POJO package name. Previously it was in.myproject.myname. I changed it to com.myproject.myname. HQL was taking in as the SQL Keyword IN and was looking for OPEN '('.

answered Jan 16, 2013 at 7:45

Debopam Mitra

1,8704 gold badges28 silver badges51 bronze badges

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

Comments

shazin · Accepted Answer · 2013-01-16 06:26:27Z

0

Why are you using a Native SQL query inside em.createQuery()? This will not work because HQL can not have SELECT and furthermore you don't set the value for parameter :parentuserid.

String sqlQuery = "FROM SubUsrCont suc, UDMap uDMap WHERE suc.userid = uDMap.userid AND uDMap.parentuserid = :parentuserid";
TypedQuery<SubUsrCont> query = (TypedQuery<SubUsrCont>) em.createQuery(sqlQuery, SubUsrCont.class);
query.setParameter("parentuserid", <PARENT USER ID TO BE SEARCHED>);

Try this and see

answered Jan 16, 2013 at 6:26

shazin

22k3 gold badges58 silver badges72 bronze badges

1 Comment

Debopam Mitra Over a year ago

@shazin... It ain't working.... org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.ast.QuerySyntaxException...

StanislavL · Accepted Answer · 2013-01-16 06:26:59Z

0

If you would like to execute SQL use createNativeQuery. Also try "SELECT suc.* ...

Also you don't set the parameter :parentuserid

Use query setParameter("parentuserid",someValue)

answered Jan 16, 2013 at 6:26

StanislavL

57.5k9 gold badges75 silver badges100 bronze badges

1 Comment

Debopam Mitra Over a year ago

@StanislavL... Well it's not working. But I know what the problem is. I have used Spring Roo to generate the project. So the actual table name in the DB in the case of SubUsrCont POJO is sub_usr_cont. Now when I used createNativeQuery it is simply converting the SubUsrCont to subusrcont. Which actually doesn't exists in the DB. I get the following error: ERROR org.hibernate.util.JDBCExceptionReporter - Table 'mydb.subusrcont' doesn't exist

Collectives™ on Stack Overflow

Hibernate Exception while executing query

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related