Spring Configuration Database Driver

1. Load with Hibernate.properties file

<bean class= "Org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" >
<property name= "Locations" >
<list>
<value>classpath:hibernate.properties</value>
</list>
</property>
</bean>

Or

<bean id= "DataSource" class= "Org.apache.commons.dbcp.BasicDataSource" >
<property name= "Driverclassname" value= "${hibernate.connection.driver_class}"/>
<property name= "url" value= "${hibernate.connection.url}"/>
<property name= "username" value= "${hibernate.connection.username}"/>
<property name= "Password" value= "${hibernate.connection.password}"/>
<property name= "InitialSize" value= "${hibernate.initialsize}"/>
<property name= "maxactive" value= "${hibernate.maxactive}"/>
</bean>

Hibernate.properties file (Oracle)

Hibernate.connection.driver_class=oracle.jdbc.driver.oracledriver
Hibernate.connection.url=jdbc\:oracle\:thin\:@127.0.0.1\:1521/abc
Hibernate.connection.username=root
hibernate.connection.password=123456

hibernate.properties file (MySQL)

Hibernate.connection.driver_class=com.mysql.jdbc.driver
Hibernate.connection.url=jdbc\:mysql\://127.0.0.1\:3306/disc_shop?useunicode\=true&characterencoding\=utf8
Hibernate.connection.username=root
hibernate.connection.password=123456

2. Direct configuration

<bean id= "DataSource" class= "Org.apache.commons.dbcp.BasicDataSource" >
<property name= "Driverclassname" value= "Oracle.jdbc.driver.OracleDriver" ></property>
<property name= "username" value= "Roott" ></property>
<property name= "Password" value= "123456" ></property>
<property name= "url" value= "JDBC:ORACLE:THIN:@192.168.10.197:1521:ABC" ></property>
</bean>

Spring Configuration Database Driver