Hibernate Community • View topic - Named Queries in Hibernate

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Named Queries in Hibernate

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

versoft

Post subject: Named Queries in Hibernate

Posted: Fri Feb 23, 2007 4:01 pm

Newbie

Joined: Wed Nov 22, 2006 5:09 pm
Posts: 8

Hi Friends,

I have a issue using named queries in hibernate. I have defined the followinf query in my mapping file (This mapping file just has SQL qureies)

Code:

   <sql-query name="GET_PERMISSIONS">
      <![CDATA[
         SELECT
            permission_id,
            permission_name,
            permission_desc
         FROM
            bsl_permission
         WHERE
            function_id = ?
         ORDER BY 
            permission_name
        ]]>
   </sql-query>

How do i get the results.

Thanks In Advance - Amit

Top

somu

Post subject:

Posted: Fri Feb 23, 2007 7:22 pm

Regular

Joined: Sun Sep 17, 2006 2:48 am
Posts: 81
Location: California

Use session.getNamedQuery("GET_PERMISSIONS") to get the query. Set values in the query and then call list(). I am not sure if SQLQuery works like this, but I have certainly used HQL like this.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum