gistfile1.txt

      OracleDataSource ods = new oracle.jdbc.pool.OracleDataSource();
      ods.setURL(DB_URL);
      ods.setUser(DB_USER);
      ods.setPassword(DB_PASSWORD);
      Properties props = new Properties();
      props.setProperty("oracle.jdbc.useTrueCacheDriverConnection", "true");
      ods.setConnectionProperties(props);
      // this is a True Cache driver connection and it can be used to execute 
      // queries on both the primary database and a True Cache instance
      Connection conn = ods.getConnection();
      Statement stmt = conn.createStatement();
      // Default value of connection read-only flag is false which means 
      // the SQL_QUERY1 is executed on the primary database 
      ResultSet rs = stmt.executeQuery(SQL_QUERY1);
      // set the read-only flag to true, in order to execute SQL_QUERY2 
      // on a True Cache instance
      conn.setReadOnly(true);
      ResultSet rs1 = stmt.executeQuery(SQL_QUERY2);