JBoss 5.1 + PostgreSQL 8.4 - Two Datasources

tenareth Jul 11, 2011 3:18 PM

I'm setting up a JBoss installation that has two Datasources, 2 different databases on the same physical PostgreSQL server. The first one comes up fine, but no matter what I do the second one will not show as UP. I've duplicated the XML file, recreated via the UI and nothing seems to work.

Local Transaction Datasources deployed in the instance of JBoss AS

DefaultDS	UP
my/default/history	DOWN
my/default/journal	UP

I can't find any errors on either PostgreSQL or JBoss indicating why the first one continues to show DOWN. Mostly I'm curious if there is a way to increase the verbosity of the JNDI/JDBC initialization that shows why it is selecting DOWN.

1. Re: JBoss 5.1 + PostgreSQL 8.4 - Two Datasources

tenareth Jul 14, 2011 6:37 PM (in response to tenareth)

I found that this is a bug that has been fixed in 6.0. The datasource actually works fine, just shows as DOWN/UNKNOWN in the management screen.
Actions
2. Re: JBoss 5.1 + PostgreSQL 8.4 - Two Datasources

amien Jul 26, 2011 5:39 PM (in response to tenareth)

Hi tenareth, I need your help i have problemin connection with database postgresql 8.4 (I use Jboss 5.1)
If you can shar your *-ds.xml and your persistence.xml thank you
Actions

Go to original post