Skip site navigation (1) Skip section navigation (2)

Re: patch: streaming of bytea parameter values

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: patch: streaming of bytea parameter values
Date: 2004-05-23 22:25:51
Message-ID: 40B124EF.1040000@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Kris Jurka wrote:

>>Being user-friendly when dealing with application errors is nice 
>>behaviour to have, but it *is* a separate issue..
> 
> 
> Separate from what, correctness?

Yes.

> We both agree that a short stream or 
> IOException is an error, but I'm not advocating the JDBC equivalent of 
> System.exit() as a viable solution.  What makes it OK for this 
> particular error to destroy a Connection while no other application level 
> error can?

The implementation of SQLState (or connectionErrorOccurred) across 
different drivers is quite patchy. When writing portable applications 
(or even driver-specific applications, to a lesser extent) you have to 
assume that any SQLException you don't specifically recognize means your 
connection is toast.

I don't see that tearing down the connection for a certain class of 
hard-to-handle errors makes this situation any worse.

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-05-24 06:38:40
Subject: Re: Result Set Cursor Patch
Previous:From: Oliver JowettDate: 2004-05-23 22:17:20
Subject: Re: patch: streaming of bytea parameter values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group