切换到宽版
  • 5280阅读
  • 0回复

各种数据库的连接URL示例 [复制链接]

上一主题 下一主题
离线admin
 

只看楼主 倒序阅读 使用道具 楼主  发表于: 2015-07-18
#url demo
#sql server
druid.datasource.url=jdbc:jtds:sqlserver://localhost:1466/hams

#oracle
druid.datasource.url=jdbc:oracle:thin:@NEWBS:1521:orcl
#h2#
druid.datasource.url=jdbc:h2:file:D:/Hams;AUTO_SERVER=TRUE
#mysql
druid.datasource.url=jdbc:mysql://localhost:3306/hams?useUnicode=true&characterEncoding=utf-8

# default
druid.datasource.name=DataSource
druid.datasource.filters=stat
druid.datasource.maxActive=60
druid.datasource.initialSize=1
druid.datasource.maxWait=60000
druid.datasource.minIdle=1
druid.datasource.timeBetweenEvictionRunsMillis=60000
druid.datasource.minEvictableIdleTimeMillis=300000
druid.datasource.validationQuery=SELECT 'x'
druid.datasource.testWhileIdle=true
druid.datasource.testOnBorrow=false
druid.datasource.testOnReturn=false
druid.datasource.poolPreparedStatements=false
druid.datasource.maxOpenPreparedStatements=20
druid.datasource.slowSqlMillis=5000
druid.datasource.isLogSlowSql=true
sqlserverSchemaName=dbo
快速回复
限100 字节
如果您提交过一次失败了,可以用”恢复数据”来恢复帖子内容
 
上一个 下一个