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

Atlassian JIRA | Marc Brugger | 4 years ago
  1. 0

    [CRUC-6412] Stream has already been closed on getting Notifications - Atlassian JIRA

    atlassian.com | 1 year ago
    org.hibernate.exception.GenericJDBCException: could not execute query
  2. 0

    I get an error in fecru when notification are sent. {noformat} 2013-03-12 16:59:18,458 WARN [notificationManager1 ] org.hibernate.util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - SQL Error: 17027, SQLState: 99999 2013-03-12 16:59:18,460 ERROR [notificationManager1 ] org.hibernate.util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - Stream has already been closed 2013-03-12 16:59:18,463 ERROR [notificationManager1 ] fisheye DefaultNotificationManager-processNotifications - 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:662) 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 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 {noformat}

    Atlassian JIRA | 4 years ago | Marc Brugger
    org.hibernate.exception.GenericJDBCException: could not execute query
  3. 0

    I get an error in fecru when notification are sent. {noformat} 2013-03-12 16:59:18,458 WARN [notificationManager1 ] org.hibernate.util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - SQL Error: 17027, SQLState: 99999 2013-03-12 16:59:18,460 ERROR [notificationManager1 ] org.hibernate.util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - Stream has already been closed 2013-03-12 16:59:18,463 ERROR [notificationManager1 ] fisheye DefaultNotificationManager-processNotifications - 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:662) 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 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 {noformat}

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

    Automated exception search integrated into your IDE

  5. 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
  6. 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

  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. 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
  4. Hibernate HQL/JP-QL Parser
    QueryTranslatorImpl.list
    1. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    1 frame
  5. 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
  6. 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
  7. 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:662)
    9 frames