|
Spring database connection Configuration
ORACLE
<Bean id = "dataSource" class = "org. apache. commons. dbcp. BasicDataSource" destroy-method = "close">
<Property name = "driverClassName" value = "oracle. jdbc. driver. OracleDriver"/>
<Property name = "url" value = "jdbc: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.101) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl) (SERVER = DEDICATED) "/>
<Property name = "username" value = "rootl"/>
<Property name = "password" value = "1234"/>
</Bean>
2 DB2
<Bean id = "dataSource" class = "org. apache. commons. dbcp. BasicDataSource" destroy-method = "close">
<Property name = "driverClassName" value = "com. ibm. db2.jdbc. app. DB2Driver"/>
<Property name = "url" value = "jdbc: db2: thin :@ localhost: 5000/testDB"/>
<Property name = "username" value = "rootl"/>
<Property name = "password" value = "1234"/>
</Bean>
SQL Server
<Bean id = "dataSource" class = "org. apache. commons. dbcp. BasicDataSource" destroy-method = "close">
<Property name = "driverClassName" value = "com. microsoft. jdbc. sqlserver. SQLServerDriver"/>
<Property name = "url" value = "jdbc: microsoft: sqlserver: // localhost: 1433; DatabaseName = testDB"/>
<Property name = "username" value = "rootl"/>
<Property name = "password" value = "1234"/>
</Bean>
Iii. MySQL
<Bean id = "dataSource" class = "org. apache. commons. dbcp. BasicDataSource" destroy-method = "close">
<Property name = "driverClassName" value = "org. postgresql. Driver"/>
<Property name = "url" value = "jdbc: postgresql: // localhost/testDB"/>
<Property name = "username" value = "rootl"/>
<Property name = "password" value = "1234"/>
</Bean> |
Org. apache. commons. dbcp. BasicDataSource requires commons-pool.jar, commons-dbcp-1.2.2.jar, commons-collections-3.2.jar Three JAR packages
