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: [email protected] <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
> [email protected]
> 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.
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
log4plsq : http://log4plsql.sourceforge.net
