Hello,

I'm new to Hibernate, so I beg your pardon in the first place for asking questions that might seem simple or clear.

We're running Hibernate 3.4.0 in a standalone application, on a MySQL 5 database (driver: mysql-connector-java-5.1.6).
Whenever I use query.getSingleResult() or query.setMaxResults(1) and query.getResultList() Hibernate produces invalid SQL like
select
top ? loginsetti0_.setting_id as setting1_4_
from
login_setting loginsetti0_
inner join
setting loginsetti0_1_
on loginsetti0_.setting_id=loginsetti0_1_.setting_id
where
loginsetti0_1_.setting_spec_id=?
and loginsetti0_.login_user_id=?

The identifier "top" obviously is not known to MySQL, why does Hibernate generate this?

Kind Regards,
Abbzug

Did you set the right dialect in your conf?

Thanks mmerder,
That was the problem.
-Abbzug