Sorry for replaying for self.
Dnia niedziela, 13 maja 2012 21:01:16 Radosław Smogura pisze:
> 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.
Threads? What kind of problems do you have? You should not use threads in EJB
> > 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
> > 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-tp5697
> > 6
> > 57p5702984.html Sent from the PostgreSQL - jdbc mailing list archive at
> > Nabble.com.
In response to
pgsql-jdbc by date
|Next:||From: Maciek Sakrejda (msakrejd)||Date: 2012-05-13 20:17:55|
|Subject: Re: Fwd: Cannot pass null in Parameter in Query for ISNULL |
|Previous:||From: Radosław Smogura||Date: 2012-05-13 19:01:16|
|Subject: Re: Fwd: Postgres JDBC, WS and commit|