第一章:Hibernate.5.4.10集成mysql

本文介绍了如何将Hibernate 5.4.10版本与MySQL数据库集成,包括Hibernate简介、所需Jar包、开发环境的搭建、配置C3P0连接池的详细步骤。通过创建Dynamic Web Project,引入必要的依赖,并配置hibernate.cfg.xml文件,实现与MySQL的连接。此外,还展示了Employee实体类和测试类的代码,以及C3P0连接池的配置选项。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

一、Hibernate简介

官网地址:https://hibernate.org/orm/

Jar下载版本:hibernate-release-5.4.10.Final.zip,本章源码中提供了下载好的jar,在章节末尾有源码下载地址。

 

二、Hibernate Jar包

包名 用途
antlr-2.7.7.jar Hibernate利用它实现从HQL到SQL的转换
byte-buddy-1.10.2.jar 基于动态类型的超类名称来随机生成类名
classmate-1.5.1.jar  
dom4j-2.1.1.jar 解析XML配置文件和XML映射文件
FastInfoset-1.2.15.jar  
hibernate-commons-annotations-5.1.0.Final.jar Hibernate注解包
hibernate-core-5.4.10.Final.jar Hibernate核心包
istack-commons-runtime-3.0.7.jar  
jandex-2.1.1.Final.jar 用来索引Anotation的
javassist-3.24.0-GA.jar Hibernate用它来实现PO字节码的动态生成
javax.activation-api-1.2.0.jar  
javax.persistence-api-2.2.jar 持久化api
jaxb-api-2.3.1.jar  
jaxb-runtime-2.3.1.jar  
jboss-logging-3.3.2.Final.jar 日志服务通用库
jboss-transaction-api_1.2_spec-1.1.1.Final.jar JTA规范包
stax-ex-1.8.jar  
txw2-2.3.1.jar  

 

三、Hibernate开发环境搭建

1)用eclipse新创建一个Dynamic Web Project,项目完整结构图如下:

 

2)把解压后\hibernate-release-5.4.10.Final\lib\required路径下的Jar都复制粘贴到项目中lib文件夹下

     从网上下载一个mysql和oracle Jar包也复制粘贴到l

Caused by: org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection for DDL execution at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:69) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.internal.exec.ImprovedExtractionContextImpl.getJdbcConnection(ImprovedExtractionContextImpl.java:60) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.internal.exec.ImprovedExtractionContextImpl.getJdbcDatabaseMetaData(ImprovedExtractionContextImpl.java:67) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getTables(InformationExtractorJdbcDatabaseMetaDataImpl.java:333) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.getTablesInformation(DatabaseInformationImpl.java:120) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:65) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:320) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1237) ~[hibernate-core-5.4.10.Final.jar:5.4.10.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) ~[spring-orm-5.2.3.RELEASE.jar:5.2.3.RELEASE] ... 87 common frames omitted Caused by: java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
最新发布
06-08
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值