java.sql.SQLException: MicrosoftSQLServer 2000 Driver for JDBCResultSet can not re-read row data for column 4.

Apereo Issues | Elliot Metsger | 1 decade ago
  1. 0

    I pulled the USC branch of Announcements from CVS on 8/22/05. When adding topics exceptions like this show up in the uportal log file: ERROR Thread-72 jasig.portal.[] Aug/19 17:02:46 - java.sql.SQLException: MicrosoftSQLServer 2000 Driver for JDBCResultSet can not re-read row data for column 4. java.sql.SQLException: MicrosoftSQLServer 2000 Driver for JDBCResultSet can not re-read row data for column 4. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:224) at edu.columbia.ais.portal.channels.announcements.RDBMTopicStore.topicsFromResultSet(RDBMTopicStore.java:598) at edu.columbia.ais.portal.channels.announcements.RDBMTopicStore.retrieveNewTopicDefs(RDBMTopicStore.java:461) at edu.columbia.ais.portal.channels.announcements.TopicManager.getAllTopics(TopicManager.java:234) at edu.columbia.ais.portal.channels.announcements.ViewXML.getCachedDoc(ViewXML.java:131) at edu.columbia.ais.portal.channels.announcements.ViewXML.get(ViewXML.java:255) at edu.columbia.ais.portal.channels.announcements.CAnnouncements.setRuntimeData(CAnnouncements.java:464) at org.jasig.portal.MultithreadedChannelAdapter.setRuntimeData(MultithreadedChannelAdapter.java:31) at org.jasig.portal.ChannelRenderer$Worker.execute(ChannelRenderer.java:408) at org.jasig.portal.utils.threading.BaseTask.run(BaseTask.java:27) at edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:418) at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:165) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:660) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:685) at java.lang.Thread.run(Thread.java:595)

    Apereo Issues | 1 decade ago | Elliot Metsger
    java.sql.SQLException: MicrosoftSQLServer 2000 Driver for JDBCResultSet can not re-read row data for column 4.
  2. 0

    I pulled the USC branch of Announcements from CVS on 8/22/05. When adding topics exceptions like this show up in the uportal log file: ERROR Thread-72 jasig.portal.[] Aug/19 17:02:46 - java.sql.SQLException: MicrosoftSQLServer 2000 Driver for JDBCResultSet can not re-read row data for column 4. java.sql.SQLException: MicrosoftSQLServer 2000 Driver for JDBCResultSet can not re-read row data for column 4. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:224) at edu.columbia.ais.portal.channels.announcements.RDBMTopicStore.topicsFromResultSet(RDBMTopicStore.java:598) at edu.columbia.ais.portal.channels.announcements.RDBMTopicStore.retrieveNewTopicDefs(RDBMTopicStore.java:461) at edu.columbia.ais.portal.channels.announcements.TopicManager.getAllTopics(TopicManager.java:234) at edu.columbia.ais.portal.channels.announcements.ViewXML.getCachedDoc(ViewXML.java:131) at edu.columbia.ais.portal.channels.announcements.ViewXML.get(ViewXML.java:255) at edu.columbia.ais.portal.channels.announcements.CAnnouncements.setRuntimeData(CAnnouncements.java:464) at org.jasig.portal.MultithreadedChannelAdapter.setRuntimeData(MultithreadedChannelAdapter.java:31) at org.jasig.portal.ChannelRenderer$Worker.execute(ChannelRenderer.java:408) at org.jasig.portal.utils.threading.BaseTask.run(BaseTask.java:27) at edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:418) at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:165) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:660) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:685) at java.lang.Thread.run(Thread.java:595)

    Apereo Issues | 1 decade ago | Elliot Metsger
    java.sql.SQLException: MicrosoftSQLServer 2000 Driver for JDBCResultSet can not re-read row data for column 4.
  3. 0

    A user of the Chinese version of MSSQL 2000 reports getting the following error at various points in JIRA. Switching to the jTDS driver seems to have solved this issue, so it sounds like a bug in the MS JDBC driver. 2004-10-25 23:50:42,078 ERROR [jira.issue.cache.IssueCache] Error issue or children from the database: SQL Exception while getting value: ([Microsoft][SQLServer 2000 Driver for JDBC]Underlying input stream returned zero bytes) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while getting value: ([Microsoft][SQLServer 2000 Driver for JDBC]Underlying input stream returned zero bytes) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:594) at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:493) at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:454) at org.ofbiz.core.entity.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:77) at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:524) at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:559) at com.atlassian.jira.issue.managers.DefaultIssueManager.getIssue(DefaultIssueManager.java:50) at com.atlassian.jira.issue.cache.IssueCache.getIssueChildren(IssueCache.java:257) at com.atlassian.jira.issue.cache.DefaultCacheManager.getEntitiesByGenericValue(DefaultCacheManager.java:119) at com.atlassian.jira.issue.managers.CachingIssueManager.getEntitiesByIssue(CachingIssueManager.java:51) at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:68) at com.atlassian.jira.config.component.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:27) at $Proxy4.getEntitiesByIssue(Unknown Source) at com.atlassian.jira.mail.IssueMailQueueItem.getIssueContextParams(IssueMailQueueItem.java:184) at com.atlassian.jira.mail.IssueMailQueueItem.send(IssueMailQueueItem.java:108) at com.atlassian.mail.queue.MailQueueImpl.sendBuffer(MailQueueImpl.java:55) at com.atlassian.jira.service.services.mail.MailQueueService.run(MailQueueService.java:23) at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:53) at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50) at org.quartz.core.JobRunShell.run(JobRunShell.java:147) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387) java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Underlying input stream returned zero bytes at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseData.getString(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:198) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:497) at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:493) at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:454) at org.ofbiz.core.entity.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:77) at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:524) at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:559) at com.atlassian.jira.issue.managers.DefaultIssueManager.getIssue(DefaultIssueManager.java:50) at com.atlassian.jira.issue.cache.IssueCache.getIssueChildren(IssueCache.java:257) at com.atlassian.jira.issue.cache.DefaultCacheManager.getEntitiesByGenericValue(DefaultCacheManager.java:119) at com.atlassian.jira.issue.managers.CachingIssueManager.getEntitiesByIssue(CachingIssueManager.java:51) at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:68) at com.atlassian.jira.config.component.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:27) at $Proxy4.getEntitiesByIssue(Unknown Source) at com.atlassian.jira.mail.IssueMailQueueItem.getIssueContextParams(IssueMailQueueItem.java:184) at com.atlassian.jira.mail.IssueMailQueueItem.send(IssueMailQueueItem.java:108) at com.atlassian.mail.queue.MailQueueImpl.sendBuffer(MailQueueImpl.java:55) at com.atlassian.jira.service.services.mail.MailQueueService.run(MailQueueService.java:23) at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:53) at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50) at org.quartz.core.JobRunShell.run(JobRunShell.java:147) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)

    Atlassian JIRA | 1 decade ago | Jeff Turner
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Underlying input stream returned zero bytes
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Roller-SQL Server: Issue with Creating a Weblog

    roller-user | 10 years ago | Himanshu Singh
    org.hibernate.exception.GenericJDBCException: could not execute query
  6. 0

    Roller-SQL Server: Issue with Creating a Weblog

    roller-user | 10 years ago | Himanshu Singh
    org.hibernate.exception.GenericJDBCException: could not execute query

    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

      MicrosoftSQLServer 2000 Driver for JDBCResultSet can not re-read row data for column 4.

      at com.microsoft.jdbc.base.BaseExceptions.createException()
    2. com.microsoft.jdbc
      BaseResultSet.getString
      1. com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
      2. com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      3. com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
      4. com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
      5. com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
      5 frames
    3. Commons DBCP
      DelegatingResultSet.getString
      1. org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:224)
      1 frame
    4. edu.columbia.ais
      CAnnouncements.setRuntimeData
      1. edu.columbia.ais.portal.channels.announcements.RDBMTopicStore.topicsFromResultSet(RDBMTopicStore.java:598)
      2. edu.columbia.ais.portal.channels.announcements.RDBMTopicStore.retrieveNewTopicDefs(RDBMTopicStore.java:461)
      3. edu.columbia.ais.portal.channels.announcements.TopicManager.getAllTopics(TopicManager.java:234)
      4. edu.columbia.ais.portal.channels.announcements.ViewXML.getCachedDoc(ViewXML.java:131)
      5. edu.columbia.ais.portal.channels.announcements.ViewXML.get(ViewXML.java:255)
      6. edu.columbia.ais.portal.channels.announcements.CAnnouncements.setRuntimeData(CAnnouncements.java:464)
      6 frames
    5. org.jasig.portal
      BaseTask.run
      1. org.jasig.portal.MultithreadedChannelAdapter.setRuntimeData(MultithreadedChannelAdapter.java:31)
      2. org.jasig.portal.ChannelRenderer$Worker.execute(ChannelRenderer.java:408)
      3. org.jasig.portal.utils.threading.BaseTask.run(BaseTask.java:27)
      3 frames
    6. Backport of JSR 166
      ThreadPoolExecutor$Worker.run
      1. edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:418)
      2. edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:165)
      3. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:660)
      4. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:685)
      4 frames
    7. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame