2012/10/15 Rahul Warawdekar <[email protected]>: > Hi, > > This is Rahul Warawdekar working on Apache Solr search engine hosted on > Tomcat 6 server. > I use Apache Solr 3.4 to index data from a SQL Server 2008 database and am > currently facing database connection issues on Tomcat 6 while connecting to > the database. > >(...) > > My datasource config looks like this. > > <Resource name="jdbc/foo" auth="Container" > type="javax.sql.DataSource" username="foo" password="foo" > driverClassName="com. > microsoft.sqlserver.jdbc.SQLServerDriver" > url="jdbc:sqlserver://SQLServerDatabase" > maxActive="8" > /> > > Just needed to know what could be the possible causes for this type of > errors and how do I proceed the troubleshooting ?
I think you need to configure a validationQuery and testOnBorrow="true" http://commons.apache.org/dbcp/configuration.html (It is a FAQ issue. Search previous discussions of validationQuery in the mailing list archives). Best regards, Konstantin Kolinko --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
