Hibernate could not fetch the SequenceInformation from the database

by

I solved the problem as follows. Created an extension for Oracle12cDialect. Limited the maximum/minimum value of columns to SQL

package ru.mvawork.hibernate;

import org.hibernate.dialect.Oracle12cDialect;

@SuppressWarnings("unused")
public class CustomOracleDialect extends Oracle12cDialect {

    @Override
    public String getQuerySequencesString() {
        return "select SEQUENCE_OWNER, SEQUENCE_NAME, greatest(MIN_VALUE,         -9223372036854775807) MIN_VALUE,\n"+
                "Least(MAX_VALUE, 9223372036854775808) MAX_VALUE, INCREMENT_BY,     CYCLE_FLAG, ORDER_FLAG, CACHE_SIZE,\n"+
                "Least(greatest(LAST_NUMBER, -9223372036854775807), 9223372036854775808) LAST_NUMBER,\n"+
                "PARTITION_COUNT, SESSION_FLAG, KEEP_VALUE\n"+
                "from all_sequences";
    }

}

In the application.properties file referred to a dialect implementation

spring.jpa.properties.hibernate.dialect=ru.mvawork.hibernate.CustomOracleDialect

You can recreate sequences by limiting the minimum and maximum values. In my case, I can ‘t do it. The primary keys that I use have the dimension Number (12), which falls within the range limit from -9223372036854775807 to 9223372036854775808 with a large margin

More Related Contents:

  1. Need to reset the value of sequence in Oracle
  2. having an exception when saving oracle type object in some entity
  3. Avoid Jackson serialization on non fetched lazy objects
  4. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  5. How can I log SQL statements in Spring Boot?
  6. Spring Boot – Handle to Hibernate SessionFactory
  7. @Transactional method called from another method doesn’t obtain a transaction
  8. No serializer found for class org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor
  9. Error : java.lang.NoSuchMethodError: org.objectweb.asm.ClassWriter.(I)V
  10. Hibernate table not mapped error in HQL query
  11. What is the ‘best’ way to do distributed transactions across multiple databases using Spring and Hibernate
  12. Hibernate-sequence doesn’t exist
  13. mapping Hibernate query results to custom class?
  14. Spring 3.1 Hibernate 4 exception for Inheritance [cannot be cast to org.hibernate.mapping.RootClass]
  15. Java SE + Spring Data + Hibernate
  16. Spring hibernate template when to use and why?
  17. Change database schema during runtime based on logged in user
  18. Spring + Hibernate : a different object with the same identifier value was already associated with the session
  19. How to map sql native query result into DTO in spring jpa repository?
  20. Hibernate Criteria for Dates
  21. Spring 4 + Hibernate 5 = org.springframework.orm.jpa.EntityManagerHolder cannot be cast to org.springframework.orm.hibernate5.SessionHolder
  22. javax.transaction.Transactional vs org.springframework.transaction.annotation.Transactional
  23. How to rollback a database transaction when testing services with Spring in JUnit?
  24. Hibernate native query – char(3) column
  25. Spring 3.1, Hibernate 4, SessionFactory
  26. hibernate two tables per one entity
  27. Array with UserType in Hibernate and PostgreSQL –> MappingException
  28. How to make a database listener with java?
  29. How to use DTO in JSF + Spring + Hibernate
  30. Could not initialize proxy – no Session

Leave a Comment