Re: "nested transaction" - encosing statement gets closed

From: Havard Tveite <havard(dot)tveite(at)umb(dot)no>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "nested transaction" - encosing statement gets closed
Date: 2007-01-16 08:16:20
Message-ID: 45AC89D4.4060707@umb.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Kris Jurka wrote:
> On Mon, 15 Jan 2007, Havard Tveite wrote:
>
>> I have experienced problems using the JDBC type 2 and type 3
>> drivers for 8.1 (postgresql-8.1-408.jdbc3.jar,
>> postgresql-8.1-408.jdbc2.jar) against PostgreSQL 8.1.5.
>>
>
> Are you sure it's complaining that stmt is closed. This coding clearly
> looks like the problem will be with stmtchk as you close it in the loop,
> but then continue using it.

You are right. I was so hung up in that it worked for
7.4.1 that I did not check things properly. Sorry!
Thank you for the help!

--
Håvard Tveite
Department of Mathematical Sciences and Technology, UMB
Drøbakveien 14, POBox 5003, N-1432 Ås, NORWAY
Phone: +47 64965483 Fax: +47 64965401 http://www.umb.no/imt

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Altaf Malik 2007-01-16 14:28:31 Could not find commit log for changelogs
Previous Message Jeanna Geier 2007-01-15 17:55:32 Re: Problem Retrieving/Refresing Data From Database