Hi Mark,
Only SID will not help in case of connection pooling with Java application
servers. We need a mechanism to
1) Log a unique identificaiton per jdbc call. This can be a random number
generated / Starting timestamp in Log4PLSQL context for that call.
2) Currently I am loggin following into TLOG.LTEXTE but it is still not
helpful as the same identifier is repeated in case the same connection is
reused by application server.
I am using userenv('sessionid')||' : '||pLTEXTE
We use the same technique in Java logging to create a unique identifier per
server call. I am planning to add that identified in session and add that to
log messages instead of SID.
Please comment if such a feature will be useful for anyone else using this
project.
Regards
Nitin
log4plsql-all-info mailing list wrote:
>
> When looking through my TLOG file, messages logged from many different
> sessions are interleaved. It would be useful to be able to filter a view
> by the SID from which the messages were generated. I feel that this
> would best be handled by adding a new column to the TLOG table and
> enhancing the code to automatically populate this column when inserting
> a row.
>
>
>
> ______________________________________________________
>
> Mark Freeman | Data Architect | Click4Care, Inc.
>
> 50 South Liberty Street | Suite 200 | Powell, OH 43065
>
> Email: mfr...@cl... <http://www.click4care.com>
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9-12, 2009. Register
> now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Log4plsql-all-info mailing list
> Log...@li...
> https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
> log4plsq : http://log4plsql.sourceforge.net
>
>
--
View this message in context: http://www.nabble.com/Enhancement-suggestion%3A-log-the-SID-tp25695283p25722070.html
Sent from the log4plsql-all-info mailing list archive at Nabble.com.
|
