Jeff and John,
I'll admit to knowing very little about Java in the Oracle database, but I'd think
that once you put log4j in the database it would naturally follow to log into db
tables rather than files or anything else.
I've contributed a JDBCAppender which works well in a normal log4j installation,
and by overriding one method (executeSql()) you would probably have something that
works great for your situation.
Kevin Steppe
Software Architect/Developer looking for work
John Carnahan wrote:
> Jeff,
>
> We recently did a big project using log4j and Java stored procs. I am not sure
> if you have already learned this but using log4j file appenders is close to
> impossible in that context. As you likely know Oracle likes to own the i/o and
> consequently closes output streams very strictly after procedure calls. So what
> typically happens, with file appenders, is logging will work once and then
> stop. The best alternative way we found to do logging was using using Oracle
> AQ/JMS and log4j. This added considerable complexity to the project but was the
> most straightforward since we were already using AQ/JMS for other things. There
> a several strange things about Oracle's JMS but that is another topic.
>
> To answer your question -> loading it into Oracle was pretty straightforward at
> least at the time. I know that we used the -resolve flag on loadjava but that
> was about it. There may have been other libraries that it depended on. In
> general, Oracle's loadjava sucks. It is order dependent and not very tolerant.
> We ended up with fairly complex scripts to load in all of our necessary
> libraries.
>
> John
>
> > Hi All
> >
> > We are trying to implement log4j with Oracle 8i java stored procedures. But
> > we are having trouble installing log4j into the database.
> >
> > Has anybody had any success with this?
> >
> > Thanks in advance
> > Jeff Singer
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
