Re: LargeObject API

From: "Xavier Poinsard" <xpoinsard(at)free(dot)fr>
To: Dennis Thrysøe <dth(at)conscius(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: LargeObject API
Date: 2007-08-02 14:30:23
Message-ID: 46B1EA7F.7010003@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

You have to chose between database portability and better performance.
Personally I am using a BYTEA field and setBytes : this allows me to
have portable code across databases and decent performance.

Regards.

Dennis Thrysøe a écrit :
> Hello,
>
> Is there any way to use the proprietary LargeObject API, without
> actually having a reference to the postgresql Drivers's Connection object?
>
> I need to store (potentially) large chunks of data, so as I read the
> documentation I need to use the oid type for performance reasons.
>
> However, if the application is executing within a j2ee server with
> connection pooling, the given Connection instance is just a proxy for
> the actual one.
>
> Otherwise I could possibly use PreparedStatement.setBlob(), but how
> could I create a Blob instance?
>
> I'm not on the mailing list (yet).
>
> -dennis
> ---------------------------------------------------------------------------
> The information in this email is confidential and may be legally protected.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-08-02 17:02:38 Re: statement caching patch from Laszlo Hornyak for review
Previous Message Oliver Jowett 2007-08-02 10:45:34 Re: statement caching patch from Laszlo Hornyak for review