Hibernate

[poonam dahiya]

hi i m facing a problem i m new to hibernate.
i created the cfg file,hbm file,i am asked to select all the rows from column but i m getting this Error:
No data type for node: org.hibernate.hql.ast.IdentNode +-[ALIAS_REF] IdentNode: 'FIRSTNAME' {alias=FIRSTNAME, no from element}
javascript: x()
Confused

please help me out.i am pasting my cfg file hbm file..too....
thanks in advance...
plzzzzzzzzzzzz help me........

 
package hibernate.roseindia.tutorial.hibernate;
 
import org.hibernate.*;
import org.hibernate.cfg.*;
import java.util.*;
 
/**
 * @author Poonam Dahiya
 * Oracle Select Clause Example
 */
public class SelectClauseExample 
{
public static void main(String[] args) 
{
Session session = null;
 
try
{
// This step will read hibernate.cfg.xml and prepare hibernate for use
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session =sessionFactory.openSession();
 
//Create Select Clause Oracle


//String Oracle_QUERY = "SELECT ID as (c.id), firstName as (c.name),lastName as (c.lastName), email as (c.emailId) FROM c Contact ";

String Oracle_QUERY ="Select FIRSTNAME,LASTNAME,EMAILID,ID from Contact";
Query query = session.createQuery(Oracle_QUERY);
for(Iterator it = query.iterate();it.hasNext()  :wink:  
{
Object[] row = (Object[]) it.next();
System.out.println("firstName: " + row[0]);
System.out.println("lastName: " + row[1]);
System.out.println("emailId: " + row[2]);
System.out.println("id: " + row[3]);
}
 
session.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
finally
{
}
}
}

contact.hbm.xml

 
 
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
 
class name="hibernate.roseindia.tutorial.hibernate.Contact" table="CONTACT" mutable="true" polymorphism="implicit" dynamic-update="false" dynamic-insert="false" select-before-update="false" optimistic-lock="version">
 
<id name="id" type="long" column="ID">
  <generator class="native" /> 
  </id>
 
<property name="firstName" type="string" >
  <column name="FirstName" /> 
  </property>
 
<property name="lastName" type="string" >
  <column name="LASTNAME" /> 
  </property>
 
<property name="email" type="string" >
  <column name="EMAILID" /> 
  </property>
  </class>
   
</hibernate-mapping>

hibernate.cfg.xml

<?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 name="session">
 
    <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
 
    <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
 
    <property name="hibernate.connection.url">jdbc  :-o	  racle:thin:@172.16.31.25:1521:BOMBAY</property>
 
    <property name="hibernate.connection.username">mumbai</property>
 
    <property name="hibernate.connection.password">mumbai123</property>
 
    <!-- Set AutoCommit to true -->
 
    <property name="connection.autocommit">true</property>    
 
    <!-- Mapping files -->
 
    <mapping resource="contact.hbm.xml"/>
 
  </session-factory>
 
</hibernate-configuration>

Contact.java file

 
package hibernate.roseindia.tutorial.hibernate;
 
/**
 * @author Deepak Kumar
 *
 * <a href="http://www.roseindia.net" target="_blank" rel="nofollow">http://www.roseindia.net</a>
 * Java Class to map to the datbase Contact Table
 */
public class Contact 
{
private String firstName;
private String lastName;
private String email;
private long id;
 
/**
 * @return Email
 */
public String getEmail() 
{
return email;
}
 
/**
 * @return First Name
 */
public String getFirstName() 
{
return firstName;
}
 
/** 
 * @return Last name
 */
public String getLastName() 
{
return lastName;
}
 
/**
 * @param string Sets the Email
 */
public void setEmail(String string)
{
email = string;
}
 
/**
 * @param string Sets the First Name
 */
public void setFirstName(String string) {
firstName = string;
}
 
/**
 * @param string sets the Last Name
 */
public void setLastName(String string)
{
lastName = string;
}
 
/**
 * @return ID Returns ID
 */
public long getId()
{
return id;
}
 
/**
 * @param l Sets the ID
 */
public void setId(long l)
{
id = l;
}
 
}

[ Edited to use code tags - Paul Sturrock ]
[ June 16, 2008: Message edited by: Paul Sturrock ]

[Paul Sturrock]

String Oracle_QUERY ="Select FIRSTNAME,LASTNAME,EMAILID,ID from Contact";

Contact does not have properties called FIRSTNAME,LASTNAME,EMAILID, or ID. Remember that with HQL you are querying the class not the database table directly.

[Bhaskar GR]

Session session=sf.openSession();
Transaction tx=session.beginTransaction();
RegularLogger.logInfo(RegularDAOImpl.class,"Query of the level_table");
Query q1=session.createQuery("from Contact as l");
List l=q1.list();
Iterator i=l.iterator();
while(i.hasNext())
{-----------
}

[ksrk mahidhar]

i am also facing similar problem can any one help me how to workout this issue.

[ksrk mahidhar]

thanks i got solution

just use below code

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session =sessionFactory.openSession();

//Using from Clause
String SQL_QUERY ="from Contact";
Query query = session.createQuery(SQL_QUERY);
for(Iterator it=query.iterate();it.hasNext();){
Contact contact=(Contact)it.next();
System.out.println("ID IS : " + contact.getId());
System.out.println("FirstName IS : " + contact.getFirstName());
System.out.println("LastName IS : " + contact.getLastName());
System.out.println("Email IS: " + contact.getEmail());
}
session.close();



you will get out put