 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | Audit Trail Logging for J2EE System | Audit Trail Logging for J2EE System 2005-03-28 - By Ricardo de Souza Moura
Back
If I got it, you need to audit when a actor execute a update or insert
instructios, isn't it ?
Despites triggers, I can see two ways... using AOP or SNAPSHOT Logs in the
BD
I hope it help you
>From: Juan Manuel Gonzalez <jmgonzalez@(protected)>
>Reply-To: An interest list for Sun Java Center J2EE Pattern Catalog
><J2EEPATTERNS-INTEREST@(protected)>
>To: J2EEPATTERNS-INTEREST@(protected)
>Subject: Audit Trail Logging for J2EE System
>Date: Mon, 28 Mar 2005 15:40:27 -0300
>
>I'm looking for a solution of audit tail implementing a
>Pattern, unfortunately our customer do not allow us to use ON INSERT /
>UPDATE
>triggers.
>
>I would be interested to hear your ideas and
>experience.
>
>Cheers,
>
>John.
>
>
>
>
>
>Date:
> Tue, 3 Dec 2002 15:33:45
>GMT
>
>Reply-To: ben@(protected)
>
>Sender: An
>interest list for Sun Java Center J2EE Pattern Catalog
>
>
><J2EEPATTERNS-INTEREST@(protected)>
>
>From:
> Ben Hill <ben@(protected)>
>
>Subject: Re:
>Audit Trail Logging for J2EE System
>
>Content-Type: text/plain; charset=iso-8859 (See http://iso-8859.ora-code.com)-1
>
>
>
>Yeah, the user ID part is the funny bit, as we connect to the DB via our
>
>Entity Bean's CMP mechanism...
>
>
>
>Thanks for your ideas!
>
>
>
>Cheers,
>
>
>
>Ben
>
>
>
>>How about using ON INSERT / UPDATE triggers to capture audit records?
>
> They
>
>>are pretty simple to write.
>
>>
>
>>The only technical feasibility issue I see is capturing the "appserver
>
>>userid".... because this usually isn't the same as the "database userid"
>
>>(which is usually a generic "server" id). One way I can think of getting
>
>>this info (using Oracle) is to have a stored procedure set the appserver
>
>>userid as "package" variable (which is database session/connection
>
>>specific). You'll have to call a "set_user" procedure at the beginning of
>
>>each EJB invocation to store the appserver userid into the database
>
>>session, but that's not a large price to pay. (I'm hoping others can
>
>>think of better solutions to this problem.)
>
>>
>
>>-eric
>
>>
>
>>
>
>>
>
>>
>
>>
>
>> Ben Hill
>
>> <ben@(protected)> To:
>
>J2EEPATTERNS-INTEREST@(protected)
>
>> Sent by: An interest cc:
>
>> list for Sun Java Subject: Audit Trail
>
>Logging for J2EE System
>
>> Center J2EE Pattern
>
>> Catalog
>
>> <J2EEPATTERNS-INTEREST
>
>> @(protected)>
>
>>
>
>>
>
>> 12/03/2002 08:47 AM
>
>> Please respond to ben
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>I have been asked to look into providing an audit trail to log any
>
>>creates, updates and deletes in a system's database.
>
>>
>
>>The system is a J2EE app based on WebLogic Server and uses Session EJBs
>
>>and Entity EJBs using CMP to connect to Oracle 9i. At the moment, the
>
>>system does not pass any details of the user to the DB when updating etc.
>
>>
>
>>I would be interested to hear from anyone who has implemented such a
>
>>system, as I have been asked to look into this and estimate the amount
>
>>of work involved.
>
>>
>
>>To be honest I am a little perturbed about the amount of logging the
>
>>client wants to have, but I might be able to give them a bit more
>
>>feedback rather than just; "18 months development time".
>
>>
>
>>Cheers,
>
>>
>
>>Ben
>
>>
>
>>--
>
>>ben@(protected)
>
>>www.javacoder.net/~ben
>
>>
>
>>www.javacoder.net - "Java coding, from the source"
>
>>
>
>>====================================================================
>
>>Community Web Site (Core J2EE Patterns Catalog - Online Version):
>
>> http://java.sun.com/blueprints/corej2eepatterns
>
>>Getting Started (Beta Version):
>
>> http://developer.java.sun.com/developer/technicalArticles/J2EE/patterns/
>
>>Get the book:
>
>> http://www.amazon.com/exec/obidos/ASIN/0130648841/corej2eepatte-20 (See http://tte-20.ora-code.com)
>
>>List Archive:
>
>> http://archives.java.sun.com/archives/j2eepatterns-interest.html
>
>>Unsubscribing:
>
>> email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
>
>>
>
>>====================================================================
>
>>Community Web Site (Core J2EE Patterns Catalog - Online Version):
>
>> http://java.sun.com/blueprints/corej2eepatterns
>
>>Getting Started (Beta Version):
>
>> http://developer.java.sun.com/developer/technicalArticles/J2EE/patterns/
>
>>Get the book:
>
>> http://www.amazon.com/exec/obidos/ASIN/0130648841/corej2eepatte-20 (See http://tte-20.ora-code.com)
>
>>List Archive:
>
>> http://archives.java.sun.com/archives/j2eepatterns-interest.html
>
>>Unsubscribing:
>
>> email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
>
>>
>
>>
>
>
>
>--
>
>ben@(protected)
>
>www.javacoder.net/~ben
>
>
>
>www.javacoder.net - "Java coding, from the source"
>
>
>
>====================================================================
>
>Community Web Site (Core J2EE Patterns Catalog - Online Version):
>
> http://java.sun.com/blueprints/corej2eepatterns
>
>Getting Started (Beta Version):
>
> http://developer.java.sun.com/developer/technicalArticles/J2EE/patterns/
>
>Get the book:
>
> http://www.amazon.com/exec/obidos/ASIN/0130648841/corej2eepatte-20 (See http://tte-20.ora-code.com)
>
>List Archive:
>
> http://archives.java.sun.com/archives/j2eepatterns-interest.html
>
>Unsubscribing:
>
> email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
>
>Back to: Top of message | Previous page | Main J2EEPATTERNS-INTEREST page
>
>====================================================================
>Companion Site: http://www.corej2eepatterns.com
>J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
>List Archive:
>http://archives.java.sun.com/archives/j2eepatterns-interest.html
>Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
>listserv@(protected)
====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
|
|
|
