{"action":"created","issue":{"url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/242","repository_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc","labels_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/242/labels{/name}","comments_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/242/comments","events_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/242/events","html_url":"https://github.com/confluentinc/kafka-connect-jdbc/issues/242","id":241958352,"number":242,"title":"JDBC source connector is not working with timestamp+incrementing mode","user":{"login":"himani1","id":8193529,"avatar_url":"https://avatars1.githubusercontent.com/u/8193529?v=4","gravatar_id":"","url":"https://api.github.com/users/himani1","html_url":"https://github.com/himani1","followers_url":"https://api.github.com/users/himani1/followers","following_url":"https://api.github.com/users/himani1/following{/other_user}","gists_url":"https://api.github.com/users/himani1/gists{/gist_id}","starred_url":"https://api.github.com/users/himani1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/himani1/subscriptions","organizations_url":"https://api.github.com/users/himani1/orgs","repos_url":"https://api.github.com/users/himani1/repos","events_url":"https://api.github.com/users/himani1/events{/privacy}","received_events_url":"https://api.github.com/users/himani1/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":17,"created_at":"2017-07-11T07:52:54Z","updated_at":"2018-04-23T06:17:07Z","closed_at":"2017-07-28T11:15:56Z","author_association":"NONE","body":"Hi,\r\nI am trying to use mode timestamp+incrementing with mysql, but it does not create any topic in my kafka queue when I do so and there is also no error log.\r\n\r\nHere are the connector properties that I am using,\r\n\r\nname=test-source-mysql-jdbc-autoincrement\r\nconnector.class=io.confluent.connect.jdbc.JdbcSourceConnector\r\ntasks.max=1\r\nconnection.url=jdbc:mysql://127.0.0.1:3306/test?user=root&password=root\r\nconnection.user=root\r\nconnection.password=root\r\n#mode=incrementing\r\nmode=timestamp+incrementing\r\ntimestamp.column.name=name\r\nincrementing.column.name=name\r\ntopic.prefix=test-mysql-t3-\r\n\r\nMy database test contains a single table example(id int,name varchar(40))."},"comment":{"url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/comments/383466216","html_url":"https://github.com/confluentinc/kafka-connect-jdbc/issues/242#issuecomment-383466216","issue_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/242","id":383466216,"user":{"login":"suiziguo","id":10202387,"avatar_url":"https://avatars3.githubusercontent.com/u/10202387?v=4","gravatar_id":"","url":"https://api.github.com/users/suiziguo","html_url":"https://github.com/suiziguo","followers_url":"https://api.github.com/users/suiziguo/followers","following_url":"https://api.github.com/users/suiziguo/following{/other_user}","gists_url":"https://api.github.com/users/suiziguo/gists{/gist_id}","starred_url":"https://api.github.com/users/suiziguo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/suiziguo/subscriptions","organizations_url":"https://api.github.com/users/suiziguo/orgs","repos_url":"https://api.github.com/users/suiziguo/repos","events_url":"https://api.github.com/users/suiziguo/events{/privacy}","received_events_url":"https://api.github.com/users/suiziguo/received_events","type":"User","site_admin":false},"created_at":"2018-04-23T06:17:07Z","updated_at":"2018-04-23T06:17:07Z","author_association":"NONE","body":"@tungntt  Thank you a lot! \r\nI have some questions about UTC time in MySQL.\r\nMySQL converts TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval.\r\nAs mentioned above，it has already saved data of timestamp column by UTC time？"}}
{"actor":{"display_login":"suiziguo"}}