leo008 发表于 2012-12-06 16:42

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

Query query = baseDao.getSession().createQuery("from EmployeeMain where employeeId=:userId");
query.setString("userId", userId);
returnquery.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 发表于 2012-12-07 11:27

本帖最后由 nan_jia 于 2012-12-07 11:28 编辑

是不是你的方言没有修改成MYSQL的.或者你把 SHOWSQL打开看看最后的语名是什么。。
页: [1]
查看完整版本: hql 查询 sql的句子变换成查询MYSQL