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

leo008

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: 4200015:28:10,160 WARN org.hibernate.util.JDBCExceptionReporter:71 - SQL Error: 1064, SQLState: 42000JDBCExceptionReporter-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 115: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


请高人帮忙指导一下！

nan_jia

是不是你的方言没有修改成MYSQL的.或者你把 SHOWSQL打开看看最后的语名是什么。。