Re: Kafka connect jdbc Sink connector issues when moving from MySQL to Oracle DB

2016-09-30 Thread Srikrishna Alla
Thanks for the response Shikar. The issue was happening because the table metadata was sending the column names of the table in upper case and the connector is expecting the table names to be in lower case. I fixed it by creating the table with table columns like "updated_by". This way, I am no lon

Re: Kafka connect jdbc Sink connector issues when moving from MySQL to Oracle DB

2016-09-30 Thread Shikhar Bhushan
Hi Srikrishna, For future please address questions related to Confluent's connectors to the relevant ML (https://groups.google.com/forum/#!forum/confluent-platform ). The NVARCHAR2(4000) mapping for string types for Oracle was based on my reading of the documentation which states it can hold up t

Kafka connect jdbc Sink connector issues when moving from MySQL to Oracle DB

2016-09-30 Thread Srikrishna Alla
Hi, I am facing issues with jdbc Sink Connector when working with Oracle DB. This functionality was working fine when I was using MySQL DB. First error I had was when trying to create table using auto.create = true. It tried to create table for STRING fields as NVARCHAR2(4000) (which I see is by