Abgeschickt von Daniel am 11 Januar, 2005 um 17:45:44
I'm trying to log Apache errors at my Oracle database, but I canīt get log4j and JDBCappender to execute a proper Role granting (a security requisite on my system).
Here's what I got on the log4j.properties:
====================
log4j.rootLogger=ERROR, R
log4j.logger.org.apache.catalina=DEBUG, R
log4j.appender.R=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.R.Driver=oracle.jdbc.driver.OracleDriver
log4j.appender.R.URL = jdbc:oracle:thin:@server:1521:sys
log4j.appender.R.user=sys
log4j.appender.R.password=sys
log4j.appender.R.sql=execute DBMS_SESSION.SET_ROLE('RL_DATA');INSERT INTO SN_TB_LOGS_TOMCAT (DATE, MOD, MENSAGE) VALUES (SYSDATE, '%l', '%m');
log4j.appender.R.layout=org.apache.log4j.PatternLayout
===========================================
And hereīs the error message I got:
log4j:ERROR Failed to excute sql
java.sql.SQLException: ORA-00911: invalid character
So, my wuestion is: How can I configure/execute/grant the SET_ROLE in the log4j.properties?