Problem in Select query

[Pradeeep Sharma]

Hi,
First Merry Christmas to all!

I am new to hibernate i am facing problem in implementing HQL for select query. Below is my hbm file:

  <hibernate-mapping>
	<class name="com.HiberTest.bean.Register" table="CONTACT">
		<id name="id" type="int" column="ID">
			<generator class="increment"></generator>
		</id>
		<property name="firstName">
			<column name="FIRSTNAME"></column>
		</property>
		<property name="lastName">
			<column name="LASTNAME"></column>
		</property>
		<property name="email">
			<column name="EMAIL"></column>
		</property>


	</class>
</hibernate-mapping>  

and the related HQL for this in POJO class

   String SQL_QUERY ="Select CONTACT.firstName,CONTACT.lastName,CONTACT.email from Register CONTACT";
			query = hsession.createQuery(SQL_QUERY); 

but when I try to run this i got error message like this:

Hibernate: select register0_.FIRSTNAME as col_0_0_, register0_.LASTNAME as col_1_0_, register0_.EMAIL as col_2_0_ from CONTACT register0_
java.lang.String

As the name has changed in query i am not able to get any record from database.
Can any one tell me what s the actual solution for this problem.

With Regards,
Pradeep Sharma

[Himanshu Gupta]

Is this the only error you get? Try running this query in DB directly..

[Pradeeep Sharma]

yes!
But when i run the same query in simple java file it runs fine, and in jsp code it's creating problem. I mean i not getting any record.

[Himanshu Gupta]

   String SQL_QUERY ="Select CONTACT.firstName,CONTACT.lastName,CONTACT.email from Register CONTACT";  
            query = hsession.createQuery(SQL_QUERY);   

I want to see the full code of the above class

[Pradeeep Sharma]

  public class ContactList {
	Session hsession = null;
	public ArrayList getContactList(){

		Query query=null;
		ArrayList arrContactList=new ArrayList();
		try{
			// This step will read hibernate.cfg.xml 
			SessionFactory sessionFactory = new 

			Configuration().configure().buildSessionFactory();
			hsession =sessionFactory.openSession();
			hsession =sessionFactory.openSession();

			String SQL_QUERY ="Select CONTACT.firstName,CONTACT.lastName,CONTACT.email from Register CONTACT";
			query = hsession.createQuery(SQL_QUERY);
			Register form=new Register();
			for(Iterator it=query.iterate();it.hasNext();){
				Register contacts=new Register();
				Object[] row = (Object[]) it.next();
				contacts.setFirstName((String)row[0]);
				contacts.setLastName((String)row[1]);
				contacts.setEmail((String)row[2]);
				arrContactList.add(contacts);
			}
			form.setArrContactList(arrContactList);
			hsession.close();
		}catch(Exception e){
			System.out.println(e.getMessage());
		}finally{
			
			return arrContactList;
		}
	}
}  

[Lucene china]

hello,can you sure that session Object is created?in jsp code.

[David Newton]

Why are you using Hibernate if you're just going to query with SQL and transfer the results manually to the objects? Avoiding that is the whole point of Hibernate.

I also don't see any error message, did you forget to post it?