起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 3082|回复: 3

[处理中3] 5.3.3上传文件结果集已耗尽

[复制链接]

76

主题

992

帖子

2212

积分

金牌会员

Rank: 6Rank: 6

积分
2212
QQ
发表于 2018-4-17 10:58:04 | 显示全部楼层 |阅读模式
错误信息:
2018-04-17 10:38:40 [Daisy event dispatcher] [org.outerj.daisy.event.EventDispatcherImpl] ERROR: Exception in event dispatcher.
java.sql.SQLException: 结果集已耗尽
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:382)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:213)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:213)
        at org.outerj.daisy.event.EventDispatcherImpl$EventDispatchThread.run(Unknown Source)
2018-04-17 10:40:30 [Daisy event dispatcher] [org.outerj.daisy.event.EventDispatcherImpl] ERROR: Exception in event dispatcher.
java.sql.SQLException: 结果集已耗尽
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:382)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:213)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:213)
        at org.outerj.daisy.event.EventDispatcherImpl$EventDispatchThread.run(Unknown Source)
2018-04-17 10:41:00 [Daisy event dispatcher] [org.outerj.daisy.event.EventDispatcherImpl] ERROR: Exception in event dispatcher.
java.lang.RuntimeException: Failed to execute JMS action, giving up.
        at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl.executeWhenConnectionIsUp(Unknown Source)
        at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl.send(Unknown Source)
        at org.outerj.daisy.event.EventDispatcherImpl$EventDispatchThread.run(Unknown Source)
Caused by: javax.jms.JMSException: ORA-00001: 违反唯一约束条件 (POSYSTEM.SYS_C0011007)

        at org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:46)
        at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1181)
        at org.apache.activemq.ActiveMQSession.send(ActiveMQSession.java:1551)
        at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:465)
        at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:356)
        at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl$1.run(Unknown Source)
        ... 3 more
Caused by: java.io.IOException: ORA-00001: 违反唯一约束条件 (POSYSTEM.SYS_C0011007)

        at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:43)
        at org.apache.activemq.store.jdbc.TransactionContext.close(Unknown Source)
        at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:75)
        at org.apache.activemq.store.memory.MemoryTransactionStore.addMessage(MemoryTransactionStore.java:224)
        at org.apache.activemq.store.memory.MemoryTransactionStore$2.addMessage(MemoryTransactionStore.java:129)
        at org.apache.activemq.broker.region.Topic.send(Topic.java:250)
        at org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java:292)
        at org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:385)
        at org.apache.activemq.broker.TransactionBroker.send(TransactionBroker.java:193)
        at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:126)
        at org.apache.activemq.broker.CompositeDestinationBroker.send(CompositeDestinationBroker.java:98)
        at org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilter.java:136)
        at org.apache.activemq.broker.TransportConnection.processMessage(TransportConnection.java:498)
        at org.apache.activemq.command.ActiveMQMessage.visit(ActiveMQMessage.java:604)
        at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:294)
        at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:185)
        at org.apache.activemq.transport.ResponseCorrelator.onCommand(ResponseCorrelator.java:95)
        at org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:65)
        at org.apache.activemq.transport.vm.VMTransport.syncOneWay(VMTransport.java:96)
        at org.apache.activemq.transport.vm.VMTransport.oneway(VMTransport.java:83)
        at org.apache.activemq.transport.MutexTransport.oneway(MutexTransport.java:47)
        at org.apache.activemq.transport.ResponseCorrelator.asyncRequest(ResponseCorrelator.java:69)
        at org.apache.activemq.transport.ResponseCorrelator.request(ResponseCorrelator.java:74)
        at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1175)
        ... 7 more
Caused by: java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (POSYSTEM.SYS_C0011007)

        at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.apache.activemq.store.jdbc.TransactionContext.executeBatch(Unknown Source)
        at org.apache.activemq.store.jdbc.TransactionContext.executeBatch(Unknown Source)
        ... 30 more


个人开发环境下,无并发情况。已检查过数据源连接,数据库连接线程数,均无问题。

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35920
发表于 2018-4-17 11:06:54 | 显示全部楼层
看doc数据源的链接数
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

76

主题

992

帖子

2212

积分

金牌会员

Rank: 6Rank: 6

积分
2212
QQ
 楼主| 发表于 2018-4-17 11:15:12 | 显示全部楼层
最大连接数10,问题是现在只是个单机开发环境,服务也是才启动的,没有并发情况啊。而且为什么会违法唯一约束条件呢?
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35920
发表于 2018-4-17 11:29:49 | 显示全部楼层
把doc数据源中activeMQ开头的表删了,然后重启docServer看看
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-5-7 07:47 , Processed in 0.073923 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表