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

关注

原创最新推荐文章于 2026-04-15 09:18:33 发布 535 阅读 AI 写同款· GEO 优化 ›

Sybase数据库驱动Jar包用于Sybase的JNDI和Hibernate的配置,数据库的驱动..... 立即下载

数据库连接池的配置
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