数据库连接池的配置（mysql+sql2000+sql2008+sybaase）

来源：互联网发布：酱紫的网络语言意思编辑：程序博客网时间：2024/06/06 05:02

数据库连接池的配置
tomcat+mysql
# JDBC Configuration
jdbcDriverClassName=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://192.168.10.101:3306/test?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
jdbcUsername=root
jdbcPassword=123456
# DBCP Pool settings
jdbcInitialSize=5
jdbcMaxActive=10
jdbcMaxIdle=5
jdbcMaxWait=30000
jdbcValidationQuery=select 1

tomcat+sql2008
# JDBC Configuration
jdbcDriverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbcUrl=jdbc:sqlserver://192.168.10.101:1433
hibernate.dialect=org.hibernate.dialect.SQLServer2008Dialect
jdbcUsername=root
jdbcPassword=123456
# DBCP Pool settings
jdbcInitialSize=5
jdbcMaxActive=10
jdbcMaxIdle=5
jdbcMaxWait=30000
jdbcValidationQuery=select 1

tomcataql2000连接池配置
# JDBC Configuration
jdbcDriverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbcUrl=jdbc:microsoft:sqlserver://192.168.10.101:49539
hibernate.dialect=org.hibernate.dialect.SQLServer2000Dialect
jdbcUsername=root
jdbcPassword=123456
# DBCP Pool settings
jdbcInitialSize=5
jdbcMaxActive=10
jdbcMaxIdle=5
jdbcMaxWait=30000
jdbcValidationQuery=select 1

weblogic+sybase
# JDBC Configuration
jdbcDriverClassName=com.sybase.jdbc3.jdbc.SybDriver
jdbcUrl=jdbc:sybase:Tds:192.168.10.8:5000
hibernate.dialect=org.hibernate.dialect.SybaseDialect
jdbcUsername=sa
jdbcPassword=123456
# DBCP Pool settings
jdbcInitialSize=5
jdbcMaxActive=10
jdbcMaxIdle=5
jdbcMaxWait=30000
jdbcValidationQuery=select 1

0 0