Hibernate Community • View topic - Query Problem with MySql

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Query Problem with MySql

Page 1 of 1

[ 5 posts ]

Previous topic | Next topic

Author

Message

fgiannetti

Post subject: Query Problem with MySql

Posted: Tue Nov 01, 2005 11:07 am

Newbie

Joined: Mon Mar 28, 2005 7:40 am
Posts: 5

Hi

I want to do a simple query but i get an error:

The query is this:
getHibernateTemplate().find("from Users");

but i get this error:
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from' at line 1

Im using Mysql 5 whith Hibernate 2.1.3

Thankou!!!!!

Top

jamie_dainton

Post subject:

Posted: Tue Nov 01, 2005 11:12 am

Senior

Joined: Thu Aug 04, 2005 4:54 am
Posts: 153
Location: Birmingham, UK

Users is a reserved word. Quote it or change it.

Top

fgiannetti

Post subject:

Posted: Tue Nov 01, 2005 11:15 am

Newbie

Joined: Mon Mar 28, 2005 7:40 am
Posts: 5

Soryy.. i put "Users" for example.
The original table name is "Movies"

Thankyou!

Top

moox

Post subject:

Posted: Tue Nov 01, 2005 11:40 am

Newbie

Joined: Tue Nov 01, 2005 11:39 am
Posts: 4

I'm a newbie like you but I think you need the Class Name which is mapped with your Movies table.

Top

jamie_dainton

Post subject:

Posted: Tue Nov 01, 2005 11:44 am

Senior

Joined: Thu Aug 04, 2005 4:54 am
Posts: 153
Location: Birmingham, UK

Post the SQL that is output, without that we're forced to guess.

Top

Page 1 of 1

[ 5 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum