configuring for JDBC

[afrozl]

newbie question - I have followed the instructions as described in the setup guide ( https://github.com/rackerlabs/atom-hopper/wiki/Using-the-JDBC-Data-Adapter )
however I get an error when starting up:

org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [org.apache.commons.dbcp.BasicDataSource] for bean with name 'atomHopperDataSource' defined in URL [file:/etc/atomhopper/application-context.xml];

Am I missing a step?

[shintasmith]

Hi, @afrozl, please replace all occurrences of "org.apache.commons.dbcp.BasicDataSource" in the application-context.xml file to "org.apache.tomcat.jdbc.pool.DataSource". I am assuming you are deploying atomhopper in Tomcat? We are now using Tomcat's JDBC pool. I will correct the wiki page shortly.

If you are using containers other than Tomcat, you can use org.apache.commons.dbcp.BasicDataSource, you just need to add commons-dbcp-version.jar to the atomhopper app WEB-INF/lib.

[afrozl]

Thanks for the quick response - new issue. Now getting this:

SEVERE: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'atomHopperDataSource' defined in URL [file:/etc/atomhopper/application-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'timeBetweenEvitctionRunsMillis' of bean class org.apache.tomcat.jdbc.pool.DataSource]: Bean property 'timeBetweenEvitctionRunsMillis' is not writable or has an invalid setter method. Did you
mean 'timeBetweenEvictionRunsMillis'?

[shintasmith]

@afrozl, looks like there's a typo in the wiki (I fixed it already)
timeBetweenEvitctionRunsMillis instead of
timeBetweenEvictionRunsMillis

[afrozl]

Thanks a bunch. Works perfectly now.