I couldn't see the limitQuery() support in the DefaultJDBCAdapter of AMQ5.10,
but it did arrive in AMQ5.13. Our system is currently on 5.10 so we
upgraded a test system to 5.13.4. I updated the jdbcPersistenceAdapter
element to look like this.......
<amq:persistenceAdapter>
<amq:jdbcPersistenceAdapter
adapter="oracleJDBCAdapter" dataSource="#dataSource"
transactionIsolation="2" useDatabaseLock="false" />
</amq:persistenceAdapter>
......but encountered this exception on startup:
Initialization of bean failed; nested exception is
org.springframework.beans.ConversionNotSupportedException: Failed to convert
property value of type 'java.lang.String' to required type
'org.apache.activemq.store.jdbc.JDBCAdapter' for property 'adapter'; nested
exception is java.lang.IllegalStateException: Cannot convert value of type
[java.lang.String] to required type
[org.apache.activemq.store.jdbc.JDBCAdapter] for property 'adapter': no
matching editors or conversion strategy found
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:290)
[spring-beans.jar:4.0.6.RELEASE]
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:129)
[spring-beans.jar:4.0.6.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1456)
[spring-beans.jar:4.0.6.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1197)
[spring-beans.jar:4.0.6.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
[spring-beans.jar:4.0.6.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
[spring-beans.jar:4.0.6.RELEASE]
Can anyone give some pointers on what I'm doing wrong? Or did I
misunderstand ....is the "adapter" attribute not yet implemented?
--
Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html