資料庫連接池配置 - Oracle，SQL Server，DB2，MYSQL，SQLLITE3

標籤：

################## 資料庫連接配置 ##################

#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

資料庫連接池配置 - Oracle，SQL Server，DB2，MYSQL，SQLLITE3