select in hibernate

[Atul Darne]

Hi,

I have acheived adding contents to a database table by using hibernate xml hbm file, now i wish to search any user in it - i am stucked with with an error in the code

		Session session = HibernateUtil.getSessionFactory().openSession();
			session.beginTransaction();
		 
			//Using from Clause
			String SQL_QUERY ="from patientdetails.id,patientdetails.firstname";
			Query query = session.createQuery(SQL_QUERY);
			for(Iterator it=query.iterate();it.hasNext();)
			{
				Patient p =(Patient) it.next();
				System.out.println("ID: " +p.getFirstname());
			}
			 
			session.close();

iam having the following function

	public List<Patient> getAllPatients() 
	{
	    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
	    session.beginTransaction();
	    List<Patient> result = (List<Patient>) session.createQuery("from firstname").list();
	    session.getTransaction().commit();
	    return result;
	}

cfg file

<?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="hibernate.bytecode.use_reflection_optimizer">false</property>
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/clinic</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="hibernate.connection.password">password</property>
		<property name="show_sql">true</property>
		<property name="hibernate.hbm2ddl.auto">update</property>
		<mapping resource="patient.hbm.xml" />
	</session-factory>
</hibernate-configuration>

patient.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
	<class name="com.myclinic.dao.Patient" table="patientdetails">
		<id name="patientID" type="java.lang.Long">
			<column name="id" />
			<generator class="increment" />
		</id>
		<property name="firstname" type="string">
			<column name="firstname" length="255" />
		</property>
		<property name="middlename" type="string">
			<column name="middlename" length="255" />
		</property>
		<property name="lastname" type="string">
			<column name="lastname" length="255" />
		</property>
		
		
		<property name="age" type="int">
			<column name="age" />
		</property>
		
		<property name="gender" type="int">
			<column name="gender" />
		</property>
		
		
		<property name="add1" type="string">
			<column name="add1" />
		</property>
		<property name="add2" type="string">
			<column name="add2" />
		</property>
		<property name="city" type="string">
			<column name="city" />
		</property>
		<property name="state" type="string">
			<column name="state" />
		</property>
		<property name="zip" type="string">
			<column name="zip" />
		</property>
		<property name="country" type="string">
			<column name="country" />
		</property>
		
		<property name="mobileno" type="string">
			<column name="mobileno" />
		</property>
		<property name="phone" type="string">
			<column name="phone" />
		</property>
		<property name="email" type="string">
			<column name="email" />
		</property>
		
		<property name="prescribtion" type="string">
			<column name="prescribtion" />
		</property>
		
		<property name="visitdate" type="java.util.Date">
			<column name="patientvisitdate" />
		</property>
	</class>
</hibernate-mapping>

i get the below error

when i do a select query on the table

INFO: HHH000232: Schema update complete
org.hibernate.hql.internal.ast.QuerySyntaxException: patientdetails.id is not mapped [from patientdetails.id,patientdeta
ils.firstname]
	at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180)
	at org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
	at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:93)

[Vijitha Kumara]

And what your Patient class has?

[Atul Darne]

Hi Vijitha ,

I am adding the class

package com.myclinic.dao;

import java.util.Date;

public class Patient 
{
	private Long patientID;
	
	private String firstname;
	private String middlename;
	private String lastname;
	private int age;
	private int gender;
	private String add1;
	private String add2;
	private String city;
	private String state;
	private String zip;
	private String country;
	private String mobileno;
	private String phone;
	private String email;
	private String prescribtion;
	private Date visitdate;
	
	
	public Long getPatientID() {
		return patientID;
	}
	public void setPatientID(Long patientID) {
		this.patientID = patientID;
	}
	public String getFirstname() {
		return firstname;
	}
	public void setFirstname(String firstname) {
		this.firstname = firstname;
	}
	public String getMiddlename() {
		return middlename;
	}
	public void setMiddlename(String middlename) {
		this.middlename = middlename;
	}
	public String getLastname() {
		return lastname;
	}
	public void setLastname(String lastname) {
		this.lastname = lastname;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public int getGender() {
		return gender;
	}
	public void setGender(int gender) {
		this.gender = gender;
	}
	public String getAdd1() {
		return add1;
	}
	public void setAdd1(String add1) {
		this.add1 = add1;
	}
	public String getAdd2() {
		return add2;
	}
	public void setAdd2(String add2) {
		this.add2 = add2;
	}
	public String getCity() {
		return city;
	}
	public void setCity(String city) {
		this.city = city;
	}
	public String getState() {
		return state;
	}
	public void setState(String state) {
		this.state = state;
	}
	public String getZip() {
		return zip;
	}
	public void setZip(String zip) {
		this.zip = zip;
	}
	public String getCountry() {
		return country;
	}
	public void setCountry(String country) {
		this.country = country;
	}
	public String getMobileno() {
		return mobileno;
	}
	public void setMobileno(String mobileno) {
		this.mobileno = mobileno;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getPrescribtion() {
		return prescribtion;
	}
	public void setPrescribtion(String prescribtion) {
		this.prescribtion = prescribtion;
	}
	public Date getVisitdate() {
		return visitdate;
	}
	public void setVisitdate(Date visitdate) {
		this.visitdate = visitdate;
	}
}

[Kunal Lakhani]

String SQL_QUERY ="from patientdetails.id,patientdetails.firstname";

I think it should be

String SQL_QUERY ="from Patient.patientID,Patient.firstname";

When you write HQL, you concentrate on Objects and its properties without concerning about the database

[Atul Darne]

Hi kunal,

thanks it worked - i made the following changes

String SQL_QUERY ="from Patient";
Query query = session.createQuery(SQL_QUERY);
for(Iterator it=query.iterate();it.hasNext();)
{
	Patient p =(Patient) it.next();
	System.out.println("ID: " +p.getFirstname());
}
			 
session.close();