Exception: Inconsistent java and sql object types

Question

There are types:

CREATE OR REPLACE TYPE my_type IS OBJECT (
  id VARCHAR2(20),
  name VARCHAR2(40),
  phone NUMBER
);

I'm trying to create objects using these types:

....
Object[] myArray = new Object[3];
Object[] struct = new Object[values.size()];

int arrayIndex = 0;
for (User user : values) {
    myArray[0] = user.id().toString();
    myArray[1] = user.getName().toString();
    myArray[2] = user.getPhone();

    struct[arrayIndex++] = con.createStruct("my_type",myArray);
}

On the line with the creation of the structure of con.createStruct, an error occurs:

java.sql.SQLException: Inconsistent java and sql object types, for classes implementing ORAData or OracleData, respective factory classes ORADataFactory and OracleDataFactory should be registered in typeMap.

What can be wrong?

XING · Accepted Answer · 2017-11-10 12:16:48Z

2

   myArray[0] = user.id().toString();
   myArray[1] = user.getName().toString();
   myArray[2] = user.getPhone();

This should be like:

-- First element of the array.
    myArray[0].id  = user.id().toString();
    myArray[0].name  = user.getName().toString();
    myArray[0].phone  = user.getPhone();

answered Nov 10, 2017 at 12:16

XING

9,9164 gold badges25 silver badges40 bronze badges

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

Comments

localghost · Accepted Answer · 2017-11-11 08:49:46Z

0

You could employ class StructDescriptor from Oracle JDBC extensions:

StructDescriptor structDescriptor = StructDescriptor.createDescriptor("my_type",conn);
Object[] attributes = {user.id().toString(),
               user.getName().toString(),
               user.getPhone()};

new STRUCT(structDescriptor, connection, attributes);

https://docs.oracle.com/cd/E18283_01/appdev.112/e13995/oracle/sql/StructDescriptor.html

edited Nov 11, 2017 at 8:49

answered Nov 10, 2017 at 12:44

localghost

4192 silver badges6 bronze badges

1 Comment

Ahmet Over a year ago

oracle.sql.ARRAY/ArrayDescriptor/STRUCT/StructDescriptor/.. depricated: docs.oracle.com/database/121/JAJDB/deprecated-list.html

Collectives™ on Stack Overflow

Exception: Inconsistent java and sql object types

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related