Problem with the parameterized query in hbm.xml

gzhuye · **Joined:** Mon Feb 06, 2006 2:56 pm **Posts:** 2

Hibernate version: 3.0

I make 2 queries as below in log_info.hbm.xml. When I run it, the following exception thrown with the 2nd query. The first qury is correct, and 2rd has problem with "?1". When I move "?1" to a specific value (12), it has no problem.

Who can help me?

Thanks

gzhuye

Query in log_info.hbm.xml:

Code:

   <query name="com.atlantics.atm.db.bean.Log_info.getAllLogInfo"><![CDATA[
            from com.atlantics.atm.db.bean.Log_info
    ]]></query>
    <query name="com.atlantics.atm.db.bean.Log_info.getSearchLogInfo"><![CDATA[
            from com.atlantics.atm.db.bean.Log_info as tbl where tbl.log_info_id = ?1
    ]]></query>

Exception:

Code:

org.hibernate.HibernateException: Errors in named queries: com.atlantics.atm.db.bean.Log_info.getSearchLogInfo
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:302)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:769)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:695)

[/code]

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

What is "?1" supposed to mean? For a query you can use SQL-style ? parameters (0 based, not 1 based as they are in SQL), or named parmaeters (e.g. ":param1"), but "?1" isn't a parameter.

gzhuye · **Joined:** Mon Feb 06, 2006 2:56 pm **Posts:** 2

Thank you very much! I just followed a doc on ibm developer: http://www-128.ibm.com/developerworks/j ... /j-hibern/

something wrong with it, it shouldn't use sql parameters like ?1, ?2....

Regards

gzhuye

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Yes, that article is wrong. Don't forget to rate if you think my answer helped.

max · **Posted:** Tue Feb 07, 2006 3:39 am

?1 is actually supported now for ejbql 2.1 good old time sake - but don't use it :)

...but the article is from before that, so yes it is weird.