org.hibernate.exception.GenericJDBCException: could not execute query

Atlassian JIRA | Renan Battaglin | 4 years ago
  1. 0

    When notifications are sent or Repos are shared in a FeCru 2.8 instance using Oracle, the following pattern is logged: {code} 2012-08-28 11:38:26,787 WARN - SQL Error: 17027, SQLState: 99999 2012-08-28 11:38:26,787 ERROR - Stream has already been closed 2012-08-28 11:38:26,789 ERROR - Error while processing notifications: org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2452) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192) at org.hibernate.loader.Loader.list(Loader.java:2187) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at com.cenqua.crucible.notification.DefaultNotificationManager.getNotifications(DefaultNotificationManager.java:348) at com.cenqua.crucible.notification.DefaultNotificationManager.processNotifications(DefaultNotificationManager.java:354) at com.cenqua.crucible.notification.DefaultNotificationManager.access$200(DefaultNotificationManager.java:78) at com.cenqua.crucible.notification.DefaultNotificationManager$6.run(DefaultNotificationManager.java:289) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:680) Caused by: java.sql.SQLException: Stream has already been closed at oracle.jdbc.driver.LongAccessor.getBytesInternal(LongAccessor.java:156) at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:126) at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:201) at oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:427) at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1150) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:424) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342) at org.hibernate.type.StringType.get(StringType.java:41) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:186) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:175) at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2267) at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1443) at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1371) at org.hibernate.loader.Loader.getRow(Loader.java:1271) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:619) at org.hibernate.loader.Loader.doQuery(Loader.java:745) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) at org.hibernate.loader.Loader.doList(Loader.java:2449) ... 20 more {code}

    Atlassian JIRA | 4 years ago | Renan Battaglin
    org.hibernate.exception.GenericJDBCException: could not execute query
  2. 0

    When notifications are sent or Repos are shared in a FeCru 2.8 instance using Oracle, the following pattern is logged: {code} 2012-08-28 11:38:26,787 WARN - SQL Error: 17027, SQLState: 99999 2012-08-28 11:38:26,787 ERROR - Stream has already been closed 2012-08-28 11:38:26,789 ERROR - Error while processing notifications: org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2452) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192) at org.hibernate.loader.Loader.list(Loader.java:2187) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at com.cenqua.crucible.notification.DefaultNotificationManager.getNotifications(DefaultNotificationManager.java:348) at com.cenqua.crucible.notification.DefaultNotificationManager.processNotifications(DefaultNotificationManager.java:354) at com.cenqua.crucible.notification.DefaultNotificationManager.access$200(DefaultNotificationManager.java:78) at com.cenqua.crucible.notification.DefaultNotificationManager$6.run(DefaultNotificationManager.java:289) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:680) Caused by: java.sql.SQLException: Stream has already been closed at oracle.jdbc.driver.LongAccessor.getBytesInternal(LongAccessor.java:156) at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:126) at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:201) at oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:427) at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1150) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:424) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342) at org.hibernate.type.StringType.get(StringType.java:41) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:186) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:175) at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2267) at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1443) at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1371) at org.hibernate.loader.Loader.getRow(Loader.java:1271) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:619) at org.hibernate.loader.Loader.doQuery(Loader.java:745) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) at org.hibernate.loader.Loader.doList(Loader.java:2449) ... 20 more {code}

    Atlassian JIRA | 4 years ago | Renan Battaglin
    org.hibernate.exception.GenericJDBCException: could not execute query
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    java.sql.SQLException: Invalid column name when calling sql

    Oracle Community | 3 years ago | mm07
    java.sql.SQLException: Invalid column name
  5. 0

    ignore null values

    Oracle Community | 3 years ago | mm07
    java.sql.SQLException: Invalid column name

  1. pnaranja 6 times, last 4 months ago
3 unregistered visitors
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. java.sql.SQLException

    Stream has already been closed

    at oracle.jdbc.driver.LongAccessor.getBytesInternal()
  2. Oracle jdbc
    OracleResultSet.getString
    1. oracle.jdbc.driver.LongAccessor.getBytesInternal(LongAccessor.java:156)
    2. oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:126)
    3. oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:201)
    4. oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:427)
    5. oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1150)
    6. oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:424)
    6 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyResultSet.getString
    1. com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
    1 frame
  4. Hibernate
    QueryLoader.list
    1. org.hibernate.type.StringType.get(StringType.java:41)
    2. org.hibernate.type.NullableType.nullSafeGet(NullableType.java:186)
    3. org.hibernate.type.NullableType.nullSafeGet(NullableType.java:175)
    4. org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
    5. org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2267)
    6. org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1443)
    7. org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1371)
    8. org.hibernate.loader.Loader.getRow(Loader.java:1271)
    9. org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:619)
    10. org.hibernate.loader.Loader.doQuery(Loader.java:745)
    11. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
    12. org.hibernate.loader.Loader.doList(Loader.java:2449)
    13. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
    14. org.hibernate.loader.Loader.list(Loader.java:2187)
    15. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    15 frames
  5. Hibernate HQL/JP-QL Parser
    QueryTranslatorImpl.list
    1. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    1 frame
  6. Hibernate
    QueryImpl.list
    1. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    2. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
    3. org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    3 frames
  7. com.cenqua.crucible
    DefaultNotificationManager$6.run
    1. com.cenqua.crucible.notification.DefaultNotificationManager.getNotifications(DefaultNotificationManager.java:348)
    2. com.cenqua.crucible.notification.DefaultNotificationManager.processNotifications(DefaultNotificationManager.java:354)
    3. com.cenqua.crucible.notification.DefaultNotificationManager.access$200(DefaultNotificationManager.java:78)
    4. com.cenqua.crucible.notification.DefaultNotificationManager$6.run(DefaultNotificationManager.java:289)
    4 frames
  8. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    2. java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
    3. java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
    4. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
    5. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
    6. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
    7. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    8. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    9. java.lang.Thread.run(Thread.java:680)
    9 frames