Persist Jms Message Inwards A Database Inwards Glassfish

This tutorial volition take away you lot on how to configure Java Messaging Service inward Glassfish to shop JMS message inward a postgresql database.

What you lot bespeak (configured together with running):
1.) Glassfish 3.1.2.2
2.) Postgresql 9.1
3.) JMS Broker (integrated amongst Glassfish) gear upwards to LOCAL

Steps:
1.) Configure JMS holding to persist JMS message inward database past times adding the next properties within Glassfish admin, unremarkably http://localhost:4848, become to Configurations->server-config->Java Message Service->

imq.persist.jdbc.postgresql.driver=org.postgresql.Driver imq.instanceconfig.version=300 imq.persist.jdbc.postgresql.closedburl=jdbc\:postgresql\://localhost\:5432/ipieljms imq.persist.jdbc.dbVendor=postgresql imq.brokerid=ipiel imq.jmsra.managed=true imq.autocreate.reaptime=1 imq.persist.jdbc.postgresql.opendburl=jdbc\:postgresql\://localhost\:5432/ipieljms imq.persist.jdbc.postgresql.needpassword=true imq.persist.store=jdbc imq.persist.jdbc.postgresql.password=ipiel imq.persist.jdbc.postgresql.user=ipiel 

*Don't forget to gear upwards JMS Service Type=LOCAL, inward the same screen.

2.) Lastly don't forget to specify to JMS Broker, where the postgresql driver is located past times modifying the file: /glassfish-3.1.2.2/mq/etc/imqenv.conf, together with adding the line:

IMQ_DEFAULT_EXT_JARS=/glassfish-3.1.2.2/glassfish/domains/domain1/lib/postgresql-9.0-802.jdbc4.jar 

Or where your postgresql jdbc jolt is.

3.) Make certain that you lot accept ipieljms schema inward postgresql together with user ipiel/ipiel has access to it.

4.) Restart Glassfish together with later on that you lot volition discovery that tables are created inward ipieljms schema.

5.) You tin shipping away forthwith outset sending your JMS message :-)