Question

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select userinfo0_.id as id, userinfo0_.username as username2_, userinfo0_.pwd as pwd2_, userinfo0_.email as email2_, userinfo0_.address as address2_, userinfo0_.postcode as postcode2_, userinfo0_.level as level2_, userinfo0_.power as power2_ from userinfo userinfo0_ where userinfo0_.username=? and userinfo0_.pwd=?]; SQL state [HY000]; error code [1267]; Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='; nested exception is java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:97)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:258)
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.book.dao.UserinfoDAO.verify(UserinfoDAO.java:162)
org.book.struts.action.LoginAction.execute(LoginAction.java:56)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

Answer 1

哦哦