List problem

TJim · **Joined:** Mon Oct 17, 2005 4:10 am **Posts:** 6

Hi

I am very new to Hibernate

In my application, i can enter records into database but i am unable to list them in a jsp. here is the code..

code in my jsp:

Code:

<%
Session hibsession = null;

try{
         System.out.println("Listing Records..");
         // This step will read hibernate.cfg.xml and prepare hibernate for use
         SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
          hibsession =sessionFactory.openSession();
          
          org.hibernate.Transaction tx = hibsession.beginTransaction();
          
            List empList = hibsession.createQuery("from empdata order by empid").list();
            Iterator empIter = empList.iterator();
            
            while(empIter.hasNext()){
            
            Empdata empdata = (Empdata)empIter.next();
%>

This is the error in console:

Code:

empdata is not mapped. [from empdata order by empid]

plz let me know where i am making the mistake...

Rgds,
Jim.

anandbn · **Posted:** Tue Aug 01, 2006 7:06 am

I think the query should be

Code:

from Empdata as empdata order by empid

Unless you use "as" to alias Hibernate would think the value is a mapped peristent class.

MikePloed · **Posted:** Tue Aug 01, 2006 7:06 am

1) You should not write Hibernate Code in a JSP ;-)

2) Please make sure that your Hibernate Mappings are contained in your WAR / EAR File

TJim · **Joined:** Mon Oct 17, 2005 4:10 am **Posts:** 6

anandbn wrote:

I think the query should be

Code:

from Empdata as empdata order by empid

Unless you use "as" to alias Hibernate would think the value is a mapped peristent class.

yes now i can list my values after changing they query as u said..thats right..

Thx & Rgds,
Jim.