Hibernate queries in jsp page

[madhupara]

I have a jsp page something like this,

<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>

<sql:query var="TypeMaster" scope="request">
    SELECT c_org_id,c_org_name FROM t_gb_organization_master order by c_org_name;
</sql:query>

I need to convert this query using hibernate.which taglib can i use to write hql query.

Can anybody help me?

[r035198x]

You should consider those sql tags as taboo and only ever use them for quick tests.
They should never find their way to production. Even the sun tutorial says they are "designed for quick prototyping and simple applications. For production applications, database operations are normally encapsulated in JavaBeans components".

[madhupara]

Actually, I have a webapplication which is using struts1.x with mysql connection .I am trying to change the web application using hibernate with struts1.x.
In my action class i can write hibernate query like this

 ServletContext context = request.getSession().getServletContext();
        /*Retrieve Session Factory */
        SessionFactory _factory = (SessionFactory) context.getAttribute(HibernatePlugIn.SESSION_FACTORY_KEY);
        /*Open Hibernate Session */
        Session session = _factory.openSession();
         String HQL_QUERY = "select NNoOfAttempt,CStatus,CLastAccessedTime,CBranchId,"
                + "CGroupId, COrgId,CStateId,CRegionId,CUserName from TGbUserMaster"
                + " where CUserName='" + userId + "' and CPassword='" + encryptPass + "'";

        Query query = session.createQuery(HQL_QUERY);

In my previous webapplication i have some SQLqueries(

<sql:query   var="TypeMaster" scope="request">
    SELECT c_org_id,c_org_name FROM t_gb_organization_master order by c_org_name;
</sql:query>

) written in jsp page, Now i need some way to convert this sql queries in jsp page to hql queries
But am really not understanding how to write queries in jsp.Can you please help me?

[r035198x]

You simply don't write queries in JSPs. That is what my post is about and what that quote from the sun tutorial is also saying.

[Aseem]

yeah...u dont write queries in JSP. Infact in real time, there is hardly any code in JSPs. JSPs are used only for presentation logic not for business logics.