Thread: Postgres and Jboss using two postgresql databases

Postgres and Jboss using two postgresql databases

From
Håkan Jacobsson
Date:
Hi,

I'm using two postgresql databases (one version 8.0, one
version 8.2) with JBoss AS (version 4.2.2.GA).
We have just migrated to JBoss 4.2.2.GA.
We get lots of exceptions in the JBoss logfile after
migration. Seems there is a problem getting data
from both databases in the same method (using an EJB3
Stateless Session Bean).
One database call is made via JDBC (through a DataSource
object), the next call (to the other database) is done
via another Stateless Session Bean (throguh the Entity Manager
object).
Earlier (with the older version of JBoss) - this has not been
a problem. Searching for an answer I've seen suggestions that
the errors might come from the fact that postgresql does not
support 'two-phase commit'.

Any idea what I could do? 8.1 is said to support 'two-phase
commit' - I'm not sure how to configure it. Not even sure if
this is the source of the problem.

/Best regards, Håkan Jacobsson


Re: Postgres and Jboss using two postgresql databases

From
Mike Goldner
Date:
On Wed, 2008-01-02 at 16:15 +0100, Håkan Jacobsson wrote:
> Hi,
>
> I'm using two postgresql databases (one version 8.0, one
> version 8.2) with JBoss AS (version 4.2.2.GA).
> We have just migrated to JBoss 4.2.2.GA.
> We get lots of exceptions in the JBoss logfile after
> migration. Seems there is a problem getting data
> from both databases in the same method (using an EJB3
> Stateless Session Bean).
> One database call is made via JDBC (through a DataSource
> object), the next call (to the other database) is done
> via another Stateless Session Bean (throguh the Entity Manager
> object).
> Earlier (with the older version of JBoss) - this has not been
> a problem. Searching for an answer I've seen suggestions that
> the errors might come from the fact that postgresql does not
> support 'two-phase commit'.
>
> Any idea what I could do? 8.1 is said to support 'two-phase
> commit' - I'm not sure how to configure it. Not even sure if
> this is the source of the problem.
>
> /Best regards, Håkan Jacobsson
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

I have a similar situation with 2 datasources.  You should be able to
configure an xa-datasource in JBoss.

Check out
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAPostgreSQLDatasource

Mike