hi,
but what if i have multiple columns ?
i am planning to use "exec proc(?)" and try to tokenize in stored proc
itself
regards,
Amandeep
"Shapira,
Yoav" To: "Log4J Users List"
<[EMAIL PROTECTED]>
<Yoav.Shapira@ cc:
mpi.com> Subject: RE: Logging multiple strings
01/27/2003
07:41 PM
Please respond
to "Log4J
Users List"
Howdy,
Have you considering the use of a mapped diagnostic context (MDC)? The
pattern would include %X{username} %X{applicationName}
%X{transactionName} etc. See the JavaDoc for the MDC class and the
manual for examples.
Yoav Shapira
Millennium ChemInformatics
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]
>Sent: Friday, January 24, 2003 3:57 PM
>To: Log4J Users List
>Subject: Logging multiple strings
>
>
>I'm thinking of using log4j with the jdbc appender, to log some
structured
>information regarding the usage of my applications. I log with
something
>like:
>
>myLogger.info( userName + applicationName + transactionName );
>
>I would like to be able to use a JDBC conversion pattern that would
allow
>me to load the user name in a column, the application name into another
>column, and the
>transaction name into a third column. But, since the logger only
accepts a
>single string as parameter, there is no way once we get into the layout
>specification to make a
>reference to individual elements. The layout only knows that my string
>corresponds to the %m specification.
>
>What I would need is the possibility of calling the logger with a
>collection of strings; then, in the layout, I could reference each
string
>with a %1m , %2m and %3m
>specification - something like
>... INSERT INTO TEST_TABLE ( userName, transactionName, applicationName
)
>VALUES ( "%1m" , "%3m", "%2m" ) " .
>
>I know there is no such thing in the package right now, and I don't
expect
>it any time soon, but do you think it would be feasible? And would it
be
>useful, or am I the
>only one with that kind of requirements?
>
>Serge Arsenault
>
>
>
>
>--
>To unsubscribe, e-mail: <mailto:log4j-user-
>[EMAIL PROTECTED]>
>For additional commands, e-mail: <mailto:log4j-user-
>[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]
>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
