Re: expected trigger behavior in transactions

Hi,

Forgive me if this isn't directly a JDBC issue.

I have some triggers setup in postgres that are triggered before inserts.
They are pretty basic triggers. They update some columns and then continue
on with the insert.

We have some java code which starts a transaction (sets auto commit to
false) and then performs some inserts. If successful, it commits the
transaction. Sometimes, it appears like the trigger is fired but does not
commit. Is there a separate connection context for triggers? Do I have to
worry about how triggers work within a transaction? If I commit/rollback an
insert, does it commit/rollback the triggers which were fired?

It seems like when I do the steps directly in postgres, the triggers are
fired appropriately if in a transaction. However, within Java, in some cases
the triggers either aren't fired, or are fired, but do not commit when jdbc
commits. Any ideas what's going on here?

Thanks for any help,

Noah
______________________________________________
Noah Davis
636 Broadway, Suite 516
New York, New York 10012
p: 212.505.5885
f: 212.505.5655
noah(at)acadaca(dot)com
<blocked::http://www.acadaca.com/> www.acadaca.com

Noah,

Can you please post in plain text?

I'd suggest looking at the postgresql logs to see what is really going
on.

There are no "special" contexts.

Dave
On Mon, 2004-08-30 at 13:01, Noah Davis wrote:
> Hi,
>
> Forgive me if this isn't directly a JDBC issue.
>
> I have some triggers setup in postgres that are triggered before
> inserts. They are pretty basic triggers. They update some columns and
> then continue on with the insert.
>
> We have some java code which starts a transaction (sets auto commit to
> false) and then performs some inserts. If successful, it commits the
> transaction. Sometimes, it appears like the trigger is fired but does
> not commit. Is there a separate connection context for triggers? Do I
> have to worry about how triggers work within a transaction? If I
> commit/rollback an insert, does it commit/rollback the triggers which
> were fired?
>
> It seems like when I do the steps directly in postgres, the triggers
> are fired appropriately if in a transaction. However, within Java, in
> some cases the triggers either aren't fired, or are fired, but do not
> commit when jdbc commits. Any ideas what's going on here?
>
> Thanks for any help,
>
> Noah
> ______________________________________________
> Noah Davis
> 636 Broadway, Suite 516
> New York, New York 10012
> p: 212.505.5885
> f: 212.505.5655
> noah(at)acadaca(dot)com
> www.acadaca.com
>
--
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com

Sorry about that. Anyhow, as sometimes happens, the problem was unrelated to
JDBC and postgres.

Thanks for your time anyhow.

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Dave Cramer
Sent: Monday, August 30, 2004 1:29 PM
To: Noah Davis
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] expected trigger behavior in transactions

Noah,

Can you please post in plain text?

I'd suggest looking at the postgresql logs to see what is really going on.

There are no "special" contexts.

Dave
On Mon, 2004-08-30 at 13:01, Noah Davis wrote:
> Hi,
>
> Forgive me if this isn't directly a JDBC issue.
>
> I have some triggers setup in postgres that are triggered before
> inserts. They are pretty basic triggers. They update some columns and
> then continue on with the insert.
>
> We have some java code which starts a transaction (sets auto commit to
> false) and then performs some inserts. If successful, it commits the
> transaction. Sometimes, it appears like the trigger is fired but does
> not commit. Is there a separate connection context for triggers? Do I
> have to worry about how triggers work within a transaction? If I
> commit/rollback an insert, does it commit/rollback the triggers which
> were fired?
>
> It seems like when I do the steps directly in postgres, the triggers
> are fired appropriately if in a transaction. However, within Java, in
> some cases the triggers either aren't fired, or are fired, but do not
> commit when jdbc commits. Any ideas what's going on here?
>
> Thanks for any help,
>
> Noah
> ______________________________________________
> Noah Davis
> 636 Broadway, Suite 516
> New York, New York 10012
> p: 212.505.5885
> f: 212.505.5655
> noah(at)acadaca(dot)com
> www.acadaca.com
>
--
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly