My Oracle Support Banner

Regression in @JdbcControl.SQL after upgrading to WLS 10.3 with SQL statements. (Doc ID 1338016.1)

Last updated on MARCH 09, 2019

Applies to:

Oracle Workshop for Weblogic - Version 10.3 and later
Information in this document applies to any platform.


You will notice a regression in JDBC Control after upgrading to WLW 10.3. The issue is with the SQLGrammar which is being generated from JDBC controls.
You will also not be able to insert BLOB object using JDBC Control and will also face issue when trying ot use internal functions within substitution brackets. For Eg:

1. JDBC Control inserting the blob data

@JdbcControl.SQL(statement = "INSERT INTO customer_blob(customer_id,customer_name,customer_info) VALUES({customer_id},{customer_name},{customer_info})")
int insertCustomer(int customer_id,String customer_name,byte[] customer_info) throws SQLException;

2. JDBC Control using internal functions

@JdbcControl.SQL(statement="SELECT COLUMN01 FROM TEST_TABLE WHERE {sql: fn
in (COLUMN02,{COLUMN02})}")
public String[] findCustomer(int[] COLUMN02) throws SQLException;


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.