Glenn Davidson wrote:
> Mark,
> Thanks for the correct.
>
> I get two error messages when I try to execute the
> following command
>
> session.find("from Roles");
>
> SQL error:1064 SQL State: 24000
>
> Syntax or access violation, message from
> server:"You have an error in your SQL syntax;
> check the manual the that corresponds to your
> MySQL server version for the right syntax to use
> near 'from' at line 1"
We'd have to see the SQL that hibernate is generating to be able to help....That kind of error usually means you're using a reserved word in your query, or the table/column itself doesn't exist.
You should set hibernate.show_sql=true in your hibnerate.cfg, and tell us what queries hibernate is generating.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html