cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

About Create Statement displayed in the PurePath tree

khanada
Contributor

I have a question about the display of AppMon's PurePath tree.


I am looking at the "Create Statement" displayed in the PurePath tree.


URL

https://docs.oracle.com/javase/tutorial/jdbc/basics/processingsqlstatements.html#creating_statements

⇒Do you mean "Create a statement" described here?


2 REPLIES 2

khanada
Contributor

Upload an image.


"Create Statement" represents a call to con.CreateStatement(), as descried in your provided link.


In your case the JDBC driver creates the second Statement object and executes a query to load variables from the server (see the long SQL statement starting with "/* mysql-connector").

To my knowledge the latest MySQL driver (version 8.?), does not create a statement and execute a query anymore, but loads the server variables through a native command (most likely to improve performance)