ActiveMQ-DB-persistence

[mauro <ma...@gmail.com>]

hi all . Excuse me but i am a newbie of AMQ

I am a  TOMEE  users .

I study JMS and now i would  try to use the durable Topic messages. 

I have read from :

http://activemq.2283324.n4.nabble.com/activemq-user-ActiveMQ-DB-persistence-td2342731.html

Now i would try to persist durable topic messages to mydatasource myql
declared into tomee.xml .

>From the article reported above i have read some on journal use ?????????

1) what it is journal ?
2) how i can config for use mydatasource for persist the durable topic
messages?
3)  into the db mysql, what table i have to create? 
4) the tables what field contain?
5) the tables are created automatically ??? 
6) i have to use JDBC or i can use JPA?

Escuse me but i am a newbie of AMQ and JMS.
mauro





--
View this message in context: http://activemq.2283324.n4.nabble.com/ActiveMQ-DB-persistence-tp4685625.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Re: ActiveMQ-DB-persistence

[Tim Bain <tb...@alumni.duke.edu>]

Hopefully you saw that the mailing list thread you referenced was from nine
years ago.  You might want to consult more current information, such as
http://activemq.apache.org/persistence.html and
http://activemq.apache.org/jdbc-master-slave.html.

I've not used JDBC persistence in years, but my understanding is that the
tables are created automatically; you could test that by creating a small
test database and pointing AMQ at it and seeing what happens.

You can see the table definitions by looking at the SQL commands that
create them e.g. in
http://grepcode.com/file/repo1.maven.org$maven2@org.apache.activemq$activemq-osgi@5.10.0@org$apache$activemq$store$jdbc$Statements.java
or directly within the ActiveMQ source code.

But all of this begs the question "Why are you using JDBC?"  By all
accounts, it's far less performant than LevelDB or even KahaDB, so why is
this a path you're even trying to go down, rather than using one of those
other performance adapters?

Tim

On Wed, Sep 17, 2014 at 1:39 AM, mauro <ma...@gmail.com> wrote:

> hi all . Excuse me but i am a newbie of AMQ
>
> I am a  TOMEE  users .
>
> I study JMS and now i would  try to use the durable Topic messages.
>
> I have read from :
>
>
> http://activemq.2283324.n4.nabble.com/activemq-user-ActiveMQ-DB-persistence-td2342731.html
>
> Now i would try to persist durable topic messages to mydatasource myql
> declared into tomee.xml .
>
> From the article reported above i have read some on journal use ?????????
>
> 1) what it is journal ?
> 2) how i can config for use mydatasource for persist the durable topic
> messages?
> 3)  into the db mysql, what table i have to create?
> 4) the tables what field contain?
> 5) the tables are created automatically ???
> 6) i have to use JDBC or i can use JPA?
>
> Escuse me but i am a newbie of AMQ and JMS.
> mauro
>
>
>
>
>
> --
> View this message in context:
> http://activemq.2283324.n4.nabble.com/ActiveMQ-DB-persistence-tp4685625.html
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>