protected NamedParameterJdbcTemplate getValidateJdbcTemplate(Object params) {
   DataSource targetDataSource = DataSourceContext.getDataSource();
   DataSource routeDataSource = routeDataSource(routeConfigDefault, params);
   if (targetDataSource == null) {
     return new NamedParameterJdbcTemplate(routeDataSource);
   }
   if (!targetDataSource.equals(routeDataSource) && routeDataSource != null) {
     throw new RuntimeException(
         "Could not operate different DataSouce["
             + targetDataSource
             + ", "
             + routeDataSource
             + "]");
   }
   return new NamedParameterJdbcTemplate(targetDataSource);
 }
Exemplo n.º 2
0
  private Integer getFoo(DataSource ds) throws Exception {
    Connection c = null;
    Statement s = null;
    Integer value = null;
    try {
      c = ds.getConnection();
      s = c.createStatement();
      String tablename = (ds.equals(myDS) ? TABLE1 : TABLE2);
      ResultSet results = s.executeQuery("select foo from " + tablename + " where id=1");
      if (results.next()) value = new Integer(results.getInt(1));

      results.close();

      return value;
    } finally {
      if (s != null) s.close();
      if (c != null) c.close();
    }
  }