Re: Fwd: Postgres JDBC, WS and commit

Dnia piątek, 11 maja 2012 06:08:11 mephysto pisze:
> Hello newly,
> I tried to enable "Non Transacitonal Connection" and my function execute
> commit as I want, but at the moment I have some little problems with threads
> and I don't know the reason of these problems.
Actually non transactional connection makes connections unmanaged by
Glassfish's transaction manager, so EJB as well.

> I would to know more about pgConnectionpoolDataSource and pgXADataSource to
> set correct datasource in Glassfish connection pool. Where can I find
> documentation about these two kind of DataSource?
Both are almost same (do not mix it with Polling data source), in fact XA is
build on top of PGConnectionPool. Difference between those is transaction
managment, XA requires transaction manager as every XA resource and needs to
implement specific interface, PGConnectionPool doesn't require it. I can't
imagine XA resource without transactions, probably this may work like
autocommit.

> If I will use a multinode postgres managed by pgpool, which DataSource suits
> my needs?
There should be no difference, both connection will connect to pgpool.

In any case I suggest you to try to use @TransactionAttribute(REQUIRES_NEW) or
@TransactionManagement(BEAN). Such application that relies on Glassfish
specific feature like non transactional connection will not be portable.

> Thanks in advance.
>
> Meph
>
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Postgres-JDBC-WS-and-commit-tp56976
> 57p5702984.html Sent from the PostgreSQL - jdbc mailing list archive at
> Nabble.com.