Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

3.0.1

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!--
Auto-generated mapping file from
the hibernate.org cfg2hbm engine
-->
<class name="lyo.hotmail.domain.Author" table="author" catalog="test">
<id name="authorid" type="string">
<column name="AUTHORID" length="100" />
<generator class="assigned" />
</id>
<property name="name" type="string">
<column name="NAME" length="100" />
</property>
<property name="age" type="integer">
<column name="AGE" />
</property>
<property name="email" type="string">
<column name="EMAIL" length="150" />
</property>
<set name="articles" inverse="true">
<key>
<column name="AUTHOR_ID" length="100" />
</key>
<one-to-many class="lyo.hotmail.domain.Article" />
</set>
</class>
</hibernate-mapping>
:

NO

org.hibernate.exception.SQLGrammarException:could not execute query

MySQL 4.1:

NO

INFO:

Hi everyone:

I want to use hibernate3 Query editor to run HQL. But when I execute a hql, the query result console give me an exception:
Why?Ｍｙ HQL grammar is correct. Why it says SQLGrammarexception? Help!

Hi.
Try to delete attribute 'catalog="test"'.
Current released version contains a bug on MySQL. It should be already fixed in the CVS.

Vity