Error with Structs and Arrays in Java

Question

Getting error with Structs and Arrays handdling list of objects.

java.lang.ClassCastException: oracle.sql.StructDescriptor cannot be cast to oracle.sql.ArrayDescriptor

Here is the code:

List<Commission> commissions = (List<Commission>) parameter;

Struct[] structs = new Struct[commissiones.size()];
for (int index = 0; index < comisions.size(); index++) {
    Object[] params = new Object[9];

    Commission commission = commissions.get(index);

    /* Setting parameters */

    Struct struct = ps.getConnection().createStruct("T_COMMISSION", params);
    structs[index] = struct;
}

Array array = ((OracleConnection)ps.getConnection()).createOracleArray("C_COMMISSION", structs);

ps.setArray(i, array);

Edit, adding T_COMMISSION:

CREATE OR REPLACE TYPE GESFIN.T_COMMISSION AS OBJECT (COM_MZN VARCHAR2(3),
                                                      COM_PVP VARCHAR2(8),
                                                      -- ..More params)
/

CREATE TYPE C_COMMISSION AS TABLE OF T_COMMISSION
/

`Struct struct = ps.getConnection().createStruct("T_COMMISSION", params); structs[index] = struct;` — Rancio, May 31 '18 at 12:21
It would help if you could provide the definition of T_COMMISSION. Is it an ADT or an ARRAY or some other kind of PLSQL collection? — Jean de Lavarene, Jun 01 '18 at 07:21

score 0 · Answer 1 · answered Oct 11 '21 at 10:01

0

Link to post with the same case

Add

Struct[] struct = new Struct[params.size()];

Change

Struct struct = ps.getConnection().createStruct("T_COMMISSION", params);

to

struct[index] = ps.getConnection().createStruct("T_COMMISSION", params);

answered Oct 11 '21 at 10:01

Denis Rodin

319
1
7

structs array is already there. It should be created again? – Rohit Kumar Oct 12 '21 at 08:13

score 0 · Answer 2 · answered Oct 14 '21 at 16:30

0

try going in a reversed if loop for (int index = commision.size(); index > -1; index--) {

plus you have a typing error, it is commission, not comision... double check your code and getting a plugin/extension/ad-on to check such error.

Best Regards :-)

answered Oct 14 '21 at 16:30

UnkownReality

130
13

Error with Structs and Arrays in Java

2 Answers2