-
1. Re: How to persist JMS Messages in database
stephanenicoll May 30, 2003 3:39 AM (in response to jbosssurendra)I am not sure it's a good place for this but anyway ...
Just defines a datasource with your mysql DB and change the hsqldb in the snipper below to your ds.
To create a ds (jboss 3.2.X) just drop an xml file ending with -ds.xml in the deploy directory
<?xml version="1.0" encoding="UTF-8"?>
<!-- Data source for the Postgres JBossMQ PM java:/jmsDS
Database: jms
User: mqagent
Password: mqagent
-->
<local-tx-datasource>
<jndi-name>jmsDS</jndi-name>
<connection-url>jdbc:postgresql://kpserverdb/jms</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>mqagent</user-name>
mqagent
<min-pool-size>0</min-pool-size>
<max-pool-size>30</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
</local-tx-datasource>
Any question let me know