question Re: Does DBCPConnectionPool support Oracle and Greenplum in Archives of Support Questions (Read Only)

Does DBCPConnectionPool support Oracle and Greenplum

nasghar — Tue, 21 Apr 2026 12:35:19 GMT

Getting below error

same error on both Oracle and Greenplum DB. It looks like ResultSetMetaDatagetTableName(1) is not supported in Oracle drivers. See http://stackoverflow.com/questions/20653694/oracle-11g-resultset-how-to-get-the-table-name

org.apache.avro.SchemaParseException: Empty name
  at org.apache.avro.Schema.validateName(Schema.java:1076) ~[na:na]
  at org.apache.avro.Schema.access$200(Schema.java:79) ~[na:na]
  at org.apache.avro.Schema$Name.<init>(Schema.java:436) ~[na:na]
  at org.apache.avro.Schema.createRecord(Schema.java:145) ~[na:na]
  at org.apache.avro.SchemaBuilder$RecordBuilder.fields(SchemaBuilder.java:1732) ~[na:na]
  at

Is there a workaround?

Re: Does DBCPConnectionPool support Oracle and Greenplum

nsabharwal — Fri, 16 Oct 2015 09:59:45 GMT

@nasghar@hortonworks.com In oracle there is concept called DRCP for connection pooling. Its at the database level.

Re: Does DBCPConnectionPool support Oracle and Greenplum

mpayne — Wed, 04 Nov 2015 23:06:20 GMT

@nasghar@hortonworks.com this is a bug that is addressed in the next release. The ticket where it was addressed is https://issues.apache.org/jira/browse/NIFI-1010.