I'm a real n00b to Hibernate and I am just messing around, but I have got myself stuck here and I know the answer is going to be really obvious.

Anyone got any ideas?

Cheers
Dan


Hibernate version:
3

Mapping documents:
<class name="com.howellsassociates.resourcebooking.usermanagement.objects.GroupObject" table="GROUPS">
<id name="groupID" type="string">
<column name="groupID"/>
</id>
<property name="groupName" column="groupName" type="string"/>
<property name="createdDate" column="createdDate" type="date"/>
<property name="modifiedDate" column="modifiedDate" type="date"/>

<set name="permissions" table="GROUP_PERMISSIONS" lazy="true">
<key column="groupID"/>
<many-to-many class="com.howellsassociates.resourcebooking.usermanagement.objects.PermissionObject" column="permissionID"/>
</set>

</class>

Full stack trace of any exception that occurs:
org.hibernate.hql.ast.QuerySyntaxError: unexpected token: group near line 1, column 8 [select group from com.howellsassociates.resourcebooking.usermanagement.objects.GroupObject as group]
org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:74)
org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:214)
org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414)
org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814)
org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:850)
org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
com.howellsassociates.resourcebooking.usermanagement.UserManagementLogic.getGroups(UserManagementLogic.java:51)
com.howellsassociates.resourcebooking.usermanagement.UserManagementServlet.doGet(UserManagementServlet.java:31)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


Name and version of the database you are using:
MySQL 4.1.11

HQL:

//get the groups
String selectQuery = "select group from com.howellsassociates.resourcebooking.usermanagement.objects.GroupObject as group";

Excuse my dense nature!

"group" is reserved!