title: spring.jpa.hibernate.ddl-auto=validate or update returns beans.factory.BeanCreationException
body: <p>so far I only have a simple empty Spring application (only <code>main()</code>) with the database configurations (Oracle) and the dependencies as you can see below.</p>
  <p>During the first test run it turned out that if I use <code>validate</code> or <code>update</code> instead <code>spring.jpa.hibernate.ddl-auto=create-drop</code> the following errors occurs (see Error Messages). With <code>create-drop</code> the application would start and work with only one error: &quot;ERROR o.h.e.j.e.i.JdbcEnvironmentImpl - Could not fetch the SequenceInformation from the database
  java.sql.SQLException: Numeric Overflow&quot;</p>
  <p>I would be very happy if you would help me. Previous forum entries were unfortunately not successful.</p>
  <p><strong>application propperties</strong></p>
  <p><em>Oracle settings</em></p>
  <pre><code>spring.datasource.url=jdbc:oracle:thin:@//example:1521/example
  spring.datasource.username=User
  spring.datasource.password=user
  spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
  spring.datasource.continueOnError: true
  spring.batch.initialize-schema=always
  </code></pre>
  <p><em>HikariCP settings</em></p>
  <pre><code>spring.datasource.hikari.connection-timeout=60000
  spring.datasource.hikari.maximum-pool-size=5
  </code></pre>
  <p><em>Logging</em></p>
  <pre><code>logging.pattern.console=%d{yyyy-MM-dd HH:mm:ss} %-5level %logger{36} - %msg%n
  logging.level.org.hibernate.SQL=DEBUG
  </code></pre>
  <p><em>JPA/Hibernate</em></p>
  <pre><code>spring.jpa.show-sql=true
  spring.jpa.generate-ddl=true
  spring.jpa.hibernate.ddl-auto=validate
  spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle12cDialect
  </code></pre>
  <p><strong>Pom.xml</strong></p>
  <pre><code>&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
  &lt;project xmlns=&quot;http://maven.apache.org/POM/4.0.0&quot; xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;
      xsi:schemaLocation=&quot;http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd&quot;&gt;
      &lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
      &lt;parent&gt;
          &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
          &lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt;
          &lt;version&gt;2.2.6.RELEASE&lt;/version&gt;
          &lt;relativePath/&gt; &lt;!-- lookup parent from repository --&gt;
      &lt;/parent&gt;
      &lt;groupId&gt;com.example&lt;/groupId&gt;
      &lt;artifactId&gt;OracleDatabaseConnection&lt;/artifactId&gt;
      &lt;version&gt;0.0.1-SNAPSHOT&lt;/version&gt;
      &lt;name&gt;OracleDatabaseConnection&lt;/name&gt;
      &lt;description&gt;Demo project for Spring Boot&lt;/description&gt;
  
      &lt;properties&gt;
          &lt;java.version&gt;1.8&lt;/java.version&gt;
      &lt;/properties&gt;
  
      &lt;dependencies&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter-data-jpa&lt;/artifactId&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter-jdbc&lt;/artifactId&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter-web&lt;/artifactId&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;com.oracle&lt;/groupId&gt;
              &lt;artifactId&gt;ojdbc8&lt;/artifactId&gt;
              &lt;version&gt;12.2.0.1&lt;/version&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter-test&lt;/artifactId&gt;
              &lt;scope&gt;test&lt;/scope&gt;
              &lt;exclusions&gt;
                  &lt;exclusion&gt;
                      &lt;groupId&gt;org.junit.vintage&lt;/groupId&gt;
                      &lt;artifactId&gt;junit-vintage-engine&lt;/artifactId&gt;
                  &lt;/exclusion&gt;
              &lt;/exclusions&gt;
          &lt;/dependency&gt;
      &lt;/dependencies&gt;
  
      &lt;build&gt;
          &lt;plugins&gt;
              &lt;plugin&gt;
                  &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
                  &lt;artifactId&gt;spring-boot-maven-plugin&lt;/artifactId&gt;
              &lt;/plugin&gt;
          &lt;/plugins&gt;
      &lt;/build&gt;
  
  &lt;/project&gt;
  </code></pre>
  <h1>Entity Class</h1>
  <pre><code>import java.util.Set;
  import javax.persistence.Column;
  import javax.persistence.Entity;
  import javax.persistence.GeneratedValue;
  import javax.persistence.GenerationType;
  import javax.persistence.Id;
  import javax.persistence.Table;
  
  @Entity
  @Table(name=&quot;AMP_MS_USER&quot;) 
  public class User {
      @Id
      @GeneratedValue(strategy = GenerationType.SEQUENCE, generator=&quot;USER_SEQUENCE&quot;)
        @SequenceGenerator(sequenceName = &quot;MS_USER_SEQUENCE&quot;, allocationSize = 1, name = &quot;USER_SEQUENCE&quot;)
      @Column(name=&quot;id_calcuser&quot;)
      private Long id_calcuser;
      
  
      @Column(name=&quot;username&quot;)
      private String username;
      
      @Column(name=&quot;password&quot;)
      private String password;
  
      public User() {
          
      }
  
      public User(String username, String password) {
          super();
          this.username = username;
          this.password = password;
      }
  
      public Long getId_calcuser() {
          return id_calcuser;
      }
  
      public void setId_calcuser(Long id_calcuser) {
          this.id_calcuser = id_calcuser;
      }
  
      
  
      public String getUsername() {
          return username;
      }
  
      public void setUsername(String username) {
          this.username = username;
      }
  
      public String getPassword() {
          return password;
      }
  
      public void setPassword(String password) {
          this.password = password;
      }
  
  }
  </code></pre>
  <p><strong>Sequence in SQL Developer</strong></p>
  <pre><code>-- Create sequence 
  create sequence MS_USER_SEQUENCE
  minvalue 1
  maxvalue 9999999999999999999999999999
  start with 1
  increment by 1
  cache 20;
  </code></pre>
  <p><strong>Error Messages</strong></p>
  <pre><code>2020-04-20 13:53:11 ERROR o.h.e.j.e.i.JdbcEnvironmentImpl - Could not fetch the SequenceInformation from the database
  java.sql.SQLException: Numeric Overflow
      at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4136)
      at oracle.jdbc.driver.NumberCommonAccessor.getLong(NumberCommonAccessor.java:591)
      at oracle.jdbc.driver.GeneratedStatement.getLong(GeneratedStatement.java:206)
      at oracle.jdbc.driver.GeneratedScrollableResultSet.getLong(GeneratedScrollableResultSet.java:259)
      at oracle.jdbc.driver.GeneratedResultSet.getLong(GeneratedResultSet.java:558)
      at com.zaxxer.hikari.pool.HikariProxyResultSet.getLong(HikariProxyResultSet.java)
      at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorLegacyImpl.resultSetMinValue(SequenceInformationExtractorLegacyImpl.java:134)
      at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorLegacyImpl.extractMetadata(SequenceInformationExtractorLegacyImpl.java:60)
      at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.sequenceInformationList(JdbcEnvironmentImpl.java:403)
      at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.&lt;init&gt;(JdbcEnvironmentImpl.java:268)
      at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:114)
  </code></pre>