The SQL database is only used for long term persistence. Recently received
messages are only in the journal data files. After about 5 minutes or after
the broker is restarted those messages should make it into the SQL
database. This is done for performance reasons. If you don't mind going a
little slower you can disable the use of the journal and persist messages
directly to the SQL database.
On 6/30/06, drwho <[EMAIL PROTECTED]> wrote:
I have activeMQ4.0.1 set up to persist on Oracle XE.
Below is the config file...
<broker brokerName="TestMasterSlave" persistent="true" useJmx="true"
>.....
.................................
<persistenceAdapter>
<journaledJDBC journalLogFiles="5"
dataDirectory="../activemq-data"
dataSource="#oracle-ds"/>
</persistenceAdapter>
...........................
<bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
<property name="url"
value="jdbc:oracle:thin:@//localhost:1521/XE"/>
<property name="username" value="system"/>
<property name="password" value="password"/>
<property name="poolPreparedStatements" value="true"/>
</bean>
I see a couple of tables (ACTIVEMQ_ACK and ACTIVEMQ_MSGS) were created in
Oracle XE when I ran the producer example packaged with ActiveMQ. But none
of the messages were persisted in XE. Any idea why?
Gordon
--
View this message in context:
http://www.nabble.com/Oracle-XE-tf1874741.html#a5125311
Sent from the ActiveMQ - User forum at Nabble.com.
--
Regards,
Hiram
Blog: http://hiramchirino.com
