Skip to Main Content

Java Database Connectivity (JDBC)

Generating the SQLText Metric in DMS

1002441Apr 11 2013 — edited Oct 15 2014
I want the SQLText value to be set in JDBC DMS, from the document here http://docs.oracle.com/cd/B28359_01/java.111/b31224/dmsmtrc.htm#CHDBDDHB, it says:
If the 11.1 version of the DMS JAR file is present in the classpath environment variable, then JDBC checks the DMS update SQL text flag. If this flag is true, then the SQLText metric is updated.
If the 11.1 version of the DMS JAR file is not present in the classpath environment variable, then JDBC uses the value of the DMSStatementMetrics connection property. If this statement property is true, then SQLText metric is updated. The default value of this connection property is false.

The problems are that:
1) It does not mention how to set this "DMS update SQL text" flag.
2) What's the exact name of DMSStatementMetrics property, I can find the "oracle.jdbc.DMSStatementMetrics" from http://docs.oracle.com/cd/B14099_19/core.1012/b14001/optj2ee.htm#CACFHAHF, is it the right one?

Anyone can help me?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2013
Added on Apr 11 2013
3 comments
100 views