activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Syer <>
Subject HSQLDB and Spring config?
Date Thu, 19 Jul 2007 16:26:02 GMT

I can see here ( that HSQLDB is
a "supported" platform, and I can see the HsqlJDBCAdapter class in my
classpath.  BUt I don't get how to configure AMQ to work with an HSQLDB
database.  I tried it and got an SQLException to do with invalid SQL
("SELECT ... FOR UPDATE" is illegal in HSQL apparently). n I had assumed
that this was the function of the HsqlJDBCAdapter - and if so I must be
configuring it wrong.  Anyone have an example that works (using Spring

Here's one that doesn't work (with AMQ 4.2-incubator-SNAPSHOT):

<bean id="brokerService" class=""
	<property name="brokerName" value="broker" />
	<property name="transportConnectorURIs">
	<property name="persistenceAdapter">
		<bean class="">
			<property name="dataSource" ref="dataSource" />
			<!-- I assume this is redundant because it should be autodetected? -->
			<property name="adapter">
				<bean class=""/>
			<property name="createTablesOnStartup" value="true" />

I gave the BrokerService an id= but it doesn't have any dependents - it's
all a bit fuzzy in my mind.  Is that expected.

View this message in context:
Sent from the ActiveMQ - User mailing list archive at

View raw message