001: /* ====================================================================
002: * The Jcorporate Apache Style Software License, Version 1.2 05-07-2002
003: *
004: * Copyright (c) 1995-2002 Jcorporate Ltd. All rights reserved.
005: *
006: * Redistribution and use in source and binary forms, with or without
007: * modification, are permitted provided that the following conditions
008: * are met:
009: *
010: * 1. Redistributions of source code must retain the above copyright
011: * notice, this list of conditions and the following disclaimer.
012: *
013: * 2. Redistributions in binary form must reproduce the above copyright
014: * notice, this list of conditions and the following disclaimer in
015: * the documentation and/or other materials provided with the
016: * distribution.
017: *
018: * 3. The end-user documentation included with the redistribution,
019: * if any, must include the following acknowledgment:
020: * "This product includes software developed by Jcorporate Ltd.
021: * (http://www.jcorporate.com/)."
022: * Alternately, this acknowledgment may appear in the software itself,
023: * if and wherever such third-party acknowledgments normally appear.
024: *
025: * 4. "Jcorporate" and product names such as "Expresso" must
026: * not be used to endorse or promote products derived from this
027: * software without prior written permission. For written permission,
028: * please contact info@jcorporate.com.
029: *
030: * 5. Products derived from this software may not be called "Expresso",
031: * or other Jcorporate product names; nor may "Expresso" or other
032: * Jcorporate product names appear in their name, without prior
033: * written permission of Jcorporate Ltd.
034: *
035: * 6. No product derived from this software may compete in the same
036: * market space, i.e. framework, without prior written permission
037: * of Jcorporate Ltd. For written permission, please contact
038: * partners@jcorporate.com.
039: *
040: * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
041: * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
042: * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
043: * DISCLAIMED. IN NO EVENT SHALL JCORPORATE LTD OR ITS CONTRIBUTORS
044: * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
045: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
046: * TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
047: * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
048: * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
049: * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
050: * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
051: * SUCH DAMAGE.
052: * ====================================================================
053: *
054: * This software consists of voluntary contributions made by many
055: * individuals on behalf of the Jcorporate Ltd. Contributions back
056: * to the project(s) are encouraged when you make modifications.
057: * Please send them to support@jcorporate.com. For more information
058: * on Jcorporate Ltd. and its products, please see
059: * <http://www.jcorporate.com/>.
060: *
061: * Portions of this software are based upon other open source
062: * products and are subject to their respective licenses.
063: */
064: package com.jcorporate.expresso.core.dbobj;
065:
066: import com.jcorporate.expresso.core.db.DBConnection;
067: import com.jcorporate.expresso.core.db.DBException;
068: import com.jcorporate.expresso.ext.dbobj.AuditLog;
069:
070: /**
071: * AuditedSecuredDBObject is an extension of SecuredDBObject that always writes
072: * an audit entry to the AuditLog table. The AuditLog table tracks who made the change,
073: * when, to what object. AuditedSecuredDBObject's MUST have a field named AUDITLOG_ID
074: * for these objects to work properly.
075: *
076: * @author Adam Rossi, PlatinumSolutions
077: * <p/>
078: * Modify by Yves Henri AMAIZO <amy_amaizo@compuserve.com>
079: * @since $DatabaseSchema $Date: 2004/11/18 02:03:27 $
080: */
081: public class AuditedSecuredDBObject extends SecuredDBObject {
082:
083: /**
084: * Constructor
085: *
086: * @throws DBException if the object cannot be created.
087: */
088: public AuditedSecuredDBObject() throws DBException {
089: super ();
090: }
091:
092: /**
093: * AuditedSecuredDBObject Constructor Constructor.
094: *
095: * @param theConnection Database connection to communicate with the
096: * database
097: * @throws DBException If the new object cannot be created
098: */
099: public AuditedSecuredDBObject(DBConnection theConnection)
100: throws DBException {
101: super (theConnection);
102: }
103:
104: /* Address(DBConnection) */
105:
106: /**
107: * The add method writes an entry to the AuditLog with the ADD code.
108: *
109: * @throws DBException Upon error
110: * <p/>
111: * Modify by Yves Henri AMAIZO <amy_amaizo@compuserve.com>
112: * @since $DatabaseSchema $Date: 2004/11/18 02:03:27 $
113: */
114: public synchronized void add() throws DBException {
115: AuditLog auditLog = new AuditLog();
116: auditLog.setField("AUDITLOG_CODE", "ADD");
117: auditLog.setField("EXPUID", "" + this .getRequestingUid());
118: com.jcorporate.expresso.core.dataobjects.jdbc.JDBCObjectMetaData metadata = this
119: .getJDBCMetaData();
120: auditLog.setField("AUDITLOG_DES", metadata.getDescription()
121: + " (Table: "
122: + metadata.getTargetSQLTable(this .getDataContext())
123: + ")");
124: auditLog.add();
125: this .setField("AUDITLOG_ID", auditLog.getField("AUDITLOG_ID"));
126: super .add();
127: }
128:
129: /**
130: * The Delete method first writes an entry to the AuditLog table, then
131: * deletes the object.
132: *
133: * @throws DBException upon error
134: * <p/>
135: * Modify by Yves Henri AMAIZO <amy_amaizo@compuserve.com>
136: * @since $DatabaseSchema $Date: 2004/11/18 02:03:27 $
137: */
138: public synchronized void delete() throws DBException {
139: AuditLog auditLog = new AuditLog();
140: auditLog.setField("AUDITLOG_CODE", "DEL");
141: auditLog.setField("EXPUID", "" + this .getRequestingUid());
142: com.jcorporate.expresso.core.dataobjects.jdbc.JDBCObjectMetaData metadata = this
143: .getJDBCMetaData();
144: auditLog.setField("AUDITLOG_DES", metadata.getDescription()
145: + " (Table: "
146: + metadata.getTargetSQLTable(this .getDataContext())
147: + ")");
148: auditLog.add();
149: this .setField("AUDITLOG_ID", auditLog.getField("AUDITLOG_ID"));
150: super .delete();
151: }
152:
153: /**
154: * The update method first writes an entry to the AuditLog, then updates
155: * the DBObject.
156: *
157: * @throws DBException Upon error
158: * <p/>
159: * Modify by Yves Henri AMAIZO <amy_amaizo@compuserve.com>
160: * @since $DatabaseSchema $Date: 2004/11/18 02:03:27 $
161: */
162: public synchronized void update() throws DBException {
163: AuditLog auditLog = new AuditLog();
164: auditLog.setField("AUDITLOG_CODE", "UPT");
165: auditLog.setField("EXPUID", "" + this .getRequestingUid());
166: com.jcorporate.expresso.core.dataobjects.jdbc.JDBCObjectMetaData metadata = this
167: .getJDBCMetaData();
168: auditLog.setField("AUDITLOG_DES", metadata.getDescription()
169: + " (Table: "
170: + metadata.getTargetSQLTable(this .getDataContext())
171: + ")");
172: auditLog.add();
173: this .setField("AUDITLOG_ID", auditLog.getField("AUDITLOG_ID"));
174: super.update();
175: }
176: }
|