java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • ignore null values
    via by mm07,
  • 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}
    via by Renan Battaglin,
  • 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}
    via by Renan Battaglin,
  • SQLException with Portofino 4.2.1
    via by EvenAngel007,
  • I'm getting error "Invalid column name"
    via Stack Overflow by vijaya kumar
    ,
  • How to make Mule 3 display full stack traces
    via by Unknown author,
  • Hibernate Native SQL
    via Stack Overflow by manas
    ,
    • java.sql.SQLException: Invalid column name at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3711) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:2763) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:494) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3326)

    Users with the same issue

    pnaranja
    6 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    2 more bugmates