HI,
I am using log4j in my
java application to log error messages using JDBCAppender to record the messages in DB tables.
I am getting this error in JDeveloper.
log4j:ERROR Failed to excute sql
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Here is my log4j.properties file.
log4j.appender.JDBC2=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.JDBC2.driver=oracle.jdbc.driver.OracleDriver
log4j.appender.JDBC2.url=jdbc:oracle:thin:@Server:port:instance
log4j.appender.JDBC2.user=user
log4j.appender.JDBC2.password=password
Note: I am able to log messages using FileAppender.
Please let me know if anybody have any solutions for this problem.
Siva.