title: Add zeroDateTimeBehavior variable to the Datasource without URL in jetty.xml
body: <p>I'm trying to connect to multiple data sources by a grails application. What I tried worked in a development environment correctly. Initially there was a timestamp error which got resolved with '<code>zeroDateTimeBehavior=convertToNull</code>' adding to a url. But now in production environment, I don't understand how to add this variable.</p>
  
  <p>My development environment code is, </p>
  
  <pre><code>dataSource_test {
              driverClassName = "com.mysql.jdbc.Driver"
              dialect = "org.hibernate.dialect.MySQL5InnoDBDialect"
              dbCreate = "validate" // one of 'create', 'create-drop', 'update', 'validate', ''
              url = "jdbc:mysql://localhost/test?useUnicode=yes&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull"
              username = "root"
              password = "root"
          }
  </code></pre>
  
  <p>And my production environment code is</p>
  
  <pre><code>dataSource_test{
              dbCreate = "validate"
              jndiName = "java:comp/env/jdbc/test"
          }
  </code></pre>
  
  <p>I've also added this datasource to jetty.xml as following,</p>
  
  <pre><code> &lt;New id="DS" class="org.eclipse.jetty.plus.jndi.Resource"&gt;
      &lt;Arg&gt;&lt;Ref refid="Server"/&gt;&lt;/Arg&gt;
      &lt;Arg&gt;jdbc/test&lt;/Arg&gt;
      &lt;Arg&gt;
        &lt;New class="com.zaxxer.hikari.HikariDataSource"&gt;
          &lt;Arg&gt;
            &lt;New class="com.zaxxer.hikari.HikariConfig"&gt;
          &lt;Set name="minimumIdle"&gt;&lt;Property name="db.min.conn" /&gt;&lt;/Set&gt;
              &lt;Set name="maximumPoolSize"&gt;&lt;Property name="db.max.conn" /&gt;&lt;/Set&gt;
              &lt;Set name="dataSourceClassName"&gt;com.mysql.jdbc.jdbc2.optional.MysqlDataSource&lt;/Set&gt;
              &lt;Set name="username"&gt;&lt;Property name="db.user" /&gt;&lt;/Set&gt;
              &lt;Set name="password"&gt;&lt;Property name="db.pass" /&gt;&lt;/Set&gt;
              &lt;Call name="addDataSourceProperty"&gt;
                &lt;Arg&gt;url&lt;/Arg&gt;
                &lt;Arg&gt;jdbc:mysql://&lt;Property name="db.host" /&gt;/test&lt;/Arg&gt;
              &lt;/Call&gt;
              &lt;Set name="leakDetectionThreshold"&gt;30000&lt;/Set&gt;
            &lt;/New&gt;
          &lt;/Arg&gt;
        &lt;/New&gt;
      &lt;/Arg&gt;
    &lt;/New&gt;
  </code></pre>
  
  <p>I don't understand where should I put "<code>zeroDateTimeBehavior=convertToNull</code>" ?</p>