You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@activemq.apache.org by "Jason Shepherd (JIRA)" <ji...@apache.org> on 2013/03/26 00:13:14 UTC

[jira] [Updated] (AMQ-4382) jdbcPersistenceAdapter does not use lockCreateStatement value

     [ https://issues.apache.org/jira/browse/AMQ-4382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jason Shepherd updated AMQ-4382:
--------------------------------

    Priority: Major  (was: Minor)
    
> jdbcPersistenceAdapter does not use lockCreateStatement value
> -------------------------------------------------------------
>
>                 Key: AMQ-4382
>                 URL: https://issues.apache.org/jira/browse/AMQ-4382
>             Project: ActiveMQ
>          Issue Type: Bug
>          Components: Message Store
>    Affects Versions: 5.7.0
>         Environment: 5.7.0.fuse-71-047-s023
> Oracle Database
>            Reporter: Jason Shepherd
>
> When using a jdbcPersistenceAdaptor and adapter with lockCreateStatements set, this is not used by org.apache.activemq.store.jdbc.DefaultDatabaseLocker.
>         <persistenceAdapter>
>             <jdbcPersistenceAdapter createTablesOnStartup="false" 
>                                     lockKeepAlivePeriod="10000"
>                                     lockAcquireSleepInterval="5000"
>                                     cleanupPeriod="0"
>                                     dataSource="#oracle-ds-tomcat-dbcp"  
>                                     maxRows="200">
>                 <statements>
>                     <statements lockCreateStatement="SELECT * FROM ACTIVEMQ_LOCK FOR UPDATE NOWAIT" />
>                 </statements>
>             </jdbcPersistenceAdapter>
>         </persistenceAdapter>
> In activemq.log:
> DEBUG | Locking Query is SELECT * FROM ACTIVEMQ_LOCK | org.apache.activemq.store.jdbc.DefaultDatabaseLocker | main

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira