You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by Aymeric Alibert <ay...@gmail.com> on 2006/11/06 19:54:40 UTC

table definition for persistent store

I would like to configure ActiveMQ with persistent store. 
My DBA do not like to grant the application priviliege to create tables in
our Oracle schema. 
Is it possible to create the required tables beforhand? If that's possible,
where can I find the scripts?

Thanks,

Aymeric. 
-- 
View this message in context: http://www.nabble.com/table-definition-for-persistent-store-tf2584254.html#a7204600
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Re: table definition for persistent store

Posted by Kelly Campbell <ke...@gmail.com>.
The sql is generated by the code. You should be able to see it in the logs
if you turn DEBUG on. Or you can run it against a test database and then
take the schema from there to give to your DBA.

It's really simple (only 3 tables if I remember correctly).

-Kelly

On 11/6/06, Aymeric Alibert <ay...@gmail.com> wrote:
>
>
> I would like to configure ActiveMQ with persistent store.
> My DBA do not like to grant the application priviliege to create tables in
> our Oracle schema.
> Is it possible to create the required tables beforhand? If that's
> possible,
> where can I find the scripts?
>
> Thanks,
>
> Aymeric.
> --
> View this message in context:
> http://www.nabble.com/table-definition-for-persistent-store-tf2584254.html#a7204600
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>