{"action":"created","issue":{"url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/31","repository_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc","labels_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/31/comments","events_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/31/events","html_url":"https://github.com/confluentinc/kafka-connect-jdbc/issues/31","id":124718191,"number":31,"title":"Issue with Oracle column type NUMBER set as \"Incrementing Column\" in Kafka Connect","user":{"login":"ramkumarkb","id":511301,"avatar_url":"https://avatars3.githubusercontent.com/u/511301?v=4","gravatar_id":"","url":"https://api.github.com/users/ramkumarkb","html_url":"https://github.com/ramkumarkb","followers_url":"https://api.github.com/users/ramkumarkb/followers","following_url":"https://api.github.com/users/ramkumarkb/following{/other_user}","gists_url":"https://api.github.com/users/ramkumarkb/gists{/gist_id}","starred_url":"https://api.github.com/users/ramkumarkb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ramkumarkb/subscriptions","organizations_url":"https://api.github.com/users/ramkumarkb/orgs","repos_url":"https://api.github.com/users/ramkumarkb/repos","events_url":"https://api.github.com/users/ramkumarkb/events{/privacy}","received_events_url":"https://api.github.com/users/ramkumarkb/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":19,"created_at":"2016-01-04T08:54:50Z","updated_at":"2018-02-22T23:55:15Z","closed_at":"2016-09-14T20:44:18Z","author_association":"NONE","body":"Kafka-connect-jdbc program has an issue with Oracle Table that has a Primary Key of Type NUMBER and if we use that for Column as Incrementing (in the mode settings of the Kafka-Connect program).\n\nIt appears (from our debugging efforts) we see that NUMBER => java.math.BigDecimal => NUMERIC => BYTES in the kafka-connect-jdbc code. Essentially, the SchemaBuilder.java sets it to Type.BYTES.\n\nAnd as result, we see the error \"Invalid type of Incrementing column: BYTES\" when we connect to the Oracle Database. This is a rather severe limitation for the Kafka Connect to be able to work with Oracle Database as most of the PK columns are of type NUMBER\n\nSteps to Reproduce this Issue:\n- Set-up a table in Oracle \n\n<pre><code>create table TEST_KAFKA_CONNECT {\nKAKFA_PK NUMBER not null, UPDATED_AT timestamp not null } </code></pre>\n\n- Configure the Kafka-Connect\n\n<pre><code>mode=timestamp+incrementing\nincrementing.column.name=KAKFA_PK\ntimestamp.column.name=UPDATED_AT </code></pre>\n\n\nIn the Kafka-Connect-JDBC use the Oracle's JDBC driver (tested with Oracle 11.2.0.2.0; driver corresponding Oracle JDBC driver available here: http://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html \n"},"comment":{"url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/comments/367863448","html_url":"https://github.com/confluentinc/kafka-connect-jdbc/issues/31#issuecomment-367863448","issue_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/31","id":367863448,"user":{"login":"praveengone","id":16076345,"avatar_url":"https://avatars1.githubusercontent.com/u/16076345?v=4","gravatar_id":"","url":"https://api.github.com/users/praveengone","html_url":"https://github.com/praveengone","followers_url":"https://api.github.com/users/praveengone/followers","following_url":"https://api.github.com/users/praveengone/following{/other_user}","gists_url":"https://api.github.com/users/praveengone/gists{/gist_id}","starred_url":"https://api.github.com/users/praveengone/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/praveengone/subscriptions","organizations_url":"https://api.github.com/users/praveengone/orgs","repos_url":"https://api.github.com/users/praveengone/repos","events_url":"https://api.github.com/users/praveengone/events{/privacy}","received_events_url":"https://api.github.com/users/praveengone/received_events","type":"User","site_admin":false},"created_at":"2018-02-22T23:55:15Z","updated_at":"2018-02-22T23:55:15Z","author_association":"NONE","body":"I am also facing the similar problem with Oracle db, JDBCSourceConnector. Is there any work a round to this problem"}}
{"actor":{"display_login":"praveengone"}}