ojdbc14.jar

Classes needed:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.DatabaseMetaData;

Strings necessary for connection:

   private static String _oracleUrl = "jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = atlarc1-v.cern.ch)(PORT = 10121))(ADDRESS = (PROTOCOL = TCP)(HOST = atlarc2-v.cern.ch)(PORT = 10121))(ADDRESS = (PROTOCOL = TCP)(HOST = atlarc3-v.cern.ch)(PORT = 10121))(LOAD_BALANCE =yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = atlas_tagsprod.cern.ch)))";
   private static String _oracleId  = "atlas_tags_reader";
   private static String _oraclePwd = "";

• Print Out ATLAS_TAGS_METADATA and ATLAS_TAGS_CATALOG

public static void exampleOracleTrig() throws Exception {   
   
    // Oracle connection
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection con = DriverManager.getConnection(_oracleUrl, _oracleId, _oraclePwd);

    Statement state = con.createStatement();
    ResultSet rs;
   
   String table_name;
      rs = state.executeQuery("select TABLE_NAME from ALL_TABLES WHERE OWNER = 'ATLAS_TAGS_METADATA'");
   System.out.println("TABLE_NAME (owner ATLAS_TAGS_METADATA):");
    while (rs.next()) {
      table_name=rs.getString(1);
      System.out.println("\t" + table_name);
   }

    rs = state.executeQuery("select TABLE_NAME from ALL_TABLES WHERE OWNER = 'ATLAS_TAGS_CATALOG'");
   System.out.println("TABLE_NAME (owner ATLAS_TAGS_CATALOG):");
    while (rs.next()) {
      table_name=rs.getString(1);
      System.out.println("\t" + table_name);
   }      
   
    con.close();
    } 

Usage:

new TrigOracleReader().exampleOracleTrig();

• list EF Trigger bits and corresponding Chain Naimes for specific Run

public static void getTrigRun(long Run) throws Exception {
   
     // Oracle connection
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection con = DriverManager.getConnection(_oracleUrl, _oracleId, _oraclePwd);

    Statement state = con.createStatement();
    ResultSet rs;

    String run_index;
    String chain_counter;
    String chain_name;

    rs = state.executeQuery("select RUN_INDEX, CHAIN_COUNTER, CHAIN_NAME "
     + "from ATLAS_TAGS_METADATA.COMA_RUNS CR, ATLAS_TAGS_METADATA.COMA_MK_TRIGGERS CMKT " 
     + "where CR.TRIGKEY_INDEX = CMKT.TRIGKEY_INDEX AND CR.RUN_INDEX = " + Run + " AND TRIGGER_LEVEL = 3");
   System.out.println("CHAIN_COUNTER, CHAIN_NAME (RUN: " + Run + ") :");
    while (rs.next()) {
        run_index=rs.getString(1);
        chain_counter=rs.getString(2);
        chain_name=rs.getString(3);
      
        System.out.println(chain_counter + ": \t" + chain_name);
        }

    con.close();
    } 

Usage:

new TrigOracleReader().getTrigRun(182008);

-- FedorProkoshin - 14 Feb 2014