Changing use of HyperSonic with PostgreSQL for JMS Persista

[gurka]

Can anyone write out a step-by-step for doing this? I read the post @ http://www.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQDB and I still have doubts.

if anyone has done this successfully, would appreciate your help.

We are using PostGreSQL currently as part of a deployed app under JBoss, but are only now making use of JMS, and heavily. We have noticed strange errors, and have decided to make the switch from Hypersonic to PostGreSQL.

Thanks for any help.

[starksm64]

Hello,
I am trying to integrate SonicMQ into JBoss as JMS
provider. I almost managed to do that but I still get
a JMS exception as soon as I deploy more than one MDB :
______________________________________________________
[Container factory] Serious error in init: javax.jms.JMSException: [129] progress.message.client.EUserAlreadyConnected: 8884927054856847360
[Container factory] java.lang.Exception: javax.jms.JMSException: [129] progress.message.client.EUserAlreadyConnected: 8884927054856847360
[Container factory] at org.jboss.ejb.MessageDrivenContainer.init(MessageDrivenContainer.java:173)
[Container factory] at org.jboss.ejb.Application.init(Application.java:202)
[Container factory] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:372)
[Container factory] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:304)
[Container factory] at java.lang.reflect.Method.invoke(Native Method)
[Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Container factory] at org.jboss.deployment.J2eeDeployer.startModules(J2eeDeployer.java:486)
[Container factory] at org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:464)
[Container factory] at org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:208)
[Container factory] at java.lang.reflect.Method.invoke(Native Method)
[Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Container factory] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:379)
[Container factory] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:217)
[Container factory] at java.lang.Thread.run(Unknown Source)
[J2EE Deployer Default] Starting connectioncontroller.jar failed!
_____________________________________________________


Do you have an idea about that ??

Regards,
Francesco.

[starksm64]

Give the wiki steps a try and indicate what did not work.

[gurka]

Scott - do I need to do anything in terms of creating a specific DB for this use of JMS by JBoss? Or does just pointing it to the correct DS is all it takes? Will JBoss create the schema, etc..? I read that I may have to tweak the schema somewhat by creating our own indexes and so on...anything else needed?

thanks - I will try the Wiki steps meantime.

[gurka]

Scott - followed the steps. I now see a set of tables created by JBoss - but theses errors are showing up now:

2004-12-24 12:06:58,347 DEBUG [org.jboss.ha.framework.server.HAPartitionImpl] destination list is non-null and empty: no need to send message
2004-12-24 12:06:58,348 ERROR [org.jboss.ejb.plugins.jms.DLQHandler] Initialization failed DLQHandler
javax.jms.JMSException: Error creating the dlq connection: XAConnectionFactory
at org.jboss.ejb.plugins.jms.DLQHandler.createService(DLQHandler.java:171)
at org.jboss.system.ServiceMBeanSupport.jbossInternalCreate(ServiceMBeanSupport.java:237)
at org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:164)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker.innerCreate(JMSContainerInvoker.java:542)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker.startService(JMSContainerInvoker.java:764)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker$ExceptionListenerImpl.onException(JMSContainerInvoker.java:1267)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker$1.run(JMSContainerInvoker.java:776)
2004-12-24 12:06:58,349 INFO [org.jboss.ejb.plugins.jms.JMSContainerInvoker] Reconnected to JMS provider
2004-12-24 12:06:58,350 WARN [org.jboss.ejb.plugins.jms.JMSContainerInvoker] JMS provider failure detected:
javax.jms.JMSException: Error creating the dlq connection: XAConnectionFactory
at org.jboss.ejb.plugins.jms.DLQHandler.createService(DLQHandler.java:171)
at org.jboss.system.ServiceMBeanSupport.jbossInternalCreate(ServiceMBeanSupport.java:237)
at org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:164)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker.innerCreate(JMSContainerInvoker.java:542)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker.startService(JMSContainerInvoker.java:764)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker$ExceptionListenerImpl.onException(JMSContainerInvoker.java:1267)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker$1.run(JMSContainerInvoker.java:776)
2004-12-24 12:06:58,351 INFO [org.jboss.ejb.plugins.jms.JMSContainerInvoker] Trying to reconnect to JMS provider