hibernate问题,hibernate高手或自认为是高手的都入,^_^ 100分!谢谢
kaymo 2005-01-17 10:37:48 写hql以id(PK)查出相应数据库记录(用的是MySQL)
query后,对结果iterator的时候抛出异常
com.us.util.DataAccessException: net.sf.hibernate.JDBCException: Could not execute query
at com.us.dao.common.DAOImplBase.findByStringPK(DAOImplBase.java:134)
at com.us.dao.LoginDAO.findByPrimaryKey(LoginDAO.java:11)
at com.us.logic.hibernatetest.main(hibernatetest.java:23)
Caused by: net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1580)
at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
at com.us.dao.common.DAOImplBase.findByStringPK(DAOImplBase.java:128)
... 2 more
Caused by: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:795)
at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:848)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1577)
... 4 more
Exception in thread "main"