title: Creating oracle sequence through hibernate
body: <p>I am trying to create a sequence in Oracle, I am using Spring boot which have hibernate by default. I am having full priveleges to create and drop sequences.
  But everytime I get an exception:<code>java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist</code></p>
  
  <pre><code>@GeneratedValue(generator="data_cat", strategy=GenerationType.SEQUENCE)
  @SequenceGenerator(allocationSize=1, initialValue=100, name="data_cat", sequenceName="BLAH_SCH.DATA_CAT")
  @Id
  private long id;
  </code></pre>
  
  <p>Following is my application.properties</p>
  
  <pre><code>spring.jpa.hibernate.ddl-auto=create 
  spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
  spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.Oracle10gDialect
  </code></pre>
  
  <p>I believe it should create by upon any call to database. Please tell me what could be wrong.</p>
  
  <p>However when I run sql commant in oracle my sequence gets created.</p>
  
  <pre><code>CREATE SEQUENCE "BLAH_SCH"."DATA_CAT";
  </code></pre>