package org.apache.jetspeed.om.apps.email;import java.math.BigDecimal;import java.sql.Connection;import java.sql.SQLException;import java.util.ArrayList;import java.util.Date;import java.util.Iterator;import java.util.LinkedList;import java.util.List;import org.apache.torque.NoRowsException;import org.apache.torque.TooManyRowsException;import org.apache.torque.Torque;import org.apache.torque.TorqueException;import org.apache.torque.map.MapBuilder;import org.apache.torque.map.TableMap;import org.apache.torque.om.DateKey;import org.apache.torque.om.NumberKey;import org.apache.torque.om.StringKey;import org.apache.torque.om.ObjectKey;import org.apache.torque.om.SimpleKey;import org.apache.torque.util.BasePeer;import org.apache.torque.util.Criteria;import com.workingdogs.village.DataSetException;import com.workingdogs.village.QueryDataSet;import com.workingdogs.village.Record;// Local classesimport org.apache.jetspeed.om.apps.email.map.*;/** * This class was autogenerated by Torque on: * * [Thu Apr 22 15:30:48 PDT 2004] * */public abstract class BaseEmailInboxPeer    extends BasePeer{    /** the default database name for this class */    public static final String DATABASE_NAME = "default";     /** the table name for this class */    public static final String TABLE_NAME = "EMAIL_INBOX";    /**     * @return the map builder for this peer     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static MapBuilder getMapBuilder()        throws TorqueException    {        return getMapBuilder(EmailInboxMapBuilder.CLASS_NAME);    }      /** the column name for the EMAIL_INBOX_ID field */    public static final String EMAIL_INBOX_ID;      /** the column name for the MESSAGE_ID field */    public static final String MESSAGE_ID;      /** the column name for the FILENAME field */    public static final String FILENAME;      /** the column name for the ATTACHMENT field */    public static final String ATTACHMENT;      /** the column name for the READFLAG field */    public static final String READFLAG;      static    {          EMAIL_INBOX_ID = "EMAIL_INBOX.EMAIL_INBOX_ID";          MESSAGE_ID = "EMAIL_INBOX.MESSAGE_ID";          FILENAME = "EMAIL_INBOX.FILENAME";          ATTACHMENT = "EMAIL_INBOX.ATTACHMENT";          READFLAG = "EMAIL_INBOX.READFLAG";          if (Torque.isInit())        {            try            {                getMapBuilder();            }            catch (Exception e)            {                log.error("Could not initialize Peer", e);            }        }        else        {            Torque.registerMapBuilder(EmailInboxMapBuilder.CLASS_NAME);        }    }     /** number of columns for this peer */    public static final int numColumns =  5;    /** A class that can be returned by this peer. */    protected static final String CLASSNAME_DEFAULT =        "org.apache.jetspeed.om.apps.email.EmailInbox";    /** A class that can be returned by this peer. */    protected static final Class CLASS_DEFAULT = initClass(CLASSNAME_DEFAULT);    /**     * Class object initialization method.     *     * @param className name of the class to initialize     * @return the initialized class     */    private static Class initClass(String className)    {        Class c = null;        try        {            c = Class.forName(className);        }        catch (Throwable t)        {            log.error("A FATAL ERROR has occurred which should not "                + "have happened under any circumstance.  Please notify "                + "the Torque developers <turbine-torque-dev@jakarta.apache.org> "                + "and give as many details as possible (including the error "                + "stack trace).", t);            // Error objects should always be propogated.            if (t instanceof Error)            {                throw (Error) t.fillInStackTrace();            }        }        return c;    }    /**     * Get the list of objects for a ResultSet.  Please not that your     * resultset MUST return columns in the right order.  You can use     * getFieldNames() in BaseObject to get the correct sequence.     *     * @param results the ResultSet     * @return the list of objects     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static List resultSet2Objects(java.sql.ResultSet results)            throws TorqueException    {        try        {            QueryDataSet qds = null;            List rows = null;            try            {                qds = new QueryDataSet(results);                rows = getSelectResults(qds);            }            finally            {                if (qds != null)                {                    qds.close();                }            }            return populateObjects(rows);        }        catch (SQLException e)        {            throw new TorqueException(e);        }        catch (DataSetException e)        {            throw new TorqueException(e);        }    }      /**     * Method to do inserts.     *     * @param criteria object used to create the INSERT statement.     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static ObjectKey doInsert(Criteria criteria)        throws TorqueException    {        return BaseEmailInboxPeer            .doInsert(criteria, (Connection) null);    }    /**     * Method to do inserts.  This method is to be used during a transaction,     * otherwise use the doInsert(Criteria) method.  It will take care of     * the connection details internally.     *     * @param criteria object used to create the INSERT statement.     * @param con the connection to use     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static ObjectKey doInsert(Criteria criteria, Connection con)        throws TorqueException    {                                        // Set the correct dbName if it has not been overridden        // criteria.getDbName will return the same object if not set to        // another value so == check is okay and faster        if (criteria.getDbName() == Torque.getDefaultDB())        {            criteria.setDbName(DATABASE_NAME);        }        if (con == null)        {            return BasePeer.doInsert(criteria);        }        else        {            return BasePeer.doInsert(criteria, con);        }    }    /**     * Add all the columns needed to create a new object.     *     * @param criteria object containing the columns to add.     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static void addSelectColumns(Criteria criteria)            throws TorqueException    {          criteria.addSelectColumn(EMAIL_INBOX_ID);          criteria.addSelectColumn(MESSAGE_ID);          criteria.addSelectColumn(FILENAME);          criteria.addSelectColumn(ATTACHMENT);          criteria.addSelectColumn(READFLAG);      }    /**     * Create a new object of type cls from a resultset row starting     * from a specified offset.  This is done so that you can select     * other rows than just those needed for this object.  You may     * for example want to create two objects from the same row.     *     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static EmailInbox row2Object(Record row,                                             int offset,                                             Class cls)        throws TorqueException    {        try        {            EmailInbox obj = (EmailInbox) cls.newInstance();            EmailInboxPeer.populateObject(row, offset, obj);                  obj.setModified(false);              obj.setNew(false);            return obj;        }        catch (InstantiationException e)        {            throw new TorqueException(e);        }        catch (IllegalAccessException e)        {            throw new TorqueException(e);        }    }    /**     * Populates an object from a resultset row starting     * from a specified offset.  This is done so that you can select     * other rows than just those needed for this object.  You may     * for example want to create two objects from the same row.     *     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static void populateObject(Record row,                                      int offset,                                      EmailInbox obj)        throws TorqueException    {        try        {                obj.setEmailInboxId(row.getValue(offset + 0).asInt());                  obj.setMessageId(row.getValue(offset + 1).asString());                  obj.setFilename(row.getValue(offset + 2).asString());                  obj.setAttachment(row.getValue(offset + 3).asBytes());                  obj.setReadflag(row.getValue(offset + 4).asInt());              }        catch (DataSetException e)        {            throw new TorqueException(e);        }    }    /**     * Method to do selects.     *     * @param criteria object used to create the SELECT statement.     * @return List of selected Objects     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static List doSelect(Criteria criteria) throws TorqueException    {        return populateObjects(doSelectVillageRecords(criteria));    }    /**     * Method to do selects within a transaction.     *     * @param criteria object used to create the SELECT statement.     * @param con the connection to use     * @return List of selected Objects     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static List doSelect(Criteria criteria, Connection con)        throws TorqueException    {        return populateObjects(doSelectVillageRecords(criteria, con));    }    /**     * Grabs the raw Village records to be formed into objects.     * This method handles connections internally.  The Record objects     * returned by this method should be considered readonly.  Do not     * alter the data and call save(), your results may vary, but are     * certainly likely to result in hard to track MT bugs.     *     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static List doSelectVillageRecords(Criteria criteria)        throws TorqueException    {        return BaseEmailInboxPeer            .doSelectVillageRecords(criteria, (Connection) null);    }    /**     * Grabs the raw Village records to be formed into objects.     * This method should be used for transactions     *     * @param con the connection to use     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static List doSelectVillageRecords(Criteria criteria, Connection con)        throws TorqueException    {        if (criteria.getSelectColumns().size() == 0)        {            addSelectColumns(criteria);        }                                        // Set the correct dbName if it has not been overridden        // criteria.getDbName will return the same object if not set to        // another value so == check is okay and faster        if (criteria.getDbName() == Torque.getDefaultDB())        {            criteria.setDbName(DATABASE_NAME);        }        // BasePeer returns a List of Value (Village) arrays.  The array        // order follows the order columns were placed in the Select clause.        if (con == null)        {            return BasePeer.doSelect(criteria);        }        else        {            return BasePeer.doSelect(criteria, con);        }    }    /**     * The returned List will contain objects of the default type or     * objects that inherit from the default.     *     * @throws TorqueException Any exceptions caught during processing will be     *         rethrown wrapped into a TorqueException.     */    public static List populateObjects(List records)        throws TorqueException    {        List results = new ArrayList(records.size());        // populate the object(s)        for (int i = 0; i < records.size(); i++)        {            Record row = (Record) records.get(i);              results.add(EmailInboxPeer.row2Object(row, 1,                EmailInboxPeer.getOMClass()));