数据库连接池配置 Oracle，SQL Server，DB2，MYSQL，SQLLITE3

数据库技术文章/教程1年前 (2023)发布勤奋小助

0 0

################## 数据库连接配置 ##################

#Oracle
#hibernate.connection.driverClass=oracle.jdbc.driver.OracleDriver
#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
#hibernate.connection.url=jdbc:oracle:thin:@192.168.1.30:1521:other
#hibernate.connection.userName=ekp
#hibernate.connection.password=ekp

#SQL Server
#hibernate.connection.driverClass=net.sourceforge.jtds.jdbc.Driver
#hibernate.dialect=org.hibernate.dialect.SQLServerDialect
#hibernate.connection.url=jdbc:jtds:sqlserver://192.168.5.183:1433/ekp
#hibernate.connection.url=jdbc:jtds:sqlserver://localhost:1433/kms_ekp3
#hibernate.connection.userName=sa
#hibernate.connection.password=admin123

#hibernate.connection.driverClass=org.h2.Driver
#hibernate.dialect=org.hibernate.dialect.H2Dialect
#hibernate.connection.url=jdbc:h2:tcp://localhost/D:/java/h2db/ekp
#hibernate.connection.userName=
#hibernate.connection.password=

#DB2
#hibernate.connection.driverClass=com.ibm.db2.jcc.DB2Driver
#hibernate.dialect=org.hibernate.dialect.DB2Dialect
#hibernate.connection.url=jdbc:db2://192.168.0.253:50000/ekp:driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;
#hibernate.connection.userName=ekp
#hibernate.connection.password=ekp

#MYSQL
hibernate.connection.driverClass=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.connection.url=jdbc:mysql://localhost:3306/kms?useUnicode=true&characterEncoding=UTF-8
hibernate.connection.userName=root
hibernate.connection.password=sa

#SQLLITE3
#hibernate.connection.driverClass=org.sqlite.JDBC
#hibernate.dialect=dialect.SQLiteDialect
#hibernate.connection.url=jdbc:sqlite:D:/Moon/sqlite3/ekp.db
#hibernate.connection.userName=
#hibernate.connection.password=

#hibernate.connection.driverClass=com.mysql.jdbc.Driver
#hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
#hibernate.connection.url=jdbc:mysql://192.168.1.118:3306/ekp80?useUnicode=true&characterEncoding=UTF-8
#hibernate.connection.userName=root
#hibernate.connection.password=1

原文链接：https://www.cnblogs.com/rick168/p/4759060.html
本文来源互联网收集，文章内容系作者个人观点，不代表本站对观点赞同或支持。如需转载，请注明文章来源,如您发现有涉嫌抄袭侵权的内容，请联系本站核实处理。