Metacat

          // write relative online data file into xml_access too.

          for (int i= 0; i<onlineDataFileIdVector.size(); i++)

          {

            String id = (String)onlineDataFileIdVector.elementAt(i);

            writeAccessRuleForRalatedDataFileIntoDB(accessSectionObj, id);

          }

            // write accessobject into db

            writeGivenAccessRuleIntoDB(accessObj, top, subSectionId);

            // add access rule for related on line data id too.

            for (int j= 0; j<onlineDataFileIdVector.size(); j++)

            {

              String id = (String)onlineDataFileIdVector.elementAt(j);

              writeAccessRuleForRalatedDataFileIntoDB(accessObj, id);

            }

    /* Write a gaven access rule into db*/

  private void writeAccessRuleForRalatedDataFileIntoDB

                  (AccessSection accessSection, String dataId) 

                                         throws SAXException

  {

      if (accessSection == null)

      {

        throw new SAXException("The access object is null");

      }

      // get rid of rev from dataId

      dataId = MetaCatUtil.getDocIdFromString(dataId);

      String permOrder = accessSection.getPermissionOrder();

      String sql = null;

      PreparedStatement pstmt = null;

      sql = "INSERT INTO xml_access (docid, principal_name, permission, "+

                 "perm_type, perm_order, accessfileid) VALUES " +

                 " (?, ?, ?, ?, ?, ?)";

      try 

      {

        pstmt = connection.prepareStatement(sql);

        // Increase DBConnection usage count

        connection.increaseUsageCount(1);

        // Bind the values to the query

        pstmt.setString(1, dataId);

        MetaCatUtil.debugMessage("Docid in accesstable: "+ docid, 35);

        pstmt.setString(6, docid);

        MetaCatUtil.debugMessage("Accessfileid in accesstable: "+ docid, 35);

        pstmt.setString(5, permOrder);

        MetaCatUtil.debugMessage("PermOder in accesstable: "+ permOrder, 35);

        // if it is not top level, set subsection id

        Vector accessRules = accessSection.getAccessRules();

        // go through every rule

        for (int i=0; i<accessRules.size(); i++)

        {

          AccessRule rule = (AccessRule)accessRules.elementAt(i);

          String permType = rule.getPermissionType();

          int permission = rule.getPermission();

          pstmt.setInt(3, permission);

          MetaCatUtil.debugMessage("permission in accesstable: "+ permission, 35);

          pstmt.setString(4, permType);

          MetaCatUtil.debugMessage("Permtype in accesstable: "+ permType, 35);

          // go through every principle in rule

          Vector nameVector = rule.getPrincipal();

          for ( int j = 0; j < nameVector.size(); j++ ) 

          {

            String prName = (String)nameVector.elementAt(j);

            pstmt.setString(2, prName);

            MetaCatUtil.debugMessage("Principal in accesstable: "+prName, 35);

            pstmt.execute();

          }//for

        }//for

        pstmt.close();

      }//try 

      catch (SQLException e) 

      {

        throw new 

        SAXException("EMLSAXHandler.writeAccessRuletoDB(): " + e.getMessage());

      }//catch

      finally

      {

        try

        {

          pstmt.close();

        }

        catch(SQLException ee)

        {

          throw new 

          SAXException("EMLSAXHandler.writeAccessRuletoDB(): " + 

          ee.getMessage());

        }

      }//finally

  }//writeAccessRuleForRalatedDataFileIntoDB