的jdbc 连接池2.0 写法已经出来很久了,
我们系统也也已经用了很久了
查了下,把几种数据库的写法都摆这里啦。
mysql的写法:
jdbc/mysql
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
jdbc:mysql://localhost:3306/''dbname''
''username''
''password''
30
30
120s
ORCLE 写法:
jdbc/oracle
oracle.jdbc.pool.OracleConnectionPoolDataSource
jdbc:oracle:thin:@localhost:1521:''dbname''
''username''
''password''
30
30
120s
oracle rac 的写法
jdbc/oracle
oracle.jdbc.pool.OracleConnectionPoolDataSource
jdbc:oracle:thin:@192.168.0.110:1521:CHANGEME_DBNAME
CHANGEME
CHANGEME
oracle.jdbc.pool.OracleConnectionPoolDataSource
jdbc:oracle:thin:@192.168.0.111:1521:CHANGEME_DBNAME
CHANGEME
CHANGEME
true
CHANGEME_TABLENAME
30
30
120s
postgresql 的写法:
jdbc/''name''
org.postgresql.Driver
jdbc:postgresql://127.0.0.1:5432/''dbname''
''username''
''password''
30
30
120s
SQL SERVER 的写法:
jdbc/sqlserver
jdbc:sqlserver://localhost:1433;databaseName=Reports>
XXX
YYY
30
30
120s
sybase 的写法 ;
jdbc/sybase
Tds
5000
myhost
mydb
XXX
YYY
30
30
120s
我们系统也也已经用了很久了
查了下,把几种数据库的写法都摆这里啦。
mysql的写法:
jdbc/mysql
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
jdbc:mysql://localhost:3306/''dbname''
''username''
''password''
30
30
120s
ORCLE 写法:
jdbc/oracle
oracle.jdbc.pool.OracleConnectionPoolDataSource
jdbc:oracle:thin:@localhost:1521:''dbname''
''username''
''password''
30
30
120s
oracle rac 的写法
jdbc/oracle
oracle.jdbc.pool.OracleConnectionPoolDataSource
jdbc:oracle:thin:@192.168.0.110:1521:CHANGEME_DBNAME
CHANGEME
CHANGEME
oracle.jdbc.pool.OracleConnectionPoolDataSource
jdbc:oracle:thin:@192.168.0.111:1521:CHANGEME_DBNAME
CHANGEME
CHANGEME
true
CHANGEME_TABLENAME
30
30
120s
postgresql 的写法:
jdbc/''name''
org.postgresql.Driver
jdbc:postgresql://127.0.0.1:5432/''dbname''
''username''
''password''
30
30
120s
SQL SERVER 的写法:
jdbc/sqlserver
jdbc:sqlserver://localhost:1433;databaseName=Reports>
XXX
YYY
30
30
120s
sybase 的写法 ;
jdbc/sybase
Tds
5000
myhost
mydb
XXX
YYY
30
30
120s
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/133735/viewspace-748165/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/133735/viewspace-748165/