I'm using the SQL for Confluence add-on and I have the below data source in my server.xml file for accessing SQL data from that add-on. I'm running a server side trace on the MS SQL server and I notice that my wiki server is pinging my MS SQL server several times every second. I realize that this probably has nothing to do with the add-on or even anything to do with Confluence but rather Tomcat. Anybody have any idea if there is anything I can do to have Tomcat not be so yappy to my SQL server?
<Resource name="jdbc/{myprofilename}" auth="Container" type="javax.sql.DataSource" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://{myserver}:1433/{mydb}" username="{myuser}" password="{mypass}" maxActive="20" maxIdle="10" validationQuery="Select 1" />
Yes.
Are these 'pings' executing the validationQuery?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.