All queries failing with in: expected

adcworks · **Joined:** Fri Jun 18, 2004 10:17 am **Posts:** 140

I am trying to get all Schedule rows into a List using the following call

Code:

      try {
         Session session = HibernateUtil.currentSession();
         Transaction tx = session.beginTransaction();

         Iterator iter = session.iterate("from Schedules s"); 

         tx.commit();
         
      } catch (HibernateException hE) {
         logger.error(hE.getMessage());
      }

but all I ever get in my logs is

Code:

in expected: s [from Schedules s]

I've tried a variety of HQL statements from the Hibernate documents but all of them generate this error.

Thanks!

adcworks · **Joined:** Fri Jun 18, 2004 10:17 am **Posts:** 140

I got some more logging info if this helps?

Code:

19:13,847 DEBUG SessionImpl:555 - opened session
19:13,847 DEBUG JDBCTransaction:37 - begin
19:13,863 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
19:13,863 DEBUG DriverManagerConnectionProvider:90 - using pooled JDBC connection, pool size: 0
19:13,863 DEBUG JDBCTransaction:41 - current autocommit status:false
19:13,894 DEBUG SessionImpl:1526 - find: from Schedules schedule
19:13,910 DEBUG QueryParameters:109 - named parameters: {}
19:13,957 DEBUG QueryTranslator:147 - compiling query
19:14,003 ERROR Application:? - in expected: schedule [from Schedules schedule]
19:14,785  INFO DriverManagerConnectionProvider:143 - cleaning up connection pool: jdbc:jtds:sqlserver://intratestgbr:1433/dbSchedules;charset=Cp1252;TDS=7.0

emmanuel · **Posted:** Tue Jun 29, 2004 8:31 am

Your mapping files are probably not loaded.
Try the fully qualified class name too.

adcworks · **Joined:** Fri Jun 18, 2004 10:17 am **Posts:** 140

from Schedules schedule

should be

from Schedule schedule

:) Thanks!