hibernate的配置出现的错误问题汇总

怼烎@ 2022-04-14 03:48 253阅读 0赞

<!DOCTYPE hibernate-configuration PUBLIC
            "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
            "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
    
    <hibernate-configuration>
        <session-factory>
        	
        	<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/app?useUnicode=true&characterEncoding=utf8</property>
        	<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        	<property name="hibernate.connection.username">root</property>
        	<property name="hibernate.connection.password">root</property>
        	<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        
        	
        	<property name="hibernate.show_sql">true</property><property name="hibernate.hbm2ddl.auto">update</property>
        	
        	
        	<mapping resource="entity/User.hbm.xml"/> 
        	
        </session-factory>
    </hibernate-configuration>

## 1，url要加上utf-8,不加会出现 ##

### Unknown initial character set index '255' received from server. Initial client character  ###

解决：[https://blog.csdn.net/txwtech/article/details/80787886][https_blog.csdn.net_txwtech_article_details_80787886]

## 2，&不能直接写，应改为：&不然会报错（在xml配置文件中配置数据库utl时，要使用&的转义字符也就是&） ##

### **数据库连接报错****：对实体 "characterEncoding" 的引用必须以 ';' 分隔符结尾** ###

## 3.还要加上时区 ##

### jdbc:mysql://localhost:3306/houses?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC ###

### 4.新版本的驱动是 ###

### com.mysql.cj.jdbc.Driver ###

# serverTimezone=Asia/Shanghai（解决时差问题） #

[https_blog.csdn.net_txwtech_article_details_80787886]: https://blog.csdn.net/txwtech/article/details/80787886