From: | Håkan Jacobsson <hakan(dot)jacobsson99(at)bredband(dot)net> |
---|---|
To: | <mgoldner(at)agmednet(dot)com> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Ang: Re: Postgres and Jboss using two postgresql databases |
Date: | 2008-01-02 16:25:28 |
Message-ID: | 1105069.299331199291128794.JavaMail.root@ps1.bredband.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Mast | 2008-01-02 19:02:34 | Permissions problem |
Previous Message | Mike Goldner | 2008-01-02 15:53:38 | Re: Postgres and Jboss using two postgresql databases |