Return-Path: 
 <users-return-11158-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org>
Delivered-To: apmail-activemq-users-archive@www.apache.org
Received: (qmail 3597 invoked from network); 25 Oct 2007 11:29:06 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 25 Oct 2007 11:29:06 -0000
Received: (qmail 73675 invoked by uid 500); 25 Oct 2007 11:28:53 -0000
Delivered-To: apmail-activemq-users-archive@activemq.apache.org
Received: (qmail 73646 invoked by uid 500); 25 Oct 2007 11:28:53 -0000
Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@activemq.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@activemq.apache.org>
List-Post: <mailto:users@activemq.apache.org>
List-Id: <users.activemq.apache.org>
Reply-To: users@activemq.apache.org
Delivered-To: mailing list users@activemq.apache.org
Received: (qmail 73631 invoked by uid 99); 25 Oct 2007 11:28:53 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Oct 2007 04:28:53 -0700
X-ASF-Spam-Status: No, hits=2.6 required=10.0
	tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Oct 2007 11:28:51 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1Il0sq-0000ql-O3
	for users@activemq.apache.org; Thu, 25 Oct 2007 04:28:16 -0700
Message-ID: <13404857.post@talk.nabble.com>
Date: Thu, 25 Oct 2007 04:28:16 -0700 (PDT)
From: navneek <nava.arul@gmail.com>
To: users@activemq.apache.org
Subject: Messages are not getting persisted in database
 table.(jdbcPersistenceAdapter>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: nava.arul@gmail.com
X-Virus-Checked: Checked by ClamAV on apache.org


Hi,

Im using the following configuration for persisting messages into oracle
database. Ultimately When I start activemq the tables (activemq_acks,
activemq_lock, activemq_msgs) are created but it is not holding any message
in table named 'activemq_msgs'. When I post messages into Broker, msg
staying in broker only... but msg are not going into dadabase
table(activemq_msgs).Table data remains empty.. Please let me know if im
missing anymore configuration. I want to populate this table with the
messages im posting in broker.

My configuration:
--------------------------------------
<broker xmlns="http://activemq.org/config/1.0" brokerName="localhost"
persistent="true">
 <persistenceAdapter>
        <jdbcPersistenceAdapter dataSource="#oracle-ds"
useDatabaseLock="true"/>
    </persistenceAdapter>

<bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
    <property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@mydb:1521:orclcore"/>
    <property name="username" value="scott"/>
    <property name="password" value="testpw"/>
    <property name="poolPreparedStatements" value="true"/>
  </bean>

-- 
View this message in context: http://www.nabble.com/Messages-are-not-getting-persisted-in-database-table.%28jdbcPersistenceAdapter%3E-tf4690259s2354.html#a13404857
Sent from the ActiveMQ - User mailing list archive at Nabble.com.