我正在使用休眠4.1.4,MySQL连接器是5.1.6。 Hibernate和tomcat server.xml连接器配置如下。当我尝试保存时,出现了异常。怎么了

Caused by: java.sql.SQLException: Incorrect string value: '\xC5\x9Fekk\xC3...'

<Connector port="8080" maxHttpHeaderSize="8192"
           maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
           enableLookups="false" redirectPort="8443" acceptCount="100"
           connectionTimeout="20000" disableUploadTimeout="true"
           URIEncoding="UTF-8" />


<hibernate-configuration> <session-factory> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost/*****?UseUnicode=true&amp;characterEncoding=utf8</property> <property name="hibernate.connection.CharSet">utf8</property> <property name="hibernate.connection.characterEncoding">utf8</property> <property name="hibernate.connection.useUnicode">true</property> <property name="hibernate.connection.username">****</property> <property name="hibernate.connection.password">***</property> <property name="hibernate.hbm2ddl.auto">update</property> </session-factory></hibernate-configuration>

最佳答案

十六进制C58F是utf8 / utf8mb4编码的ş

在Hibernate配置中,我认为它的拼写是破折号:UTF-8

另见https://docs.jboss.org/exojcr/1.12.13-GA/developer/en-US/html/ch-db-configuration-hibernate.html

关于mysql - Hibernate MySQL utf8配置,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/40192378/

10-14 11:31