java.sql.Connection createArrayOf() returns Unsupported feature

Question

I'm trying to pass an array of values to Oracle DB from Java application. Right now my code looks like this:

java.sql.Connection c = getConnection();
java.sql.Array myArray = c.createArrayOf("CHAR", new Object[]{'c', 'd'});

But I receive a java.sql.SQLException: Unsupported feature I'm using DB version 11 and Java 8. This should work accordingly to most of the examples I found on the web. What am I missing?

AlexR · Accepted Answer · 2019-12-12 17:38:38Z

2

Many methods of various JDBC interfaces can throw SQLUnsupportedFeatureException. The reason is tat although the JDBC API is common it is defined for superset of all possible relational databases. But not all such databases and their drivers support all features.

Specifically as far as i know among well known databases arrays are supported only by posgress. I think that oracle does not support arrays as a base type. This is the reason for exception. So, try to find other design that does not require arrays.

answered Dec 12, 2019 at 17:38

AlexR

116k16 gold badges137 silver badges216 bronze badges

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

Collectives™ on Stack Overflow

java.sql.Connection createArrayOf() returns Unsupported feature

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related