tag:blogger.com,1999:blog-8507185344691363497.post797823470716214528..comments2023-12-12T12:13:15.557+01:00Comments on i8c - Business Integration Architects: Enabling Oracle JDBC Driver Debug capabilitiesi8chttp://www.blogger.com/profile/05003002313779050051noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8507185344691363497.post-85430210380148396222013-08-01T00:32:51.569+02:002013-08-01T00:32:51.569+02:00Hi Sandeep,
First of all thank you for your feedb...Hi Sandeep,<br /><br />First of all thank you for your feedback.<br /><br />My personal setup was on HPUX but following pointers might help you further:<br />1. didn't set option oracle.jdbc.LogFile<br />2. updated log levels in file OracleLog.properties for all to FINEST as a start. It can be further tweaked as per your own need afterwards.<br />3. on my end STDOUT type of data (e.g. console) is being redirected to a seperate file. ojdbc trace information is being showing up in this dedicated file.<br /><br />Good luck!<br /><br />Johani8chttps://www.blogger.com/profile/05003002313779050051noreply@blogger.comtag:blogger.com,1999:blog-8507185344691363497.post-25955978291660957952013-07-31T22:45:02.897+02:002013-07-31T22:45:02.897+02:00Johan -
I am trying to enable driver debug loggin...Johan -<br /><br />I am trying to enable driver debug logging in webMethods 7.1.3. I have followed steps similar to what you have mentioned above with no luck.<br /><br />1) Downloaded Oracle debug JDBC driver 11gR2 from oracle.com and placed it under ' IntegrationServer/lib/jars'<br />2) Created an oracle logging config properties file - downloaded from oracle.com<br />3) Added following system properties to the java startup line in server.bat ...<br /> -D oracle.jdbc.Trace=true <br /> -D "oracle.jdbc.LogFile=%IS_DIR%\jdbcAdapter.log" <br /> -D "java.util.logging.config.file=%IS_DIR%\OracleLog.properties"<br /><br />This hasn't produced any kind of debugging output. Where did you see your debug logging? Appreciate your help.Sandeep Banerjeehttps://www.blogger.com/profile/09501816853327595534noreply@blogger.com