org.hibernate.exception.GenericJDBCException: unable to select generated column values

Hibernate JIRA | Stanislav Zaluzhskiy | 5 years ago
  1. 0

    In my project I use specific NamingStrategy (org.hibernate.cfg.NamingStrategy). Each column name is wrapped by quotas - _dialect.openQuote() + columnName + _dialect.closeQuote(). Then I try to use a @Formula with one of the property: @Formula("(select sum(s.\"prodCount\") from SensorEntry as s where s.\"job_id\" = \"id\")") private Long value; This transforms into: select sum(s.job_."prodCount") from SensorEntry as s where s.job_."job_id" = job_."id") as formula24_ Which leads to exception: 19:18:37,268 WARN main JDBCExceptionReporter:100 - SQL Error: 0, SQLState: 3F000 19:18:37,269 ERROR main JDBCExceptionReporter:101 - ERROR: schema "s" does not exist 19:18:37,270 ERROR main AbstractFlushingEventListener:324 - Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: unable to select generated column values at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.processGeneratedProperties(AbstractEntityPersister.java:3754) at org.hibernate.persister.entity.AbstractEntityPersister.processInsertGeneratedProperties(AbstractEntityPersister.java:3703) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:89) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) I suppose that this is because quota literals don't escaped correctly by Hibernate.

    Hibernate JIRA | 5 years ago | Stanislav Zaluzhskiy
    org.hibernate.exception.GenericJDBCException: unable to select generated column values
  2. 0

    In my project I use specific NamingStrategy (org.hibernate.cfg.NamingStrategy). Each column name is wrapped by quotas - _dialect.openQuote() + columnName + _dialect.closeQuote(). Then I try to use a @Formula with one of the property: @Formula("(select sum(s.\"prodCount\") from SensorEntry as s where s.\"job_id\" = \"id\")") private Long value; This transforms into: select sum(s.job_."prodCount") from SensorEntry as s where s.job_."job_id" = job_."id") as formula24_ Which leads to exception: 19:18:37,268 WARN main JDBCExceptionReporter:100 - SQL Error: 0, SQLState: 3F000 19:18:37,269 ERROR main JDBCExceptionReporter:101 - ERROR: schema "s" does not exist 19:18:37,270 ERROR main AbstractFlushingEventListener:324 - Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: unable to select generated column values at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.processGeneratedProperties(AbstractEntityPersister.java:3754) at org.hibernate.persister.entity.AbstractEntityPersister.processInsertGeneratedProperties(AbstractEntityPersister.java:3703) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:89) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) I suppose that this is because quota literals don't escaped correctly by Hibernate.

    Hibernate JIRA | 5 years ago | Stanislav Zaluzhskiy
    org.hibernate.exception.GenericJDBCException: unable to select generated column values
  3. 0

    Issues migrating from Play 2.4.6 to Play 2.5.3 - HikariDataSource HikariDataSource (default-xxxx-hikaricp) has been closed.

    Google Groups | 7 months ago | SM
    org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection*
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Not able to start the Spring Boot with help of JHipster project

    codegur.com | 8 months ago
    org.springframework.orm.jpa.JpaSystemException: unable to obtain isolated JDBC connection; nested exception is org.hibernate.exception.GenericJDBCException: unable to obtain isolated JDBC connection
  6. 0

    Issues migrating from Play 2.4.6 to Play 2.5.3 - HikariDataSource HikariDataSource (default-xxxx-hikaricp) has been closed.

    Google Groups | 7 months ago | SM
    org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.hibernate.exception.GenericJDBCException

      unable to select generated column values

      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException()
    2. Hibernate
      AbstractEntityPersister.processInsertGeneratedProperties
      1. org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
      2. org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
      3. org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      4. org.hibernate.persister.entity.AbstractEntityPersister.processGeneratedProperties(AbstractEntityPersister.java:3754)
      5. org.hibernate.persister.entity.AbstractEntityPersister.processInsertGeneratedProperties(AbstractEntityPersister.java:3703)
      5 frames
    3. Hibernate
      EntityInsertAction.execute
      1. org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:89)
      1 frame
    4. Hibernate
      ActionQueue.execute
      1. org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
      1 frame