Re: [log4perl-devel] Reserved words in Oracle are conflicting with DBI.pm

[Kevin G. <ke...@go...>]

 > 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