You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by Nirav <ni...@i-logicon.co.in> on 2008/03/17 08:29:46 UTC
Change from Derby to Oracle in production!
I am using ActiveMQ 3.2 in one of our project which is already in production.
Now requirement is to change message store from Derby to Oracle.
Well I think there is a data loss behind doing this.
Is there any way to avoid data loss?
--
View this message in context: http://www.nabble.com/Change-from-Derby-to-Oracle-in-production%21-tp16089591s2354p16089591.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Behaviour of ActiveMQ tables in Oracle!
Posted by Nirav <ni...@i-logicon.co.in>.
I have a doubt about ACTIVEMQ_MSGS table,
Because I am unable to got any document material regarding ActiveMQ tables.
I really appriciate if someone help us regarding this,
1. Purpose of all 3 tables?
2. When these tables populated?
3. Do we have to write any job to flush it out or ActiveMQ automatically do
it?
4. I am observing that our ActiveMQ consumer gets real time data then also
size of table is increasing in production box(Linux) but no increment in
UAT box(Windows) with same deployment.
We are using ActiveMQ V3.2 within Service-Mix.
--
View this message in context: http://www.nabble.com/Change-from-Derby-to-Oracle-in-production%21-tp16089591s2354p16510456.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: Change from Derby to Oracle in production!
Posted by Nirav <ni...@i-logicon.co.in>.
OK I transfered all messages from Derby to Oracle using Open Adaptor.
And I changed configuration for Oracle in ActiveMQ.xml
Now my doubt is no. of rows in ACTIVEMQ_MSGS is constantly increasing.
Is it normal behaviour?
You can have an overview of my project by clicking below link...
http://forum.java.sun.com/thread.jspa?forumID=512&threadID=5132641
Any suggestion for this also welcomed!
Thanks.
--
View this message in context: http://www.nabble.com/Change-from-Derby-to-Oracle-in-production%21-tp16089591s2354p16142264.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: Change from Derby to Oracle in production!
Posted by Nirav <ni...@i-logicon.co.in>.
Thanks James, but main problem is that only!
I have stopped source of new messages, logic behind that is to give time to
process messages already in queue.
But ActiveMQ is not processing messages in Queue.
--
View this message in context: http://www.nabble.com/Change-from-Derby-to-Oracle-in-production%21-tp16089591s2354p16114448.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: Change from Derby to Oracle in production!
Posted by James Strachan <ja...@gmail.com>.
Just empty your queues then change your activemq.xml.
Or you could use Camel to move messages from your queues to another
broker running against Oracle.
On 17/03/2008, Nirav <ni...@i-logicon.co.in> wrote:
>
> I am using ActiveMQ 3.2 in one of our project which is already in production.
>
> Now requirement is to change message store from Derby to Oracle.
>
> Well I think there is a data loss behind doing this.
>
> Is there any way to avoid data loss?
>
> --
> View this message in context: http://www.nabble.com/Change-from-Derby-to-Oracle-in-production%21-tp16089591s2354p16089591.html
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>
--
James
-------
http://macstrac.blogspot.com/
Open Source Integration
http://open.iona.com