title: ORA-02289: sequence does not exist - when using Spring Data JPA with Spring boot
body: <p>Database being used is Oracle 11g</p>
  
  <pre><code> Hibernate: select schemaname.col_sqe.nextval from dual
  17:06:58.603 [WARN ] -org.hibernate.engine.jdbc.spi.SqlExceptionHelper:SQL Error: 2289, SQLState: 42000
  17:06:58.618 [ERROR] -org.hibernate.engine.jdbc.spi.SqlExceptionHelper:ORA-02289: sequence does not exist
  </code></pre>
  
  <p>The sequence is present in the specified schema in the database and the same query returns proper value when executed via sql developer.</p>
  
  <p>The Auto generation configuration is as follow:</p>
  
  <pre><code>@Id
      @SequenceGenerator(name = "COL_GEN", sequenceName = "COL_SQE",schema="SCHEMANAME")
      @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "COL_GEN")
      @Column(name = "COL_ID")
  </code></pre>
  
  <p>Spring JPA configuration is as follow:</p>
  
  <pre><code>spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect
  spring.jpa.hibernate.use-new-id-generator-mappings=true
  spring.jpa.show-sql=true
  </code></pre>