Re: Fwd: Postgres JDBC, WS and commit

Hi Radoslaw,
I was referring to Glassfish threads. I don't run any other thread from my
ejb.

The problem is that sometimes, in this configuration, I retrieve null
output from data from database, but indeed the real value is not null.

Thank you very much.

Meph

On 13 May 2012 21:10, Radosław Smogura <rsmogura(at)softperience(dot)eu> wrote:

> 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
> and Web.
>
> > > 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-tp5697
> > > 6
> > > 57p5702984.html Sent from the PostgreSQL - jdbc mailing list archive at
> > > Nabble.com.
>