-
1. Re: JBoss 5.0 CR2 and PostgreSQL
peterj Sep 22, 2008 4:33 PM (in response to jojopotatoe)You must also configure messaging and quartz to use the postgresql database. For messaging, copy the docs/examples/jms/postgresql-persistence-service.xml file to server/xxx/deploy/messaging and remove the hsqldb-persistence-service.xml file. Also, you must edit the file if you are not using clustering - see the comments in the file for details. For Quartz, see http://www.jboss.com/index.html?module=bb&op=viewtopic&t=141835
I have complete, detailed, instructions for replacing Hypersonic, but it is not free. I can provide the URL if you are interested. -
2. Re: JBoss 5.0 CR2 and PostgreSQL
akpraha Nov 23, 2008 4:59 AM (in response to jojopotatoe)Actually, what it seems to be complaining about is that the persistence layer in JBoss Messaging has a declared dependency to the JGroups ChannelFactory service. This service is deployed by default in the clustered "all" configuration (run "jboss.sh -c all"), but is not in the default or minimal configurations.
You can either:
1. switch to the "all" configuration
2. deploy the ChannelFactory service into the configuration you're using
3. set the messaging to be non-clustered:
* set the Clustered attribute of the MessagingPostOfficeService mbean to be false
* comment out the dependency on the ChannelFactory service -
3. Re: JBoss 5.0 CR2 and PostgreSQL
ilangocal Dec 1, 2008 4:29 PM (in response to jojopotatoe)"PeterJ" wrote:
You must also configure messaging and quartz to use the postgresql database. For messaging, copy the docs/examples/jms/postgresql-persistence-service.xml file to server/xxx/deploy/messaging and remove the hsqldb-persistence-service.xml file. Also, you must edit the file if you are not using clustering - see the comments in the file for details. For Quartz, see http://www.jboss.com/index.html?module=bb&op=viewtopic&t=141835
I have complete, detailed, instructions for replacing Hypersonic, but it is not free. I can provide the URL if you are interested.
Peter
I was wondering if you could provide the URL that supposedly talks about replacing the Hypersonic DB database.
thanks -
4. Re: JBoss 5.0 CR2 and PostgreSQL
peterj Dec 1, 2008 7:39 PM (in response to jojopotatoe)The book JBoss In Action (http://www.manning.com/jamae), chapter 15 contains various configuration settings used for production. One of those is replacing HSQLDB with either MySDQL or PostgreSQL. Also, chapter 8 on messaging shows how to configure messaging to use another database.
And it looks like the source is on the book's web site! Target 03 will create a configuration that uses MySQL or PostgreSQL. -
5. Re: JBoss 5.0 CR2 and PostgreSQL
jeffgordon Jan 15, 2009 7:10 PM (in response to jojopotatoe)When you grabbed the postgresql-persistence-service.xml, you probably looked over the comments near teh bottom that say
"All the remaining properties only have to be specified if the post office is clustered. You can safely comment them out if your post office is non clustered"
You need to comment out:
attribute name="GroupName"
attribute name="StateTimeout"
attribute name="CastTimeout"
attribute name="FailoverOnNodeLeave"
depends optional-attribute-name="ChannelFactoryName"
attribute name="ControlChannelName"
attribute name="DataChannelName"
attribute name="ChannelPartitionName"
That will get rid of the error messages like:
NOT FOUND Depends on 'jboss.jgroups:service=ChannelFactory'