Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it possible to load two different versions of the JDBC driver in the same application? - Mailing list pgsql-general

From Rob Sargent
Subject Re: Is it possible to load two different versions of the JDBC driver in the same application?
Date
Msg-id 5348612A.5040506@gmail.com
Whole thread Raw
In response to Is it possible to load two different versions of the JDBC driver in the same application?  (Tecno Brain <cerebrotecnologico@gmail.com>)
Responses Re: Is it possible to load two different versions of the JDBC driver in the same application?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-general
Tree view
On 04/11/2014 03:31 PM, Tecno Brain wrote:
I have a Java application that is using Postgres 9.1, and we use the latest 9.1 JDBC driver.
The same Java app requires access now to a Redshift cluster. Amazon recommends to use a Postgres 8 JDBC driver for connecting to Redshift.

Can I load both drivers in the same application ?

I currently use the Apache database connection pool configured through Tomcat's context.xml to load the driver and handle the connection pool.

-Jorge



Can you easily isolate the two?  i.e. can you easily know which driver you want for each db access.  If so, I suspect some classloader games are in your future. If not, tell Amazon you'll be moving to Rackspace.

pgsql-general by date:

Previous
From: Tecno Brain
Date:
Subject: Is it possible to load two different versions of the JDBC driver in the same application?
Next
From: Dave Cramer
Date:
Subject: Re: Is it possible to load two different versions of the JDBC driver in the same application?