title: Cannot find H2 Db Syntax for USING INDEX ENABLE equivalent in Oracle
body: <p>Running Spring Boot App with Liquibase changeset</p>
  <p>My main code uses Oracle to run the sql query but my integration test cases are using H2 database to run the same query.</p>
  <p>below is my <strong>db/changelog/db.changelog-quartz.sql</strong> file.</p>
  <pre><code>--liquibase formatted sql
  
  --changeset quartz:quartz-init
  
  ALTER TABLE QRTZ_LOCKS ADD PRIMARY KEY (SCHED_NAME, LOCK_NAME) USING INDEX  ENABLE;
  ALTER TABLE QRTZ_LOCKS MODIFY (&quot;LOCK_NAME&quot; NOT NULL ENABLE);
  ALTER TABLE QRTZ_LOCKS MODIFY (&quot;SCHED_NAME&quot; NOT NULL ENABLE);
  </code></pre>
  <p>above query works when I <strong>run</strong> <strong>manually</strong> in Oracle but these query does not work when I run them via <strong>Integration Test cases</strong> because may be my test cases are using h2 database.</p>
  <p>Can someone please share the syntax of <strong>&quot;using index enable&quot; in H2</strong></p>
  <p>when I run <strong>Integration test cases</strong> then I am getting below error</p>
  <pre><code> Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement &quot;ALTER TABLE QRTZ_LOCKS ADD PRIMARY KEY (SCHED_NAME, LOCK_NAME) USING[*] INDEX  ENABLE&quot;; SQL statement:
  ALTER TABLE QRTZ_LOCKS ADD PRIMARY KEY (SCHED_NAME, LOCK_NAME) USING INDEX  ENABLE [42000-200]
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
  </code></pre>
  <p>Extra information:</p>
  <p>version of jdbc : <strong>com.oracle.database.jdbc:ojdbc8: 19.11.0.0</strong></p>
  <p>Below is my integration test sample:</p>
  <pre><code>@SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT,
          classes = TestApplication.class)
  @TestPropertySource(locations = &quot;classpath:application-scheduler-test.yml&quot;)
  public class TelSecSchedulerComponentTestIT {
  
      @Autowired
      private BatchJobScheduler batchJobScheduler;
  
      @Autowired
      private Scheduler scheduler;
  
      @Autowired
      private JdbcTemplate jdbcTemplate;
    
      @Test
      public void test() throws IOException, InvalidBatchJobStatusException, SchedulerException, InterruptedException {
          
      }
  </code></pre>
  <p>and below is my <strong>application-scheduler-test.yml</strong> file</p>
  <pre><code>spring:
    datasource:
      driver-class-name: org.h2.Driver
      url: jdbc:h2:mem:test;DB_CLOSE_ON_EXIT=FALSE
    quartz:
      job-store-type: memory
      jdbc:
        initialize-schema: never
      properties:
        org:
          quartz:
            jobStore:
              class: org.quartz.impl.jdbcjobstore.JobStoreTX
              driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate
              dataSource: myTestDB
            dataSource:
              myTestDB:
                driver: org.h2.Driver
                URL: jdbc:h2:mem:test;DB_CLOSE_ON_EXIT=FALSE
                user: sa
                password:
                provider: hikaricp
                validationQuery: select 1
    jpa:
      hibernate:
        use-new-id-generator-mappings: false
        ddl-auto: none
      generate-ddl: true
      database-platform: org.hibernate.dialect.H2Dialect
    liquibase:
      enabled: true
      contexts: scheduler-test
      change-log: classpath:/db/changelog/db.changelog-master.xml
  
  </code></pre>
  <p>I am not sure what <strong>syntax error</strong> I have in the query.</p>
  <p>can some one please help on this ?</p>