From ddlutils-user-return-321-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org Wed Apr 12 11:52:46 2006 Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 56568 invoked from network); 12 Apr 2006 11:52:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 12 Apr 2006 11:52:44 -0000 Received: (qmail 49543 invoked by uid 500); 12 Apr 2006 11:52:43 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 49470 invoked by uid 500); 12 Apr 2006 11:52:43 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 49459 invoked by uid 99); 12 Apr 2006 11:52:43 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Apr 2006 04:52:43 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates 66.249.92.170 as permitted sender) Received: from [66.249.92.170] (HELO uproxy.gmail.com) (66.249.92.170) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Apr 2006 04:52:42 -0700 Received: by uproxy.gmail.com with SMTP id j40so903584ugd for ; Wed, 12 Apr 2006 04:52:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=aXy8NL8Nndq+prxVVZBFIM6NKtxBzUR2YopUnue0t20O9IdC4k7JndR8OW3U0ZjpvOFplpp6+JyQQV4XY7mYd9Zh770g/j4gr8w/HCsmnynkrQlKmNphoeLHLIjEbnVF+Ar7dNAeh17vVNPVj7qz9ZNQpCxvFm9JzP7L7GK1Zrc= Received: by 10.78.13.18 with SMTP id 18mr272163hum; Wed, 12 Apr 2006 04:52:21 -0700 (PDT) Received: by 10.78.47.10 with HTTP; Wed, 12 Apr 2006 04:52:21 -0700 (PDT) Message-ID: <224f32340604120452i55f621bcladc5413fd36062d@mail.gmail.com> Date: Wed, 12 Apr 2006 13:52:21 +0200 From: "Thomas Dudziak" To: ddlutils-user@db.apache.org Subject: Re: postgres bytea broken In-Reply-To: <443CE351.5020207@hardlight.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <443CC6AF.3030009@hardlight.com.au> <224f32340604120330s3b521813ibe80d2d0696c01ca@mail.gmail.com> <443CE351.5020207@hardlight.com.au> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 4/12/06, Jason wrote: > I'm currently using pg74.216.jdbc3.jar as the postgres jdbc drive= r. > *note this works fine in my application for eg > rs.getBlob(1).getBinaryStream() you should definitely use the newest stable driver available (8.1 I think). > I looked at converter, but since I didnt have a readytogo class I > didnt pursue it, also I have quite a few tables and many bytea type > fields all of which would need to be individually handled this way. I > was hoping to avoid that. You only need to add the converter sub-element in the Ant task, and the one pre-defined converter that I pointed you to might actually do the trick. > is there anyway to force it top be recognised as a Blob instead? nope, the jdbc driver flags it as BINARY, not LONGVARBINARY or BLOB. > presumable the byte[] returned is complete and that wouldnt be good for > out of mem problems with large datafields (plus the jdbc driver is very > evil in that it also doesn't nicely stream when asked, instead it also > buffers the complete field in ram at least once, and probably does a few > nasty copies for fun.) since the 7.4 driver there have been numerous fixes and enhancements in the postgres driver, so you should definitely try a newer one. Tom