Metacat

        //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 rev = 0;

      double startTime = 0;

      int offset = 1;

      ResultSet rs = null;

      offset = 1;

      rs = pstmt.executeQuery();

      double queryExecuteTime = System.currentTimeMillis() / 1000;

                    + (queryExecuteTime - startTime));

      boolean tableHasRows = rs.next();

            npstmt.execute();

            ResultSet btrs = npstmt.getResultSet();

            boolean hasBtRows = btrs.next();

            while (hasBtRows)

            {

               //there was a backtrackable document found

                if (docid_org == null)

                {

                   logMetacat.info("Docid_org was null.");

                }

                docid = docid_org.trim();

                docname = xmldoc.getDocname();

                doctype = xmldoc.getDoctype();

                createDate = xmldoc.getCreateDate();

                docListResult.addResultDocument(

                  new ResultDocument(docid, (String) document.toString()));

                currentIndex++;

                logMetacat.warn("$$$$$$$real result: " + docid);

                count++;

     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

                                       DBConnection dbconn, boolean useXMLIndex)

                                       throws Exception

   {

     // check if there is a record in xml_returnfield

     // and get the returnfield_id and usage count

     int usage_count = getXmlReturnfieldsTableId(qspec, dbconn);

     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>";

         }

         resultset.append(xmlElement);

     }//while

     return resultset;

 }

        if (doclist.length() > 0)

        {

          Hashtable controlPairs = new Hashtable();

          doclist.deleteCharAt(doclist.length() - 1); //remove the last comma

          boolean tableHasRows = false;

          // check if user has permission to see the return field data

            tableHasRows = rs.next();

          }*/

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

           String extendedQuery =

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

           logMetacat.info("Extended query: " + extendedQuery);

           if(extendedQuery != null){

               pstmt = dbconn.prepareStatement(extendedQuery);

               //increase dbconnection usage count

               dbconn.increaseUsageCount(1);

               pstmt.execute();

               rs = pstmt.getResultSet();

               double extendedQueryEnd = System.currentTimeMillis() / 1000;

                   + (extendedQueryEnd - extendedQueryStart));

               tableHasRows = rs.next();

               while (tableHasRows) {

               } //while

               double docListResultEnd = System.currentTimeMillis() / 1000;

               logMetacat.warn(

                   + " execute extended query: "

                   + (docListResultEnd - extendedQueryEnd));

           }

           // get attribures return

           docListResult = getAttributeValueForReturn(qspec,

                           docListResult, doclist.toString(), useXMLIndex);

       }//if doclist lenght is great than zero

     }//if has extended query

      pstmt.close();

    }//while

    double endRelation = System.currentTimeMillis() / 1000;

                             + (endRelation - startRelation));

    return docListResult;