Is there a way to log the queries executed by a Oracle UCP?

Asked Feb 06 '19 at 18:58

Active Feb 06 '19 at 21:31

Viewed 444 times

I have a Oracle UCP connection Pool responsible for executing queries from the Java application. I want to see all the queries in the logs that this UCP takes care of.

I followed this guide https://docs.oracle.com/cd/E11882_01/java.112/e12265/dgn_conpool.htm#CIHIGBIJ to use the property of 'oracle.ucp.level' to set the log level to FINEST.

I couldnt see the sql queries in logs. I could see all other information like getting a connection, DB URL etc in the logs but I couldnt see the SELECT query that was executed by this connection pool.

Is there a way we could see the SELECT, INSERT and UPDATE queries executed by the Oracle UCP ?

If not the whole query , Atleast can we see whether it is a SELECT or INSERT or UPDATE ?

edited Feb 06 '19 at 21:31

asked Feb 06 '19 at 18:58

hari

which version of the connection pool are you using? – steve Feb 07 '19 at 05:26
I am using ucp 12.1.0.2 – hari Feb 07 '19 at 13:25
It looks like what you want is to turn on logging in the JDBC driver (not UCP) where the query execution will happen. – Jean de Lavarene Feb 08 '19 at 13:07
Yup realized that. It needs special ojdbc debugging jar to achieve that. – hari Feb 08 '19 at 16:49

Is there a way to log the queries executed by a Oracle UCP?

0 Answers0