<bean id="dataSource"
        class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"
        p:driverClassName="${jdbc.driverClassName}"
        p:url="${jdbc.databaseurl}" p:username="${jdbc.username}"
        p:password="${jdbc.password}"
        p:initialSize="1"
        p:maxWait="30000"
        p:maxIdle="-1"
        p:maxActive="-1" />

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
</bean>

<bean id="dailyReportTask" class="com.package.task.MyTask">
    <property name="dataSource" ref="dataSource" />
</bean>