Example #1
0
  void initPSID() {
    psSelectCount =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT COUNT(" + RelationalUtil.getAlias("moid") + ") FROM Network"); // No I18N

    psSelectMoID1 =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN(ManagedObject."
                + RelationalUtil.getAlias("name")
                + ") FROM ManagedObject , Network WHERE ManagedObject."
                + RelationalUtil.getAlias("moid")
                + "= Network."
                + RelationalUtil.getAlias("moid")); // No I18N

    psSelectMoID2 =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN(ManagedObject."
                + RelationalUtil.getAlias("name")
                + ") FROM ManagedObject , Network WHERE ManagedObject."
                + RelationalUtil.getAlias("moid")
                + "= Network."
                + RelationalUtil.getAlias("moid")
                + " AND ManagedObject."
                + RelationalUtil.getAlias("name")
                + " >?"); // No I18N
  }
Example #2
0
  private void initPSID() {
    // psForSelectMINOwnerName = agentName.rlAPI.getPreparedStatementID("SELECT MIN(" +
    // RelationalUtil.getAlias("ownerName") + ") FROM Alert");//No I18N

    psForSelectMINSource =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN(" + RelationalUtil.getAlias("source") + ") FROM Alert "); // No I18N

    psForSelectMINEntity =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN("
                + RelationalUtil.getAlias("entity")
                + ") FROM Alert where "
                + RelationalUtil.getAlias("source")
                + "=?"); // No I18N

    psForSelectNEXTOwnerName =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN("
                + RelationalUtil.getAlias("ownerName")
                + ") FROM Alert where "
                + RelationalUtil.getAlias("ownerName")
                + ">?"); // No I18N

    psForSelectNEXTSource =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN("
                + RelationalUtil.getAlias("source")
                + ") FROM Alert where "
                + RelationalUtil.getAlias("source")
                + ">?"); // No I18N

    psForSelectNEXTEntity =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN("
                + RelationalUtil.getAlias("entity")
                + ") FROM Alert where "
                + RelationalUtil.getAlias("source")
                + "=? AND "
                + RelationalUtil.getAlias("entity")
                + ">?"); // No I18N
  }