Hi
I am trying to retrieve data from the database and I have tried almost every kind of query but I am still getting the following error:
org.hibernate.QueryException: in expected: msg [from Message msg order by msg.text asc]
at org.hibernate.hql.classic.FromParser.token(FromParser.java:106)
at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:86)
at org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:108)
at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:29)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:172)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:148)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:410)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:987)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1018)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
at com.webmd.bna.hello.ReadMessage.main(ReadMessage.java:41)
My ReadMessage.java looks something like the following :
import java.util.Iterator;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
//import org.hibernate.Session;
import org.hibernate.classic.Session;
public class ReadMessage {
private static SessionFactory sessionFactory;
public static void main(String[] args) {
try {
Configuration cfg = new Configuration();
sessionFactory = cfg.buildSessionFactory();
Session session = sessionFactory.openSession();
try {
Transaction tx = session.beginTransaction();
//List messages = session.createQuery("from Message msg").list();
Query query = session.createQuery("from Message msg order by msg.text asc");
//System.out.println(messages.size() + " message(s) found");
//Query sqlQuery = session.("select {msg.*} from Message {msg}", "msg", Message.class);
Iterator itr = query.iterate();
while(itr.hasNext()) {
Message message = (Message)itr.next();
System.out.println(message.getText());
}
tx.commit();
session.close(); }
catch(HibernateException hEx) {
hEx.printStackTrace();
}
}
catch(Throwable ex) {
ex.printStackTrace(System.out);
}
}
}
I am using hibernate version 3.0.
I am using JDBC to connect to the database Version Oracle9i Enterprise Edition Release 9.2.0.1.0
Please let me know what am I doing wrong. I am using this inside the eclipse. I have the book as well as I have gone online to read and find whatever I can about HQL, but definitely I am still missing something becuase of which I am getting this exception. My mapping document looks something like this:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.webmd.bna.hello.Message" table="AC_MESSAGES">
<id name="id" column="MESSAGE_ID" type="long" unsaved-value="null">
<generator class="increment"/>
</id>
<property name="text" column="MESSAGE_TEXT" type = "string" length="100" not-null="true"/>
<many-to-one name="nextMessage" class="com.webmd.bna.hello.Message" cascade="all" column="NEXT_MESSAGE_ID"/>
</class>
</hibernate-mapping>
[/i]
Login
FAQ
Search
