> Because the log table contains a column name 'LEVEL' in the original
> implementation, by using it with Oracle produces an error, because
the word
> 'LEVEL' is a reserved word in Oracle and this prevents a successful
creation
> of the table with this column name....
I think you are talking about Log::Dispatch::DBI which isn't our product
and isn't needed for you to use log4perl's new DBI logging feature.
That module has a default table with columns as you describe. Our
module Log::Log4perl::Appender::DBI does not assume a default table
structure, you have to create your own, check out the perldoc on it and
let us know if you have any questions.
Thomas Schuler wrote:
> Hello Log4perl list members!
>
> I tried to use the new version 0.31 of Log4perl with the new DBI logging
> feature together with Oracle...I won't work directly! :-(
>
> Because the log table contains a column name 'LEVEL' in the original
> implementation, by using it with Oracle produces an error, because the word
> 'LEVEL' is a reserved word in Oracle and this prevents a successful creation
> of the table with this column name....
>
> My suggestion: Let's rename the column to the name "LOGLEVEL".
> And we should fix this the column name in the insert statement in the module
> DBI.pm and also in the manpage.
>
> Any corrections and suggestions are very welcome!
>
> Regards,
>
> Thomas
--
Happy Trails . . .
Kevin M. Goess
(and Anne and Frank)
904 Carmel Ave.
Albany, CA 94706
(510) 525-5217
|
