Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres PooledConnection...

Postgres PooledConnection...

From
"Dirk Bromberg"
Date:
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

Re: Postgres PooledConnection...

From
Aaron Mulder
Date:
    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

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@postgresql.org)
>

Re: Postgres PooledConnection...

From
Dirk Bromberg
Date:
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@postgresql.org)
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

Re: Postgres PooledConnection...

From
Barry Lind
Date:
Correct.  There was a patch for this that was appied to CVS head only.
It is not in the 7.3 branch.  Try the development build from the
jdbc.postgresql.org website.

thanks,
--Barry

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
>
> 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@postgresql.org)
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

Re: Postgres PooledConnection...

From
Barry Lind
Date:
Dirk,

This is a bug in the database.  It was reported on the hackers mail list
a week or two ago by Peter Eisentraut.  The problem is that when the
client_encoding parameter is set the server is doing character set
conversions on the bytea data (which since it is binary data is clearly
the wrong thing to do).  The reason you are seeing this while using the
7.3 driver, but not the 7.2 driver, is because the 7.3 driver uses the
client_encoding feature of the server to do the character set
translation where the 7.2 driver does not.  This change was done because
the java character set conversion is relatively slow (especially in 1.1,
1.2 and 1.3 jvms) as compared to the servers implementation.

I don't know if a fix for this problem has been made yet.

thanks,
--Barry


Dirk Bromberg wrote:
> 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@postgresql.org)
>>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>