Hibernate Migration

[renga ram]

Hi,

I am migrating my applications from hibernate 2.0 to 3.0. In my hbm.xml file name Hotlink.hbm.xml i have used the [CDATA] query which is creating the problem. What change i have to make in this Hotlink.hbm.xml file inorder to get this working done.please help me.Thanks in advance.
Here is my Hotlink.hbm.xml

I want to know what is the relavant query in hibernate3.0 for the below mentioned query which is written in hibernate 2.0
note: Its working fine in hibernate 2.0

<query name="getHotLinksByPermissionCode"><![CDATA[select link, userTargetedContent.displayName from HotLink link, UserTargetedContent userTargetedContent where link.userPermissionCode = userTargetedContent.userPermissionCode and link.userPermissionCode as (:userPermissionCode) order by link.userPermissionCode, link.displayName]]></query></hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping default-cascade="none">
    <class name="com.wamu.dashboard.hotlinks.HotLink" table="HOT_LINK">
        <id name="hotLinkId" type="integer" unsaved-value="null" >
            <column name="HOT_LINK_ID" sql-type="integer" not-null="true"/>
            <generator class="sequence">
                <param name="sequence">HOT_LINK_SEQ</param>
            </generator>
        </id>
        <property name="displayName">
            <column name="DISPLAY_NAME" sql-type="varchar(60)" />
        </property>
        <property name="userPermissionCode">
            <column name="USER_PERMISSION_CODE" sql-type="varchar(20)" />
        </property>
        <property name="link">
            <column name="LINK" sql-type="varchar(60)" not-null="true"/>
        </property>
    </class>
    [B]<query name="getHotLinksByPermissionCode"><![CDATA[select link, userTargetedContent.displayName from HotLink link, UserTargetedContent userTargetedContent where link.userPermissionCode = userTargetedContent.userPermissionCode and link.userPermissionCode as (:userPermissionCode) order by link.userPermissionCode, link.displayName]]></query>[/B]</hibernate-mapping>

The error is listed below.

<Jan 8, 2007 10:14:47 PM PST> <Error> <T3Services> <000000> <org.hibernate.impl.SessionFactoryImpl: Error in named query: getHotLinksByPermissionCode

org.hibernate.QueryException: in expected: userTargetedContent [select link, userTargetedContent.displayName from com.wamu.dashboard.hotlinks.HotLink link, UserTargetedContent userTargetedContent where link.userPermissionCode = userTargetedContent.userPermissionCode and link.userPermissionCode in (:userPermissionCode) order by link.userPermissionCode, link.displayName]
at org.hibernate.hql.classic.FromParser.token(FromParser.java:106)
at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:86)
at org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:108)
at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:29)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:176)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:152)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:425)
at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:386)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:289)

My hibernate.cfg.xml file is given below

<?xml version='1.0' encoding='utf-8'?> 
<!DOCTYPE hibernate-configuration PUBLIC 
"-//Hibernate/Hibernate Configuration DTD 3.0//EN" 
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> 
<hibernate-configuration> 
<session-factory> 
<property name="connection.datasource">weblogic.jdbc.jts.WAMUPool</property> 
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property> 
<property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property> 
 
Thanks in advance.. 
 
<!-- <property name="show_sql">true</property> --> 
<mapping resource="/com/wamu/dashboard/hotlinks/HotLink.hbm.xml"/> 
<mapping resource="/com/wamu/dashboard/security/permission/Permission.hbm.xml"/> 
<mapping resource="/com/wamu/dashboard/security/permission/UserTargetedContent.hbm.xml"/> 
</session-factory> 
</hibernate-configuration> 

[Mark Spritzler]

Is this different than your other thread? Please do not duplicate post.

Mark