Log4j - Java Stored Proc

[Manish Rambabu <ma...@hotmail.com>]

Hi,

I am trying to use log4j in my Java Stored proc but am having trouble 
getting a connection. Im using a property file as below. Although when i run 
my program stand alone and change the log4j.appender.DBAppender.URL= to the 
connection string with username and password everything is fine. Its when I 
change it to "jdbc:default:connection" I am not able to log any messg to the 
DB. Any thoughts.

Thanks

This works for stand alone
--------------------------------------------------------
log4j.rootLogger=DEBUG, DBAppender
log4j.appender.DBAppender=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DBAppender.URL=jdbc:oracle:thin:@servername:1521:ID
log4j.appender.DBAppender.user=username
log4j.appender.DBAppender.password=password
log4j.appender.DBAppender.sql=INSERT INTO TEST (ID, SEQ, MESSG) VALUES 
(1,1,'%m')
log4j.appender.DBAppender.layout=org.apache.log4j.PatternLayout
log4j.appender.DBAppender.layout.ConversionPattern=%m

------------------------------------------------------
This doesnt WORK!!
-----------------------------------------------------
log4j.rootLogger=DEBUG, DBAppender
log4j.appender.DBAppender=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DBAppender.URL=jdbc:default:connection
log4j.appender.DBAppender.sql=INSERT INTO TEST (ID, SEQ, MESSG) VALUES 
(1,1,'%m')
log4j.appender.DBAppender.layout=org.apache.log4j.PatternLayout
log4j.appender.DBAppender.layout.ConversionPattern=%m

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail


---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: log4j-user-help@jakarta.apache.org