Metacat

import javax.servlet.ServletOutputStream;

import javax.servlet.http.HttpServletResponse;

import edu.ucsb.nceas.morpho.datapackage.Triple;

import edu.ucsb.nceas.morpho.datapackage.TripleCollection;

    private MetaCatUtil util = new MetaCatUtil();

    /**

     * the main routine used to test the DBQuery utility.

     * <p>

      // get query and qformat

      String xmlquery = ((String[])params.get("query"))[0];

      String qformat = ((String[])params.get("qformat"))[0];

      // Get the XML query and covert it into a SQL statment

      QuerySpecification qspec = null;

      if ( xmlquery != null)

         }

         catch (Exception ee)

         {

                                    +" in DBQuery.findDocuments"

         }

      }

        }

        catch(Exception e)

        {

         }

      }//else

      } //try

      catch (IOException ioe)

      {

      }

      catch (SQLException e)

      {

      }

      catch (Exception ee)

      {

      }

      finally

      {

      int rev = 0;

      String query = qspec.printSQL(useXMLIndex);

      String ownerQuery = getOwnerQuery(user);

      // if query is not the owner query, we need to check the permission

      // otherwise we don't need (owner has all permission by default)

      if (!query.equals(ownerQuery))

        } else {

            query = query + accessQuery.substring(4, accessQuery.length());

        }

      }

      double startTime = System.currentTimeMillis() / 1000;

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      double queryExecuteTime = System.currentTimeMillis() / 1000;

      boolean tableHasRows = rs.next();

      while (tableHasRows)

      {

         if (returndocVec.size() != 0 && !returndocVec.contains(doctype)

                        && !qspec.isPercentageSearch())

        {

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

           StringBuffer btBuf = new StringBuffer();

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

               //there was a backtrackable document found

               DocumentImpl xmldoc = null;

               String packageDocid = btrs.getString(1);

                try

                {

                    //  THIS CONSTRUCTOR BUILDS THE WHOLE XML doc not

                    xmldoc = new DocumentImpl(accNumber, false);

                    if (xmldoc == null)

                    {

                    }

                }

                catch (Exception e)

                String docid_org = xmldoc.getDocID();

                if (docid_org == null)

                {

                   //continue;

                }

                docid = docid_org.trim();

                              user, groups,dbconn, useXMLIndex);

     }

     double docListTime = System.currentTimeMillis() / 1000;

     return resultsetBuffer;

    }//findReturnDoclist

     }

     if(returnfield_id < 0){

	enterRecords = false;

     }

     // get the hashtable containing the docids that already in the

     // xml_queryresult table

                             + " docidsInQueryresultTable(): "

     Hashtable queryresultDocList = docidsInQueryresultTable(returnfield_id,

                                                        partOfDoclist, dbconn);

         partOfDoclistBackup.put(key, partOfDoclist.get(key));

     }

                             + " docidsInQueryresultTable(): "

     //add return fields for the documents in partOfDoclist

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

             String query = "select docid, queryresult_string from "

                          + "xml_queryresult where returnfield_id = " +

                          returnfield_id +" and docid in ("+ doclist + ")";

             try {

                 // prepare and execute the query

                     if(element != null){

                         returnValue.put(key, element);

                     } else {

                     }

                     tableHasRows = rs.next();

                 }

                 rs.close();

                 pstmt.close();

             } catch (Exception e){

                                          + "queryresult in "

                                          + "DBQuery.docidsInQueryresultTable: "

              }

         }

         return returnValue;

       // query for finding the id from xml_returnfield

       String query = "SELECT returnfield_id, usage_count FROM xml_returnfield "

            + "WHERE returnfield_string LIKE ?";

       try {

           // prepare and run the query

               // increase the usage count

               query = "UPDATE xml_returnfield SET usage_count ='" + count

                   + "' WHERE returnfield_id ='"+ id +"'";

               pstmt = dbconn.prepareStatement(query);

               dbconn.increaseUsageCount(1);

               // insert a new record

               query = "INSERT INTO xml_returnfield (returnfield_string, usage_count)"

                   + "VALUES (?, '1')";

               pstmt = dbconn.prepareStatement(query);

               pstmt.setString(1, returnfield);

               dbconn.increaseUsageCount(1);

               // get the id of the new record

               query = "SELECT returnfield_id FROM xml_returnfield "

                   + "WHERE returnfield_string LIKE ?";

               pstmt = dbconn.prepareStatement(query);

               pstmt.setString(1, returnfield);

           }

       } catch (Exception e){

                                     + "DBQuery.getXmlReturnfieldsTableId: "

           id = -1;

       }

          }

           double extendedAccessQueryEnd = System.currentTimeMillis() / 1000;

           String extendedQuery =

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

           if(extendedQuery != null){

               pstmt = dbconn.prepareStatement(extendedQuery);

               pstmt.execute();

               rs = pstmt.getResultSet();

               double extendedQueryEnd = System.currentTimeMillis() / 1000;

                   "Time for execute extended query: "

               tableHasRows = rs.next();

               while (tableHasRows) {

                   ReturnFieldValue returnValue = new ReturnFieldValue();

                   }

               } //while

               double docListResultEnd = System.currentTimeMillis() / 1000;

                   "Time for prepare doclistresult after"

                   + " execute extended query: "

           }

           // get attribures return

      pstmt.close();

    }//while

    double endRelation = System.currentTimeMillis() / 1000;

    return docListResult;

  }//addRelation

                rs.close();

                pstmt.close();

            } catch (Exception se) {

                        "Error in DBQuery.getAttributeValue1: "

            } finally {

                try {

                    pstmt.close();

                }//try

                catch (SQLException sqlE) {

                            "Error in DBQuery.getAttributeValue2: "

                }//catch

                finally {

                    DBConnectionPool.returnDBConnection(dbconn, serialNumber);

            pStmt.close();

        }//try

        catch (SQLException e) {

        }//catch

        finally {

            try {

                pStmt.close();

            }//try

            catch (SQLException ee) {

                        "Error in getDocidListForDataPackage: "

            }//catch

            finally {

                DBConnectionPool.returnDBConnection(dbConn, serialNumber);

            }//for

        }//try

        catch (Exception e) {

        }//catch

        // return result

            pStmt.close();

        }//try

        catch (SQLException e) {

        } finally {

            try {

                pStmt.close();

            }//try

            catch (SQLException ee) {

            }//catch

            finally {

                DBConnectionPool.returnDBConnection(dbConn, serialNumber);

        }//try

        catch (SQLException e) {

                    "Error in getCurrentRevFromXMLDoumentsTable: "

            throw e;

        }//catch

        finally {

                pStmt.close();

            }//try

            catch (SQLException ee) {

                        "Error in getCurrentRevFromXMLDoumentsTable: "

            }//catch

            finally {

                DBConnectionPool.returnDBConnection(dbConn, serialNumber);

                documentImplList.add(documentImplObject);

            }//try

            catch (Exception e) {

                // continue the for loop

                continue;

            }

                documentImplList.add(documentImplObject);

            }//try

            catch (McdbDocNotFoundException notFoundE) {

                        "Error in DBQuery.getOldVersionAllDocument" + "Imple"

                // Rather than add a DocumentImple object into vetor, a String

                // object

                // - the doicd was added to the vector

                continue;

            }//catch

            catch (Exception e) {

                        "Error in DBQuery.getOldVersionAllDocument" + "Imple"

                // Continue the for loop

                continue;

            }//catch

            zipOut.closeEntry();

        }//try

        catch (IOException ioe) {

        }//catch

    }//addDataFileToZipOutputStream()

                        .equals("class java.lang.String")) {

                    // Get String object from vetor

                    String documentId = (String) documentImplList.elementAt(i);

                    // Get doicd without revision

                    String docidWithoutRevision = MetaCatUtil

                            .getDocIdFromString(documentId);

                    // Get revision

                    String revision = MetaCatUtil

                            .getRevisionStringFromString(documentId);

                    // Zip entry string

                    String zipEntryPath = rootName + "/data/";

                    // Create a RemoteDocument object