JDBC 18.104.22.168 Adds A Space At The End Of A Select Statement When Using Bind Variables. While 11.1 Does Not Add This Space.
(Doc ID 1104693.1)
Last updated on MARCH 01, 2021
Applies to:JDBC - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199 version, Thin JDBC driver
If a sql statement is run with JDBC Driver 188.8.131.52 generated a new SQL_ID for the execution on this version.
If the same program is run using JDBC 10.2.0.4 and/or 184.108.40.206 they share the same SQL_ID.
Here are the results of these tests:
1) Run a java program having a select statement using a bind variable 5 times using the 220.127.116.11 JDBC Driver with JDK 1.5
Looking into the v$sql view we can see it was executed 5 times:
Here we can see they have different size.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document