Metacat

   /**

   * Method to get a host server information for given docid

   * @param conn a connection to the database

   */

  public static Hashtable getHomeServer(String docId)

  {

    Hashtable sl = new Hashtable();

    Connection conn = null;

    MetaCatUtil ut=new MetaCatUtil();

    PreparedStatement pstmt=null;

    int serverLocation;

    try

    {

      conn=ut.getConnection();

      //get a server location from xml_document table

      pstmt = conn.prepareStatement("select server_location where docid = ?");

      pstmt.setString(1, docId);

      pstmt.execute();

      ResultSet serverName = pstmt.getResultSet();

      //get a server location

      if(serverName.next())

      {

        serverLocation=serverName.getInt(1);

        pstmt.close();

      }

      else

      {

        pstmt.close();

        ut.returnConnection(conn);

        return null;

      }

      pstmt = conn.prepareStatement("select server, last_checked, replicate " +

                        "from xml_replication where serverid = ?");

      pstmt.setInt(1, serverLocation);

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean tableHasRows = rs.next();

      if (tableHasRows)

      {

          String server = rs.getString(1);

          String last_checked = rs.getString(2);

          if(!server.equals("localhost"))

          {

            sl.put(server, last_checked);

          }

      }

      else

      {

        pstmt.close();

        ut.returnConnection(conn);

        return null;

      }

      pstmt.close();

    }

    catch(Exception e)

    {

      System.out.println("error in replicationHandler.buildServerList(): " +

                         e.getMessage());

    }

    finally

    {

      try

      {

        pstmt.close();

        ut.returnConnection(conn);

      }

      catch (Exception ee)

      {

      }

    }

    return sl;

  }

   * Returns a server location  given a accnum

   * @param accNum , given accNum for a document

   * 

   */

  public static int getServerLocation(String accNum) throws Exception

  {

    Connection conn = null;

    PreparedStatement pstmt = null;

    int serverCode = 1;

    MetaCatUtil ut = new MetaCatUtil();

    String docId=ut.getDocIdFromString(accNum);

    try 

    {

      conn = ut.openDBConnection();

      pstmt = conn.prepareStatement("SELECT server_location FROM xml_documents " 

                              + "WHERE docid LIKE '" + docId + "'");

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean tablehasrows = rs.next();

      //If a document is find, return the server location for it

      if ( tablehasrows ) 

      {  

        serverCode = rs.getInt(1);

        pstmt.close();

        ut.returnConnection(conn);

        return serverCode;

      }

      //if couldn't find in xml_documents table, we think server code is 1

      //(this is new document)

      else

      {

        pstmt.close();

        ut.returnConnection(conn);

        return serverCode;

      }

    } 

    catch(Exception e) 

    {

      throw e;

    } 

    finally 

    {

      try 

      {

        pstmt.close();

        ut.returnConnection(conn);

        return serverCode;

      } 

      catch(Exception ee) 

      {

      }

    }//finally

  }

  /**