java.sql.SQLException: Fail to construct descriptor error

Question

I am using following in java code

StructDescriptor structDescriptor = StructDescriptor.createDescriptor("AF.TRANSACTIONDATATABLE", oracleConnection);

and following are my commands in db

CREATE OR REPLACE TYPE AF.TRANSACTIONDATATYPE AS OBJECT (
    no VARCHAR2(50),
    bh VARCHAR2(20),
    jb VARCHAR2(20),
    g VARCHAR2(20),
    hi VARCHAR2(30)
);

CREATE OR REPLACE TYPE AF.TRANSACTIONDATATABLE AS TABLE OF AFX_TLX_DS_USR.TRANSACTIONDATATYPE;

Still getting below

Caused by: java.sql.SQLException: Fail to construct descriptor: Invalid arguments
    at oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:144)
    at oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:95)

unable to understand whats wrong

Did you post the entire stack trace?

Abra
– Abra

2024-09-04 04:47:07 +00:00
Commented Sep 4, 2024 at 4:47 — Abra
– Abra, Commented Sep 4, 2024 at 4:47

MT0 · Accepted Answer · 2024-09-04 06:48:15Z

1

AF.TRANSACTIONDATATABLE is a collection (Array) and not an object (Struct):

StructDescriptor structDescriptor = StructDescriptor.createDescriptor("AF.TRANSACTIONDATATYPE", oracleConnection);
ArrayDescriptor arrayDescriptor = ArrayDescriptor.createDescriptor("AF.TRANSACTIONDATATABLE", oracleConnection);

You can see a complete code example in this answer

answered Sep 4, 2024 at 6:48

MT0

173k12 gold badges70 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

java.sql.SQLException: Fail to construct descriptor error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related