Metacat

      else

      {

        //knb format, in this case we will get whole result and sent it out

        PrintWriter nonout = null;

        StringBuffer xml = createResultDocument(xmlquery, qspec, nonout, user,

                                                groups, useXMLIndex, pagesize, 

        //transfer the xml to html

        try

        {

         DBTransform trans = new DBTransform();

         response.setContentType("text/html");

         trans.transformXMLDocument(xml.toString(), "-//NCEAS//resultset//EN",

                                 "-//W3C//HTML//EN", qformat, out, params,

                                 sessionid);

        }

        catch(Exception e)

        {

                                      int pagesize, int pagestart, String sessionid)

                                      throws Exception

    {

      String query = null;

      int count = 0;

      int index = 0;

      rs = pstmt.executeQuery();

      double queryExecuteTime = System.currentTimeMillis() / 1000;

                    + (queryExecuteTime - startTime));

      boolean tableHasRows = rs.next();

             && !qspec.isPercentageSearch())

         {

           logMetacat.warn("Back tracing now...");

           String sep = MetaCatUtil.getOption("accNumSeparator");

           StringBuffer btBuf = new StringBuffer();

           btBuf.append("select docid from xml_relation where ");

              }//while

              npstmt.close();

              btrs.close();

        }

        else if (returndocVec.size() == 0 || returndocVec.contains(doctype))

        {

     rs.close();

     pstmt.close();

     //if docListResult is not empty, it need to be sent.

     if (docListResult.size() != 0)

     {

       handleSubsetResult(qspec,resultsetBuffer, out, docListResult,

                              user, groups,dbconn, useXMLIndex);

     }

     return resultsetBuffer;

    }//findReturnDoclist

     // check if there is a record in xml_returnfield

     // and get the returnfield_id and usage count

     int usage_count = getXmlReturnfieldsTableId(qspec, dbconn);

     boolean enterRecords = false;

     if(usage_count > count){

         enterRecords = true;

     }

     if(returnfield_id < 0){

         logMetacat.warn("Error in getting returnfield id from"

                                  + "xml_returnfield table");

     logMetacat.info("size of partOfDoclist before"

                             + " docidsInQueryresultTable(): "

                             + partOfDoclist.size());

     Hashtable queryresultDocList = docidsInQueryresultTable(returnfield_id,

                                                        partOfDoclist, dbconn);

     while (_keys.hasMoreElements()){

         partOfDoclist.remove((String)_keys.nextElement());

     }

     // backup the keys-elements in partOfDoclist to check later

     // if the doc entry is indexed yet

     Hashtable partOfDoclistBackup = new Hashtable();

     //add return fields for the documents in partOfDoclist

     partOfDoclist = addReturnfield(partOfDoclist, qspec, user, groups,

                                        dbconn, useXMLIndex);

     //add relationship part part docid list for the documents in partOfDocList

     partOfDoclist = addRelationship(partOfDoclist, qspec, dbconn, useXMLIndex);

     Iterator keys = partOfDoclist.getDocids();

     String key = null;

     String element = null;

             pstmt.execute();

             pstmt.close();

         }

         // A string with element

         String xmlElement = "  <document>" + element + "</document>";

         //send single element to output

         if (out != null)

         {

            tableHasRows = rs.next();

          }*/

           logMetacat.info( "Time for execute access extended query: "

           String extendedQuery =

               qspec.printExtendedSQL(doclist.toString(), useXMLIndex);

    StringBuffer document = null;

    double startRelation = System.currentTimeMillis() / 1000;

    Iterator docidkeys = docListResult.getDocids();

    while (docidkeys.hasNext())

    {

      //String connstring =

      // "metacat://"+util.getOption("server")+"?docid=";

      String connstring = "%docid=";

      String docidkey = (String) docidkeys.next();

      pstmt = dbconn.prepareStatement(QuerySpecification

                      .printRelationSQL(docidkey));

      pstmt.execute();

      pstmt.close();

    }//while

    double endRelation = System.currentTimeMillis() / 1000;

                             + (endRelation - startRelation));

    return docListResult;