 | 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 Louis Personal Mail
Back
in the J2EE world, AT of database transactions may not truly be what is
desired... are they after a true Business Functional Trail? If so, there
are many ways of implementing an ATC for Business Transactions (including
dynamic XML databases!!!)
-- -- Original Message -- --
From: "Mart??n Cabrera" <martin.cabrera@(protected)>
To: <J2EEPATTERNS-INTEREST@(protected)>
Sent: Monday, March 28, 2005 2:10 PM
Subject: Re: Audit Trail Logging for J2EE System
> 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)
>
====================================================================
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)
|
|
|
