Need to know Bean configuration using org.apache.tomcat.jdbc.pool.DataSource

[pramod talekar]

Hi,

I need to use org.apache.tomcat.jdbc.pool instead of org.apache.commons.dbcp.BasicDataSource.

Could you please provide me the bean configuration for the same.

In the below bean, url , username and password are correct but I'm getting errors for setting any property value mentioned below.

<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"
    destroy-method="close">
    <property name="factory"
        value="org.apache.tomcat.jdbc.pool.DataSourceFactory" />
    <property name="type" value="javax.sql.DataSource" />
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://localhost:3306/TEST" />
    <property name="username" value="root" />
    <property name="password" value="admin" />
    <property name="initialSize" value="5" />
    <property name="maxActive" value="10" />
</bean>

Please advise.

[Mark Spritzler]

Well, if you are using the IDE's Spring Tool Suite, which is Eclipse with Spring plugins or IntelliJ.

Then in the

<property name=""

If your cursor is in the duble quotes for the name property and you hit CTRL-SPACE, then the IDE will give you all the legal values of that attribute. So all the set><<Property>> methods in the class="" Class.

Or you can look at the Javadocs for that class and look at what setXXX methods they have and those are the properties you can set.

Hope that helps clarify it for you. <property name="XXX" is just a way to call a setXXX on the class of the bean.

Mark>

[pramod talekar]

Yeah Mark , solved it.

<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource">
	<property name="driverClassName" value="com.mysql.jdbc.Driver" />
	<property name="url" value="jdbc:mysql://localhost:3306/TEST"/>
	<property name="username" value="root"></property>
	<property name="password" value="admin"></property>
	 <property name="initialSize" value="5" />
    <property name="maxActive" value="10" />
</bean> 

Thanks for the reply.

[pramod talekar]

Hey Mark,

Could you please have a look at the other issue I'm facing and kindly advise.

https://coderanch.com/t/604249/Spring/Property-sql-required#2757676

Thanks a lot.