Hibernate Named query not know error

Question

I dont know why but when I import this project to Eclipse. This work well.

So, I think this is problem of eclipse project when import to InteliJ IDEA

This not easy such my imagine.

I have class Setting and Setting.hbm.xml for mapping hibernate. In this class:

<hibernate-mapping>
<class name="Setting" table="setting" lazy="false">
    <id name="id" column="id" type="integer">
        <generator class="increment" />
    </id>

    .....
</class>

<query name="select.setting">
    from Setting as s where s.id = ? order by s.name
</query>

Now, when I call function

this.getHibernateTemplate().findByNamedQuery("select.setting", params);

This return error

org.springframework.orm.hibernate4.HibernateSystemException: Named query not known: select.setting; nested exception is org.hibernate.MappingException: Named query not known: select.setting
at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:218) ~[spring-orm-4.1.6.RELEASE.jar:4.1.6.RELEASE]
at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:343) ~[spring-orm-4.1.6.RELEASE.jar:4.1.6.RELEASE]
at org.springframework.orm.hibernate4.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:308) ~[spring-orm-4.1.6.RELEASE.jar:4.1.6.RELEASE]
at org.springframework.orm.hibernate4.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:933) ~[spring-orm-4.1.6.RELEASE.jar:4.1.6.RELEASE]

Please give advice about it.

Possible duplicate qtn. Check this link stackoverflow.com/questions/26084031/… — Killer
– Killer, Commented Dec 2, 2015 at 10:01
Does the name of the query without dot give the same result ? (Say : "selectSetting" instead of "select.setting", for example). — Arnaud
– Arnaud, Commented Dec 2, 2015 at 10:06
Yes, I use spring boot and already set mapping @Bean public LocalSessionFactoryBean sessionFactory() throws Exception { LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean(); sessionFactory.setDataSource(dataSource()); sessionFactory.setHibernateProperties(hibernateProperties()); sessionFactory.setMappingDirectoryLocations(new ClassPathResource[] { new ClassPathResource("data/model") }); — Tran Vinh Quang
– Tran Vinh Quang, Commented Dec 2, 2015 at 10:21

Lovababu Padala · Accepted Answer · 2015-12-02 11:09:48Z

1

You can give a try with this.

<query name="select.setting">
    <![CDATA[from Setting as s where s.id = ? order by s.name]]>
</query>

answered Dec 2, 2015 at 11:09

Lovababu Padala

2,4972 gold badges25 silver badges33 bronze badges

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

Comments

AnirbanDebnath · Accepted Answer · 2015-12-02 11:28:48Z

0

The XML parser gets confused of you are not using CDATA tag. CDATA is way of telling the framework that its a data which should not be interpreted as a markup.

Hence as @Lovababu mentioned, include the query inside CDATA tags:

<query name="select.setting">
<![CDATA[from Setting as s where s.id = ? order by s.name]]>

answered Dec 2, 2015 at 11:28

AnirbanDebnath

1,05317 silver badges26 bronze badges

Collectives™ on Stack Overflow

Hibernate Named query not know error

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related