 | 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 Mart?n Cabrera
Back
What j2ee technologies are you using?
-- --Mensaje original-- --
De: An interest list for Sun Java Center J2EE Pattern Catalog
[mailto:J2EEPATTERNS-INTEREST@(protected)] En nombre de Juan Manuel
Gonzalez
Enviado el: lunes, 28 de marzo de 2005 15:40
Para: J2EEPATTERNS-INTEREST@(protected)
Asunto: Audit Trail Logging for J2EE System
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/pattern
> s/
> 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/pattern
> s/
> 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)
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.4 - Release Date: 27/03/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.4 - Release Date: 27/03/2005
====================================================================
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)
|
|
|
