Support Questions
Find answers, ask questions, and share your expertise

Does DBCPConnectionPool support Oracle and Greenplum

Cloudera Employee

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Does DBCPConnectionPool support Oracle and Greenplum

Rising Star

@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.

View solution in original post

2 REPLIES 2

Re: Does DBCPConnectionPool support Oracle and Greenplum

@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

Rising Star

@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.

View solution in original post