dbconfig.mysql.xml.erb

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>mysql</database-type>
  <jdbc-datasource>
    <url><%= scope.lookupvar('jira::dburl') %>?useUnicode=true&amp;characterEncoding=UTF8&amp;sessionVariables=storage_engine=InnoDB</url>
    <driver-class><%= scope.lookupvar('jira::dbdriver') %></driver-class>
    <username><%= scope.lookupvar('jira::dbuser') %></username>
    <password><%= scope.lookupvar('jira::dbpassword') %></password>
    <pool-size><%= scope.lookupvar('jira::poolsize') %></pool-size>
    <pool-min-size><%= scope.lookupvar('jira::poolMinSize') %></pool-min-size>
    <pool-max-size><%= scope.lookupvar('jira::poolMaxSize') %></pool-max-size>
    <pool-max-wait><%= scope.lookupvar('jira::poolMaxWait') %></pool-max-wait>
    <validation-query><% if @validationQuery %><%= @validationQuery %><% else %>scope.lookupvar('jira::validationQuery')<% end %></validation-query>
    <min-evictable-idle-time-millis><%= scope.lookupvar('jira::minEvictableIdleTime') %></min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis><% if @timeBetweenEvictionRuns %><%= @timeBetweenEvictionRuns %><% else %><%= scope.lookupvar('jira::timeBetweenEvictionRuns') %><% end %></time-between-eviction-runs-millis>
    <pool-max-idle><%= scope.lookupvar('jira::poolMaxIdle') %></pool-max-idle>
    <pool-remove-abandoned><%= scope.lookupvar('jira::poolRemoveAbandoned') %></pool-remove-abandoned>
    <pool-remove-abandoned-timeout><%= scope.lookupvar('jira::poolRemoveAbandonedTimout') %></pool-remove-abandoned-timeout>
    <pool-test-while-idle><%= scope.lookupvar('jira::poolTestWhileIdle') %></pool-test-while-idle>
    <validation-query-timeout>3</validation-query-timeout>
  </jdbc-datasource>