I have written a simple java class to fetch data using HQL. This is a standalone application and my database is not local. I have made the necessary entries in the hibernate.cfg.xml. However I am not sure of the entries and get the following error when I try to run the application -

[java] net.sf.hibernate.QueryException: in expected: b [select b from TransactionLog b where b.transSrcSystem = 'RFI']
[java] at net.sf.hibernate.hql.FromParser.token(FromParser.java:102)
[java] at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
[java] at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
[java] at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
[java] at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
[java] at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
[java] at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:295)
[java] at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1572)
[java] at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1602)
[java] at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:29)
[java] at com.echostar.requestforinfo.hibernate.createSession.main(Unknown Source)

I have searched various websites for this error and most of them suggest to check the mappings in the hibernate.cfg.xml file. Can anyone please go through the attached code and help? Any help will be highly appreciated.

package com.echostar.requestforinfo.hibernate;

import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.MappingException;
import net.sf.hibernate.HibernateException;

import net.sf.hibernate.JDBCException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;

import java.util.Iterator;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class createSession
{
private Log LOG = LogFactory.getLog( createSession.class.getName() );

public static void main ( String[] args )

{
try
{
System.out.println("App Started");
Configuration cfg = new Configuration();
SessionFactory sessions = cfg.buildSessionFactory();

System.out.println("AFter creating sessions");

Transaction tx = null;

Session session = sessions.openSession();

Query query = session.createQuery(
"select b from TransactionLog b where b.transSrcSystem = 'RFI'");

System.out.println("AFter creating query"+query.getQueryString());

Iterator result = query.iterate();
int count = 0;

while(result.hasNext())
{
count++;
}
System.out.println("Number of Objects: " + count);
session.close();
}
catch(Exception e)
{
e.printStackTrace();
}

}
}

Try


See http://www.hibernate.org/hib_docs/v3/re ... /#queryhql
especially
http://www.hibernate.org/hib_docs/v3/re ... yhql-where

I had a similar problem recently:

Mapping:


The mapping for Company is ommited here.

The Query



produced the message "in expected p"

The reason for this problem was the wrong class-name in the query: The class is Product not product! (The exception-message is quite confusing, it should be something like 'class product' not mapped).


So back to your problem:

try to add the package-attribut to your mapping and add a named query to the mapping file:



Change your code to:




Hope, that helps.

This exception could be due to wrong configuration or any of the following missing files.Check your Hibernate configuration:

1. hibernate.cfg.xml is in web-inf/classes folder.
2. hibernate.cfg.xml has an entry for the hbm file.
3. hbm file is in class path.
4. The dclass specified in hibernate.cfg.xml is available by the same name.