title: Spring Boot JDBCTemplate with c3p0 DataBase Pooling and failover
body: <p>I need to establish DB connectionfailover in SpringBoot application(embedded tomcat) for ibatis with jdbctemplate which uses c3p0 for connection pooling.Below is the applicaiton.properties of my applicaiton.I have primary and secondary databases.If primary fails then secondary should be used for the DB connection failover in runtime. Please help me to achieve this.I tried to include multiple DB urls as part of configuration but which is not working.</p>
  
  <p><a href="https://stackoverflow.com/questions/29149605/c3p0-java-database-pooling-failover-configuration">c3p0 Java Database Pooling, failover configuration</a>
  <a href="https://docs.genesys.com/Documentation/Composer/8.1.4/Help/ConnectionPooling" rel="noreferrer">https://docs.genesys.com/Documentation/Composer/8.1.4/Help/ConnectionPooling</a></p>
  
  <p>application.properties:( error is coming)</p>
  
  <pre><code>#      connection properties for data source
  ##########################################################################################################
  spring.datasource.c3p0.driverClass=oracle.jdbc.driver.OracleDriver
  spring.datasource.c3p0.maxConnectionAge=3600
  spring.datasource.c3p0.maxIdleTime=600
  spring.datasource.c3p0.initialPoolSize=5
  spring.datasource.c3p0.maxPoolSize=10
  spring.datasource.c3p0.minPoolSize=5
  spring.datasource.c3p0.acquireIncrement=1
  
  ##########################################################################################################
  
  
  spring.datasource.url=jdbc:oracle:thin:@primary.com:1521:db1,jdbc:oracle:thin:@secondary.com:1521:db2
  spring.datasource.username=user
  spring.datasource.password=password
  </code></pre>