Metacat

           // get attribures return

           double startGetAttribute = System.currentTimeMillis()/1000;

           docListResult = getAttributeValueForReturn(qspec,

                           docListResult, doclist.toString(), useXMLIndex);

           double endGetAttribute = System.currentTimeMillis()/1000;

           logMetacat.warn(

                   "Time to get attribute return value after"

                   + " execute extended query: "

                   + (endGetAttribute - startGetAttribute));

           MetaCatUtil.writeDebugToFile(

                   "Get attribute return field "

                   + (endGetAttribute - startGetAttribute));

           MetaCatUtil.writeDebugToDelimiteredFile(" "+ (endGetAttribute - startGetAttribute), false);

    /*

     * A method to return search result after running a query which return

     * field have attribue

     */

    private ResultDocumentSet getAttributeValueForReturn(QuerySpecification squery,

            ResultDocumentSet docInformationList, String docList, boolean useXMLIndex)

    {

        StringBuffer XML = null;

        String sql = null;

        DBConnection dbconn = null;

        PreparedStatement pstmt = null;

        ResultSet rs = null;

        int serialNumber = -1;

        boolean tableHasRows = false;

        //check the parameter

        if (squery == null || docList == null || docList.length() < 0) { return docInformationList; }

        // if has attribute as return field

        if (squery.containsAttributeReturnField()) {

            sql = squery.printAttributeQuery(docList, useXMLIndex);

            try {

                dbconn = DBConnectionPool

                        .getDBConnection("DBQuery.getAttributeValue");

                serialNumber = dbconn.getCheckOutSerialNumber();

                pstmt = dbconn.prepareStatement(sql);

                pstmt.execute();

                rs = pstmt.getResultSet();

                tableHasRows = rs.next();

                while (tableHasRows) {

                    String docid = rs.getString(1).trim();

                    String fieldname = rs.getString(2);

                    String fielddata = rs.getString(3);

                    String attirbuteName = rs.getString(4);

                    XML = new StringBuffer();

                    XML.append("<param name=\"");

                    XML.append(fieldname);

                    XML.append("/");

                    XML.append(QuerySpecification.ATTRIBUTESYMBOL);

                    XML.append(attirbuteName);

                    XML.append("\">");

                    XML.append(fielddata);

                    XML.append("</param>");

                    tableHasRows = rs.next();

                    if (docInformationList.containsDocid(docid)) {

                        String removedelement = (String) docInformationList

                                .remove(docid);

                        docInformationList.put(docid, removedelement

                                + XML.toString());

                    } else {

                        docInformationList.put(docid, XML.toString());

                    }

                }//while

                rs.close();

                pstmt.close();

            } catch (Exception se) {

                logMetacat.error(

                        "Error in DBQuery.getAttributeValue1: "

                                + se.getMessage());

            } finally {

                try {

                    pstmt.close();

                }//try

                catch (SQLException sqlE) {

                    logMetacat.error(

                            "Error in DBQuery.getAttributeValue2: "

                                    + sqlE.getMessage());

                }//catch

                finally {

                    DBConnectionPool.returnDBConnection(dbconn, serialNumber);

                }//finally

            }//finally

        }//if

        return docInformationList;

    }