Re: Is it possible to load two different versions of the JDBC driver in the same application?

Rob Sargent <robjsargent@xxxxxxxxx> · Fri, 11 Apr 2014 15:39:54 -0600



    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.