Statements in Activemq Xml Jdbcpersistence adapter

[ajay <aj...@exterro.com>]

Hi friends,

I have a doubt. how to add more than one statement in activemq xml using
jdbc persistence adapter. I was able to add only one statements.say i like
this


<persistenceAdapter> 
<jdbcPersistenceAdapter dataSource="#mssql-ds" createTablesOnStartup="false"
useDatabaseLock="false" transactionIsolation="2">

<statements>

<statements findLastSequenceIdInMsgsStatement ="SELECT CAST(RAND() *
1000000000000000000 AS BIGINT)"/>

</statements>

</jdbcPersistenceAdapter>

</persistenceAdapter> 

I need to add one more statements to override methods.when i add am getting
some exceptions like child execution is wrong.Please do help me in adding
multiple statements also statements class method is string which am in need
of overriding.

Is der any way to override the statements using java code in
activemqconnectionfactory.ur help is appreciated.

Thanks,

Ajay.V



--
View this message in context: http://activemq.2283324.n4.nabble.com/Statements-in-Activemq-Xml-Jdbcpersistence-adapter-tp4668983.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Re: Statements in Activemq Xml Jdbcpersistence adapter

[Gary Tully <ga...@gmail.com>]

they are all attributes, see:
http://activemq.apache.org/schema/core/activemq-core-5.8.0-schema.html#statements

so:
<statements>

<statements findLastSequenceIdInMsgsStatement ="SELECT CAST(RAND() *
1000000000000000000 AS BIGINT)"  tablePrefix="BROKER1." etc... />

</statements>

On 8 July 2013 17:24, ajay <aj...@exterro.com> wrote:
> Hi friends,
>
> I have a doubt. how to add more than one statement in activemq xml using
> jdbc persistence adapter. I was able to add only one statements.say i like
> this
>
>
> <persistenceAdapter>
> <jdbcPersistenceAdapter dataSource="#mssql-ds" createTablesOnStartup="false"
> useDatabaseLock="false" transactionIsolation="2">
>
> <statements>
>
> <statements findLastSequenceIdInMsgsStatement ="SELECT CAST(RAND() *
> 1000000000000000000 AS BIGINT)"/>
>
> </statements>
>
> </jdbcPersistenceAdapter>
>
> </persistenceAdapter>
>
> I need to add one more statements to override methods.when i add am getting
> some exceptions like child execution is wrong.Please do help me in adding
> multiple statements also statements class method is string which am in need
> of overriding.
>
> Is der any way to override the statements using java code in
> activemqconnectionfactory.ur help is appreciated.
>
> Thanks,
>
> Ajay.V
>
>
>
> --
> View this message in context: http://activemq.2283324.n4.nabble.com/Statements-in-Activemq-Xml-Jdbcpersistence-adapter-tp4668983.html
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.



-- 
http://redhat.com
http://blog.garytully.com