What is wrong with this configuration?
It generates a lot of validation queries.
Also I've tested with testOnBorrow=true, testOnReturn=false, but it doesn't change anything.
<jira-database-config>
<name>defaultDS</name> <delegator-name>default</delegator-name> <database-type>mssql</database-type> <schema-name>jiraschema</schema-name> <jdbc-datasource> <url>jdbc:jtds:server</url> <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class> <username>jira</username> <password>jirapassword</password> <validation-query>select 1</validation-query> </jdbc-datasource> </jira-database-config>
I didn't quite get the question. The validation query is meant to be executed continously to validate the db connectivity. Are you facing any application performance issue?
validation query is meant to protect the app from database restarts, but if the database is reasonably stable, constant validations are somewhat pointless
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.