Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <bean id="messageDao" class="com.foo.dao.springjdbc.MessageDaoSpringJdbcImpl">
- <property name="jdbcTemplate" ref="jdbcTemplate"/>
- </bean>
- <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
- <constructor-arg ref="dataSource"/>
- </bean>
- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
- <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
- <property name="url" value="jdbc:oracle:thin:@${db.ip}:${db.port}:${db.sid}"/>
- <property name="username" value="${db.username}"/>
- <property name="password" value="${db.password}"/>
- <property name="validationQuery" value="select 1 from dual"/>
- <property name="testOnBorrow" value="true"/>
- <property name="testWhileIdle" value="true"/>
- <property name="timeBetweenEvictionRunsMillis" value="5000"/>
- <property name="numTestsPerEvictionRun" value="3"/>
- <property name="maxActive" value="1"/>
- <property name="maxIdle" value="3"/>
- </bean>
Add Comment
Please, Sign In to add comment