Received: from mail1.expertrade.com (r87-43-dsl.sea.lightrealm.net [216.122.43.87]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3LNFq370204 for ; Sat, 21 Apr 2001 19:15:52 -0400 (EDT) (envelope-from d.wall@computer.org) Received: from reggae (reggae.expertrade.com [216.122.43.90]) by mail1.expertrade.com (8.9.3/8.9.3) with SMTP id QAA02943 for ; Sat, 21 Apr 2001 16:15:44 -0700 Message-ID: <000e01c0cab8$fec39e40$5a2b7ad8@expertrade.com> Reply-To: "David Wall" From: "David Wall" To: Subject: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query Date: Sat, 21 Apr 2001 16:15:46 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200104/95 X-Sequence-Number: 1479 I am getting this error reported back from JDBC. I'm not sure if this is from JDBC, or from the Postgresql 7.1. Message: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query SQLState: null ErrorCode: 0 It seems to occur if run two simultaneous "mass delete" operations. It appears as though the database connection goes away, since my code then attempts to reconnect and I get repeated sql exceptions: Message: No results were returned by the query. SQLState: null ErrorCode: 0 I have to restart the programs to get them oprational again. Thanks, David