Re: Hibernate problems with MYSql
Posted by: Mark Matthews
Date: March 03, 2005 12:04PM

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 Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools

Options: ReplyQuote

Written By
Re: Hibernate problems with MYSql
March 03, 2005 12:04PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.