Thread: Is it possible to load two different versions of the JDBC driver in the same application?
Is it possible to load two different versions of the JDBC driver in the same application?
From
Tecno Brain
Date:
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.Re: Is it possible to load two different versions of the JDBC driver in the same application?
From
Rob Sargent
Date:
On 04/11/2014 03:31 PM, Tecno Brain wrote:
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.-JorgeI currently use the Apache database connection pool configured through Tomcat's context.xml to load the driver and handle the connection pool.Can I load both drivers in the same application ?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.
Re: Is it possible to load two different versions of the JDBC driver in the same application?
From
Dave Cramer
Date:
Ya, they probably don't like that we use server side prepared statements
Might be possible to just mess with classpath's to get it done.
On 11 April 2014 17:39, Rob Sargent <robjsargent@gmail.com> wrote:
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.On 04/11/2014 03:31 PM, Tecno Brain wrote:-JorgeI currently use the Apache database connection pool configured through Tomcat's context.xml to load the driver and handle the connection pool.Can I load both drivers in the same application ?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.