Question

hql 查询 sql的句子变换成查询MYSQL

Query query = baseDao.getSession().createQuery("from EmployeeMain where employeeId=:userId"); query.setString("userId", userId);
return query.list();
这段句子查询sql sever数据库没问题，但是查询MYSQL就报错
JDBCExceptionReporter-SQL Error: 1064, SQLState: 42000
15:28:10,160 WARN org.hibernate.util.JDBCExceptionReporter:71 - SQL Error: 1064, SQLState: 42000
JDBCExceptionReporter-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 '.employee_main employeema0_ where employeema0_.employee_id='01029'' at line 1
15:28:10,160 ERROR org.hibernate.util.JDBCExceptionReporter:72 - 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 '.employee_main employeema0_ where employeema0_.employee_id='01029'' at line 1

请高人帮忙指导一下！

Answer 1

如果userId的数据类型不是String型，这 query.setString("userId", userId); 语句有错误。

追问

达人，在帮忙看看有没有什么地方不对？

追答

没有。

追问

帮忙看下我的hibernate是不是配置对了？

追答

我在Lomboz中配置Hibernate用的dialect属性是
dialect：org.hibernate.dialect.MySQLDialect