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=jdbcracle: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.
Is the database connection working without the logger? Since its a java.sql.SQLException I'm tempted to say the problem has nothing to with logging although I could be wrong. Could you post the code you are using to make the connection and/or setup the jdbc logger?
Btw, why do you have a Microsoft ODBC driver manager with an Oracle JDBC driver? Am I the only one that things thats odd?