Re: Postgres PooledConnection...

From: Dirk Bromberg <bromberg(at)tzi(dot)de>
To: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Postgres PooledConnection...
Date: 2003-03-06 15:34:30
Message-ID: 1046964876.15917.12.camel@ideal1.informatik.uni-bremen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 2003-03-06 at 16:55, Aaron Mulder wrote:
> There was a patch for this. If I recall correctly it was checked
> in to CVS HEAD but not one of the relvant branches. What version are you
> using, and are you able to build from source and see if that solves the
> problem?
>
> Aaron

I've used the pg73jdbc3.jar from the download page.
sorry I can't compile and see. We've switched to PreparedStmnts with
set/getBytes and bytea Cols. The problem there is the Bug in the 73.jar
(see the mails on the list) so we now use the 72.jar and have
implemented our own Pool...

if any one can fix these two bugs (PGConnection from DataSource and
get/setBytes then we will be able to test it. But at this time we are
not able to compile new pg.jars)

Dirk

>
> On Mon, 3 Mar 2003, Dirk Bromberg wrote:
> > Hi,
> >
> > i'm using this to get a simple connection sharing:
> >
> > Jdbc3PoolingDataSource source = new Jdbc3PoolingDataSource();
> > source.setDataSourceName("A Data Source");
> > source.setServerName("localhost");
> > source.setDatabaseName("test");
> > source.setUser("testuser");
> > source.setPassword("testpassword");
> > source.setMaxConnections(10);
> >
> > but how can i get the LargeObjectManager now ??????? i cant cast the
> > connections to PGConnection!!!
> >
> > THX
> >
> > Dirk Bromberg
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Aaron Mulder 2003-03-06 15:49:07 Re: Closing one connection closes all connections?
Previous Message Dave Cramer 2003-03-06 13:42:08 Re: SQL Sessions and the DROP DATABASE command