From activemq-users-return-2573-apmail-geronimo-activemq-users-archive=geronimo.apache.org@geronimo.apache.org Wed Jul 05 13:53:48 2006 Return-Path: Delivered-To: apmail-geronimo-activemq-users-archive@www.apache.org Received: (qmail 19219 invoked from network); 5 Jul 2006 13:53:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Jul 2006 13:53:48 -0000 Received: (qmail 20060 invoked by uid 500); 5 Jul 2006 13:53:47 -0000 Delivered-To: apmail-geronimo-activemq-users-archive@geronimo.apache.org Received: (qmail 20040 invoked by uid 500); 5 Jul 2006 13:53:47 -0000 Mailing-List: contact activemq-users-help@geronimo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: activemq-users@geronimo.apache.org Delivered-To: mailing list activemq-users@geronimo.apache.org Received: (qmail 20031 invoked by uid 99); 5 Jul 2006 13:53:47 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Jul 2006 06:53:47 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Jul 2006 06:53:46 -0700 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1Fy7oj-00017P-L8 for activemq-users@geronimo.apache.org; Wed, 05 Jul 2006 06:53:25 -0700 Message-ID: <5182042.post@talk.nabble.com> Date: Wed, 5 Jul 2006 06:53:25 -0700 (PDT) From: drwho To: activemq-users@geronimo.apache.org Subject: Re: Oracle XE In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-Sender: gordonwho@gmail.com X-Nabble-From: drwho References: <5125311.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hiram, I am able to persist to XE BUT not without error. With the original xe installation, I have the following problem running the example (ant producer) packaged in the activemq install: [java] Sending message: Message: 16 sent at: Wed Jul 05 09:34:21 EDT 2006 ... [java] Sending message: Message: 17 sent at: Wed Jul 05 09:34:21 EDT 2006 ... [java] Caught: javax.jms.JMSException: Listener refused the connection with the following error: [java] javax.jms.JMSException: Listener refused the connection with the following error: [java] ORA-12516, TNS:listener could not find available handler with matching protocol stack [java] The Connection descriptor used by the client was: [java] ORA-12516, TNS:listener could not find available handler with matching protocol stack [java] The Connection descriptor used by the client was: [java] //localhost:1521/XE I can see the messages have been persisted in the Oracle XE database: After some research on-line that problem might be fixed by changing the oracle connection or session properties: I did the following : SQL> alter system set processes=300 scope=spfile; System altered. SQL> alter system set sessions=300 scope=spfile; System altered. I was able to process about 3000 messages then it bombs with the following error messages: [java] Caught: javax.jms.JMSException: Io exception: The Network Adapter could not establish the connection [java] javax.jms.JMSException: Io exception: The Network Adapter could not establish the connection [java] at org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:45) [java] at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1118) [java] at org.apache.activemq.ActiveMQSession.send(ActiveMQSession.java:1555) [java] at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:462) [java] at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:356) [java] at ProducerTool.sendLoop(Unknown Source) [java] at ProducerTool.run(Unknown Source) [java] at ProducerTool.runTool(Unknown Source) [java] at ProducerTool.main(Unknown Source) [java] Caused by: java.io.IOException: Io exception: The Network Adapter could not establish the connection [java] at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:42) [java] at org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:58) [java] at org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doAddMessage(DefaultJDBCAdapter.java:183) [java] at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:68) [java] at org.apache.activemq.store.memory.MemoryTransactionStore.addMessage(MemoryTransactionStore.java:223) [java] at org.apache.activemq.store.memory.MemoryTransactionStore$1.addMessage(MemoryTransactionStore.java:116) [java] at org.apache.activemq.broker.region.Queue.send(Queue.java:253) [java] at org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java:225) [java] at org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:342) [java] at org.apache.activemq.broker.TransactionBroker.send(TransactionBroker.java:192) [java] at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:113) [java] at org.apache.activemq.broker.CompositeDestinationBroker.send(CompositeDestinationBroker.java:97) [java] at org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilter.java:126) [java] at org.apache.activemq.broker.AbstractConnection.processMessage(AbstractConnection.java:351) [java] at org.apache.activemq.command.ActiveMQMessage.visit(ActiveMQMessage.java:590) [java] at org.apache.activemq.broker.AbstractConnection.service(AbstractConnection.java:201) [java] at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:62) [java] at org.apache.activemq.transport.ResponseCorrelator.onCommand(ResponseCorrelator.java:97) [java] at org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:63) [java] at org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:114) [java] at org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonitor.java:122) [java] at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:87) [java] at org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:143) [java] at java.lang.Thread.run(Thread.java:595) [java] Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274) [java] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328) [java] at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:361) [java] at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:151) [java] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) [java] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595) [java] at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) [java] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) [java] at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) [java] at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) [java] at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:544) [java] at org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:54) I adjusted the processes and sessions to 500 then it bombs out at 41,000 with the same error message. I have placed ojdbc14.jar in \lib. The operating system is Windows XP Pro. I have also tried the following configuration in my config file Has anyone tried to persist to XE and has it worked? -- View this message in context: http://www.nabble.com/Oracle-XE-tf1874741.html#a5182042 Sent from the ActiveMQ - User forum at Nabble.com.