Insert VARRAY into Oracle Database using JDBC

, ,
1

[SIZE=3]Hi,

I have created a table with a array column as below.

[/SIZE] [COLOR=black][FONT=&quot][FONT=Century Gothic][COLOR=Blue]create or replace type vcarray_sec_units as VARRAY(10) of VARCHAR2(50);[/font][/color]

[FONT=&quot][SIZE=3]create table mw_payload_sec_unit
(
internal_id varchar2(70),
sec_units VCARRAY_SEC_UNITS
);[/size][/font]

[SIZE=3] Now I wish to insert data into this table using JDBC Adapter service. [/size]

In the adapter service, the sec_units column appear with JDBC Data Type as “Other” with possible input field type as - java.lang.string, java.lang.object, java.sql.struct & java.sql.array.

I am using java.lang.object input type and trying to pass string list which is converted to vector using pub.list:addItemToVector

While trying to insert I get this error -

[SIZE=3][COLOR=Red]com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Default:insertSimpleArray.
[ADA.1.316] Cannot execute the SQL statement “INSERT INTO MW_PAYLOAD_SEC_UNIT(INTERNAL_ID, SEC_UNITS) VALUES (?, ?)”. "
(17004) Invalid column type"
Invalid column type[/size][/color]

[FONT=Century Gothic][SIZE=3][/font]Not sure if the JDBC Adapter service would accept the Vector as input to java.lang.object.[/size]

[SIZE=3]Your help will be highly appreciated.
[/FONT][/COLOR][/size]

2

We have similar issue with Stored procedure,

IS this issue resolved?

Did you get any Java util to convert object to java.sql.struct?

Thanks in advanced.

3

Your JDBC adapter is lacking fix level. What is your current installed fix level?