Ang: Re: Postgres and Jboss using two postgresql databases

Mike,

This config-file on the page you linked too - should I replace
the content in
my postgres-ds.xml with the new content? Or should I create
another file for the new content?

Many thanx for you quick response!

/Håkan

>----Ursprungligt meddelande----
>Från: mgoldner(at)agmednet(dot)com
>Datum: 02-01-2008 16:53
>Till: "Håkan Jacobsson"<hakan(dot)jacobsson99(at)bredband(dot)net>
>Kopia: <pgsql-jdbc(at)postgresql(dot)org>
>Ärende: Re: [JDBC] Postgres and Jboss using two postgresql
databases
>
>
>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
>