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

Last updated on DECEMBER 03, 2012

Applies to:

Oracle Workshop for Weblogic - Version: 10.3 and later   [Release: AS10gR3 and later ]
Information in this document applies to any platform.

Symptoms

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;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms