PostgreSQL (XADataSource) as Tomcat Resource

Поиск
Список
Период
Сортировка
От markds75
Тема PostgreSQL (XADataSource) as Tomcat Resource
Дата
Msg-id 1144263998.675528.212920@t31g2000cwb.googlegroups.com
обсуждение исходный текст
Ответы Re: PostgreSQL (XADataSource) as Tomcat Resource  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-jdbc
How can I get Postgres to be deployed in Tomcat's JNDI as an
XADataSource?

I'm running my web app in Tomcat, and I'm moving towards distributed
transactions for my two data sources (JDO and JCR). I've got the Jencks
library providing JTA support (based on Geronimo's TransactionManager)
within Tomcat. Currently, I have Postgres configured as a local web-app
Resource as follows:

<Resource name="jdbc/whisper_db"
    auth="Container"
    type="javax.sql.DataSource"
    url="jdbc:postgresql://127.0.0.1:5432/my_db"
    driverClassName="org.postgresql.Driver"
    username="----------------"
    password="----------------"
    maxWait="3000"
    maxIdle="100"
    maxActive="10" />

The web-app is able to start up without errors in this case and things
function as expected. However, I've been told that I should be using an
XADataSource if I want JDO to participate in distributed transactions
(specifically, I'm trying to get 2 phase commit). When I change the
type to "javax.sql.XADataSource", the web-app fails to start because
Tomcat cannot create the JNDI entry. I'm running under Java 1.5, so to
my knowledge XADataSource is included.

Any pointers would be appreciated.

Thanks,
Mark


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Jan de Visser
Дата:
Сообщение: Re: I just can't use the org.postgresql.Driver class... Please help!
Следующее
От: "Guy Rouillier"
Дата:
Сообщение: Re: I just can't use the org.postgresql.Driver class... Please help!