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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.