title: Quartz JDBCJobStore problems with MySQL
body: <p>I'm trying to use Job persistence via job store in my spring mvc project, but something seems wrong in my database structure.</p>
  
  <p>My database is MySQL (v 5.6.15) and I created tables using scripts in Quartz jar (v 1.8.6).</p>
  
  <p>Executing some test I found that jobs and triggers are persisted in DB and (I hope) correctly loaded, but they aren't executed. Trigger status is always on "WAITING".</p>
  
  <p>I tried creating tables structure on a SqlServer instance (always using scripts provided) and, now it works!!! So, what's wrong with MySql?</p>
  
  <p>The only difference I notice is that table names in MySQL are lowercase, instead of all uppercase as in SqlServer, could it be a problem?</p>
  
  <p>My configuration is the following:</p>
  
  <p><strong>Scheduler configuration via spring</strong></p>
  
  <pre><code>&lt;bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean"&gt;
      &lt;property name="quartzProperties"&gt;
          &lt;map&gt;
              &lt;entry key="org.quartz.scheduler.instanceName" value="gep_scheduler" /&gt;
              &lt;!-- ThreadPool --&gt;
              &lt;entry key="org.quartz.threadPool.class" value="org.quartz.simpl.SimpleThreadPool" /&gt;
              &lt;entry key="org.quartz.threadPool.threadCount" value="3" /&gt;
              &lt;entry
                  key="org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread"
                  value="true" /&gt;
              &lt;!-- JobStore --&gt;
              &lt;entry key="org.quartz.jobStore.class" value="org.quartz.impl.jdbcjobstore.JobStoreTX" /&gt;
              &lt;entry key="org.quartz.jobStore.driverDelegateClass" value="org.quartz.impl.jdbcjobstore.StdJDBCDelegate" /&gt;
              &lt;entry key="org.quartz.jobStore.tablePrefix" value="qrtz_" /&gt;
              &lt;entry key="org.quartz.jobStore.dataSource" value="qzDS" /&gt;
              &lt;entry key="org.quartz.jobStore.isClustered" value="false" /&gt;
              &lt;entry key="org.quartz.jobStore.misfireThreshold" value="60000" /&gt;
              &lt;!-- DataSource --&gt;
              &lt;entry key="org.quartz.dataSource.qzDS.driver" value="${db.driver}" /&gt;
              &lt;entry key="org.quartz.dataSource.qzDS.URL" value="${db.url}" /&gt;
              &lt;entry key="org.quartz.dataSource.qzDS.user" value="${db.user}" /&gt;
              &lt;entry key="org.quartz.dataSource.qzDS.password" value="${db.password}" /&gt;
              &lt;entry key="org.quartz.dataSource.qzDS.maxConnections" value="${db.maxActivePools}" /&gt;
              &lt;/map&gt;
      &lt;/property&gt;
  &lt;/bean&gt;
  </code></pre>
  
  <p><strong>NOTE</strong> no exception is thrown.</p>