Hi,

I'm a new user here stuck trying to load a collection using a custom sql. I would appreciate any help on this. Here is the simplified version of my mapping:

<hibernate-mapping>

<class name="net.newfoundcomm.gps.dao.user.User" table="users">
<id name="id" column="user_id" type="java.lang.Long">
<generator class="native"/>
</id>

<set name="items" lazy="false">
<key column="item_id"/>
<one-to-many class="net.newfoundcomm.gps.dao.item.Item"/>
<loader query-ref="getItems"/>
</set>

</class>

<sql-query name="getItems">
<load-collection alias="i" role="User.items"/>
select {i.*} from items i
</sql-query>

</hibernate-mapping>

Here is the exception I get:
Caused by: org.hibernate.HibernateException: Errors in named queries: getItems

I tried searching on the internet but couldn't find any solution. I'd greatly appreciate any input on this.

Thanks.

Read this one. It might give you an idea:


http://forum.hibernate.org/viewtopic.php?t=982986



Farzad-

Thanks for your reply. I'm trying to load the collection along with the Parent class 'User'. My mapping looks similar to the one in that post and it looks very much like the any thing you would find in the docs.

But not sure what is wrong with the sql. Do you see anything wrong there?

Have you tried the following?




Remember you will need at least one parameter.


Let me know how it goes and give me the whole exception if this breaks.

Farzad-

And should I be passing the parameter value to that query? Here is the entire stack trace:

Caused by: org.hibernate.HibernateException: Errors in named queries: getItems
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:365)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1300)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:805)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:745)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:134)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1172)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:427)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:267)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1100)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:862)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:423)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at net.newfoundcomm.gps.util.test.Test.getUser(Test.java:92)
at net.newfoundcomm.gps.util.test.Test.main(Test.java:43)


Thanks for your help.

No Hibernate does it for you. This is way before that anyways. Which hibernate version are you using? I did an example last night and it worked for me. I am using 3.2.5 and I can send you the example later in the day, when I get home.



Farzad-

I'm using 3.2.6. An example would be great. Thanks a lot.

There you go:




Farzad-

Thank you. I'll try this out and let you know how it goes.