How can i log the various SQL statements executed by a weblogic server? I tried enabling it on the console of the weblogic, but it just gives me the details abt the driver and the connection, but nothing about the SQL statements. Can anybody help me?
I don't think weblogic has a feature that logs the SQL used. You can try using P6Spy ( www.p6spy.com ) to wrap around the JDBC driver that you are using in Weblogic. P6Spy is able to log the SQL statements fired.
I believe you can log it by enalabling JDBC logger. Please see DriverManager API.