Database Locking issues

[Vinicius Carvalho]

Hello there. I'm having problems running my examples in a non oracle
database. It seems that activemq uses FOR UPDATE for locking, but with
other databases it throws an error:

<amq:broker useJmx="false" persistent="true" brokerName="localhost">
                <amq:persistenceAdapter>
                         <amq:jdbcPersistenceAdapter id="jdbcAdapter"
dataSource="#dataSource" createTablesOnStartup="true"

</amq:jdbcPersistenceAdapter>

                </amq:persistenceAdapter>
                <amq:transportConnectors>
                        <amq:transportConnector 
uri="tcp://localhost:61616"></amq:transportConnector>
                </amq:transportConnectors>
        </amq:broker>

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
                <property name="driverClassName">
                        <value>org.hsqldb.jdbcDriver</value>
                </property>
                <property name="url">
                        <value>jdbc:hsqldb:hsql://localhost/testdb</value>
                </property>
                <property name="username">
                        <value>sa</value>
                </property>
                <property name="password">
                        <value></value>
                </property>
        </bean>

Any ideas?

Regards

--
IBM Certified SOA Solution Designer
IBM Database Associate - DB2 UDB V8.1 Family
Sun Certified Enterprise Architect (Part I)