Hibernate version:
Hibernate3

Name and version of the database you are using:
Im using mysql-4.1.12-win32
The generated SQL (show_sql=true):
as shown below

I have a working application in using spring 1.2.5, hibernate2 and jdk1.4.2, mysql-connector-java-3.1.6.

I have now upgraded to jdk1.5 and hibernate3, mysql-connector-3.1-12. Everything works nice except a native sql question where I use the mysql keyword AGAINST.

Is there any way I can get around this and ad the keyword AGAINST to th e hibernate.hql.PARSER that complains or can see which tokens are "leagal". ???

Any suggestion is very appreciated since I have a total standstill....
Could it be a bug?

Full stack trace of any exception that occurs:
2006-01-31 20:34:18,368 ERROR [org.hibernate.hql.PARSER] - <*** ERROR: line 1:16
1: unexpected token: AGAINST>
2006-01-31 20:34:18,368 ERROR [org.hibernate.hql.PARSER] - <*** ERROR: line 1:19
7: unexpected token: MODE>
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: AG
AINST near line 1, column 161 [SELECT new Ad (ad.id, ad.date, ad.showImage, ad.h
eadline, ad.region, ad.category, ad.price) FROM com.buysell.server.model.Ad ad W
HERE MATCH (maintext,headline) AGAINST ('(test again )' IN BOOLEAN MODE) AND ad.
status = '1' AND ad.buysell = '2' order by ad.date desc]; nested exception is or
g.hibernate.hql.ast.QuerySyntaxError: unexpected token: AGAINST near line 1, col
umn 161 [SELECT new Ad (ad.id, ad.date, ad.showImage, ad.headline, ad.region, ad
.category, ad.price) FROM com.buysell.server.model.Ad ad WHERE MATCH (maintext,h
eadline) AGAINST ('(test again )' IN BOOLEAN MODE) AND ad.status = '1' AND ad.bu
ysell = '2' order by ad.date desc]
org.hibernate.hql.ast.QuerySyntaxError: unexpected token: AGAINST near line 1, c
olumn 161 [SELECT new Ad (ad.id, ad.date, ad.showImage, ad.headline, ad.region,
ad.category, ad.price) FROM com.buysell.server.model.Ad ad WHERE MATCH (maintext
,headline) AGAINST ('(test again )' IN BOOLEAN MODE) AND ad.status = '1' AND ad.
buysell = '2' order by ad.date desc]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.j
ava:63)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.j
ava:215)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorIm
pl.java:127)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl
.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.jav
a:427)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:884)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:834)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate
(HibernateTemplate.java:809)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:358)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:800)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:792)
at com.buysell.server.dao.hibernate.AdDaoHibernate.executeSql(Unknown So
urce)
at com.buysell.client.service.AdServiceImpl.executeSql(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:292)

Have you tried using session.createSQLQuery()? It is not clear from the stack trace. I think this changed from hibernate2 to hibernate3.

no, I extend HibernateDaoSupport and use getHibernateTemplate.find("pure sql question");

This works perfectly with hibernate2.....

that was a bug in hibernate 2 that it worked.

find should only be used with valid HQL.

I get hibernate3.HibernateQueryException: unexpected token when excuting the following query: from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?

However, if I change "having" for "where" the query run fine.

Any will be apreciated. Thanks.

This is my trace:

[java] Initializing application
[java] Nov 2, 2006 9:42:49 AM org.springframework.core.CollectionFactory <clinit>
[java] INFO: JDK 1.4+ collections available
[java] Nov 2, 2006 9:42:49 AM org.springframework.core.CollectionFactory <clinit>
[java] INFO: Commons Collections 3.x available
[java] Nov 2, 2006 9:42:49 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
[java] INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
[java] Nov 2, 2006 9:42:49 AM org.springframework.context.support.AbstractRefreshableApplicationContext refreshBeanFactory
[java] INFO: Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=16291471]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,transactionManager,sessionFactory,testDao,customerDao]; root of BeanFactory hierarchy
[java] Nov 2, 2006 9:42:49 AM org.springframework.context.support.AbstractApplicationContext refresh
[java] INFO: 5 beans defined in application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=16291471]
[java] Nov 2, 2006 9:42:49 AM org.springframework.context.support.AbstractApplicationContext initMessageSource
[java] INFO: Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@79e304]
[java] Nov 2, 2006 9:42:49 AM org.springframework.context.support.AbstractApplicationContext initApplicationEventMulticaster
[java] INFO: Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@15ad5c6]
[java] Nov 2, 2006 9:42:49 AM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
[java] INFO: Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,transactionManager,sessionFactory,testDao,customerDao]; root of BeanFactory hierarchy]
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.Environment <clinit>
[java] INFO: Hibernate 3.1.3
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.Environment <clinit>
[java] INFO: hibernate.properties not found
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.Environment <clinit>
[java] INFO: using CGLIB reflection optimizer
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.Environment <clinit>
[java] INFO: using JDK 1.4 java.sql.Timestamp handling
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
[java] INFO: Mapping class: com.apress.prospring.ch9.domain.Test -> Test
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
[java] INFO: Mapping class: com.apress.prospring.ch9.domain.Customer -> Customers
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.HbmBinder bindCollection
[java] INFO: Mapping collection: com.apress.prospring.ch9.domain.Customer.permissions -> CustomerPermissions
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
[java] INFO: Mapping class: com.apress.prospring.ch9.domain.CustomerAddress -> CustomerAddresses
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
[java] INFO: Mapping class: com.apress.prospring.ch9.domain.Permission -> Permissions
[java] Nov 2, 2006 9:42:50 AM org.springframework.orm.hibernate3.LocalSessionFactoryBean afterPropertiesSet
[java] INFO: Building new Hibernate SessionFactory
[java] Nov 2, 2006 9:42:50 AM org.hibernate.cfg.HbmBinder bindCollectionSecondPass
[java] INFO: Mapping collection: com.apress.prospring.ch9.domain.Customer.addresses -> CustomerAddresses
[java] Nov 2, 2006 9:42:50 AM org.hibernate.connection.ConnectionProviderFactory newConnectionProvider
[java] INFO: Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: RDBMS: MySQL, version: 5.0.26-standard
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.3 ( $Date: 2006-07-26 17:26:47 +0200 (Wed, 26 Jul 2006) $, $Revision: 5553 $ )
[java] Nov 2, 2006 9:42:51 AM org.hibernate.dialect.Dialect <init>
[java] INFO: Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
[java] Nov 2, 2006 9:42:51 AM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
[java] INFO: Using default transaction strategy (direct JDBC transactions)
[java] Nov 2, 2006 9:42:51 AM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
[java] INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Automatic flush during beforeCompletion(): disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Automatic session close at end of transaction: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: JDBC batch size: 15
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: JDBC batch updates for versioned data: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Scrollable result sets: enabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: JDBC3 getGeneratedKeys(): enabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Connection release mode: on_close
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Maximum outer join fetch depth: 3
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Default batch fetch size: 1
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Generate SQL with comments: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Order SQL updates by primary key: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
[java] INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[java] Nov 2, 2006 9:42:51 AM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
[java] INFO: Using ASTQueryTranslatorFactory
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Query language substitutions: {true='T', false='F'}
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Second-level cache: enabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Query cache: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory createCacheProvider
[java] INFO: Cache provider: org.hibernate.cache.EhCacheProvider
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Optimize cache for minimal puts: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Structured second-level cache entries: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Echoing all SQL to stdout
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Statistics: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Deleted entity synthetic identifier rollback: disabled
[java] Nov 2, 2006 9:42:51 AM org.hibernate.cfg.SettingsFactory buildSettings
[java] INFO: Default entity-mode: pojo
[java] Nov 2, 2006 9:42:51 AM org.hibernate.impl.SessionFactoryImpl <init>
[java] INFO: building session factory
[java] Nov 2, 2006 9:42:51 AM net.sf.ehcache.config.Configurator configure
[java] WARNING: No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/gustavo/springTests/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
[java] Nov 2, 2006 9:42:52 AM org.hibernate.impl.SessionFactoryObjectFactory addInstance
[java] INFO: Not binding factory to JNDI, no JNDI name configured
[java] Nov 2, 2006 9:42:52 AM org.springframework.orm.hibernate3.HibernateTransactionManager afterPropertiesSet
[java] INFO: Using DataSource [org.apache.commons.dbcp.BasicDataSource@1cebc9f] of Hibernate SessionFactory for HibernateTransactionManager
[java] Nov 2, 2006 9:42:52 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
[java] INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[java] Nov 2, 2006 9:42:52 AM org.springframework.jdbc.support.SQLErrorCodesFactory <init>
[java] INFO: SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
[java] Hibernate: select customer0_.CustomerId as CustomerId1_, customer0_.FirstName as FirstName1_, customer0_.LastName as LastName1_ from Customers customer0_
[java] Hibernate: select addresses0_.Customer as Customer1_, addresses0_.CustomerAddressId as Customer1_1_, addresses0_.CustomerAddressId as Customer1_3_0_, addresses0_.Customer as Customer3_0_, addresses0_.Line1 as Line3_3_0_, addresses0_.Line2 as Line4_3_0_, addresses0_.City as City3_0_, addresses0_.PostCode as PostCode3_0_ from CustomerAddresses addresses0_ where addresses0_.Customer=?
[java] Hibernate: select permission0_.Customer as Customer1_, permission0_.Permission as Permission1_, permission1_.PermissionId as Permissi1_4_0_, permission1_.Name as Name4_0_ from CustomerPermissions permission0_ left outer join Permissions permission1_ on permission0_.Permission=permission1_.PermissionId where permission0_.Customer=?
[java] Customer { customerId=1, firstName=Jan, lastName=Machacek, addresses=[CustomerAddress { customerAddressId=2, line1=Line 1, line2=Line 2, city=Hradec Kralove, postCode=500 04 }, CustomerAddress { customerAddressId=1, line1=Line 1, line2=Line 2, city=Manchester, postCode=M1 4HH }], permissions=[Permission { permissionId=3, name=Delete Customer }, Permission { permissionId=1, name=View Customer }, Permission { permissionId=2, name=Edit Customer }] }
[java] Hibernate: select addresses0_.Customer as Customer1_, addresses0_.CustomerAddressId as Customer1_1_, addresses0_.CustomerAddressId as Customer1_3_0_, addresses0_.Customer as Customer3_0_, addresses0_.Line1 as Line3_3_0_, addresses0_.Line2 as Line4_3_0_, addresses0_.City as City3_0_, addresses0_.PostCode as PostCode3_0_ from CustomerAddresses addresses0_ where addresses0_.Customer=?
[java] Hibernate: select permission0_.Customer as Customer1_, permission0_.Permission as Permission1_, permission1_.PermissionId as Permissi1_4_0_, permission1_.Name as Name4_0_ from CustomerPermissions permission0_ left outer join Permissions permission1_ on permission0_.Permission=permission1_.PermissionId where permission0_.Customer=?
[java] Customer { customerId=2, firstName=Rob, lastName=Harrop, addresses=[CustomerAddress { customerAddressId=3, line1=Line 1, line2=Line 2, city=Denton, postCode=SK1 2AB }], permissions=[Permission { permissionId=1, name=View Customer }] }
[java] Nov 2, 2006 9:42:53 AM org.hibernate.hql.ast.ErrorCounter reportError
[java] SEVERE: line 1:52: unexpected token: having
[java] org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: having near line 1, column 52 [from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: having near line 1, column 52 [from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?]
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:180)
[java] at org.apache.tools.ant.taskdefs.Java.run(Java.java:710)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:178)
[java] at org.apache.tools.ant.taskdefs.Java.execute(Java.java:84)
[java] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[java] at org.apache.tools.ant.Task.perform(Task.java:364)
[java] at org.apache.tools.ant.Target.execute(Target.java:341)
[java] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[java] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[java] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[java] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[java] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[java] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[java] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[java] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[java] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
[java] Caused by: org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: having near line 1, column 52 [from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: having near line 1, column 52 [from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?]
[java] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:652)
[java] at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:413)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
[java] at com.apress.prospring.ch9.data.HibernateCustomerDao.getAllWithOnlyOnePermission(HibernateCustomerDao.java:41)
[java] at com.apress.prospring.ch9.Main.customer(Main.java:74)
[java] at com.apress.prospring.ch9.Main.run(Main.java:110)
[java] at com.apress.prospring.ch9.Main.main(Main.java:116)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:585)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:202)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:134)
[java] ... 15 more
[java] Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: having near line 1, column 52 [from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?]
[java] at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:244)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:155)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109)
[java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
[java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
[java] at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
[java] at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
[java] at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
[java] at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)
[java] at org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:846)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
[java] ... 26 more
[java] Caused by: line 1:52: unexpected token: having
[java] at org.hibernate.hql.antlr.HqlBaseParser.fromClassOrOuterQueryPath(HqlBaseParser.java:1938)
[java] at org.hibernate.hql.antlr.HqlBaseParser.fromRange(HqlBaseParser.java:1564)
[java] at org.hibernate.hql.antlr.HqlBaseParser.fromClause(HqlBaseParser.java:1408)
[java] at org.hibernate.hql.antlr.HqlBaseParser.selectFrom(HqlBaseParser.java:1130)
[java] at org.hibernate.hql.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:702)
[java] at org.hibernate.hql.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:296)
[java] at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:159)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:238)
[java] ... 36 more
[java] --- Nested Exception ---
[java] org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: having near line 1, column 52 [from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: having near line 1, column 52 [from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?]
[java] org.hibernate.hql.ast.QuerySyntaxException: unexpected token: having near line 1, column 52 [from com.apress.prospring.ch9.domain.Customer as c having c.permissions.size = ?]
[java] at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:244)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:155)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109)
[java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
[java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
[java] at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
[java] at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
[java] at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
[java] at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)
[java] at org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:846)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
[java] at com.apress.prospring.ch9.data.HibernateCustomerDao.getAllWithOnlyOnePermission(HibernateCustomerDao.java:41)
[java] at com.apress.prospring.ch9.Main.customer(Main.java:74)
[java] at com.apress.prospring.ch9.Main.run(Main.java:110)
[java] at com.apress.prospring.ch9.Main.main(Main.java:116)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:585)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:202)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:134)
[java] at org.apache.tools.ant.taskdefs.Java.run(Java.java:710)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:178)
[java] at org.apache.tools.ant.taskdefs.Java.execute(Java.java:84)
[java] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[java] at org.apache.tools.ant.Task.perform(Task.java:364)
[java] at org.apache.tools.ant.Target.execute(Target.java:341)
[java] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[java] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[java] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[java] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[java] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[java] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[java] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[java] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[java] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
[java] Caused by: line 1:52: unexpected token: having
[java] at org.hibernate.hql.antlr.HqlBaseParser.fromClassOrOuterQueryPath(HqlBaseParser.java:1938)
[java] at org.hibernate.hql.antlr.HqlBaseParser.fromRange(HqlBaseParser.java:1564)
[java] at org.hibernate.hql.antlr.HqlBaseParser.fromClause(HqlBaseParser.java:1408)
[java] at org.hibernate.hql.antlr.HqlBaseParser.selectFrom(HqlBaseParser.java:1130)
[java] at org.hibernate.hql.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:702)
[java] at org.hibernate.hql.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:296)
[java] at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:159)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:238)
[java] ... 36 more