jm7647 commented on issue #5418: Unable to Configure a JDBC sink
URL: https://github.com/apache/pulsar/issues/5418#issuecomment-545008314
 
 
   That was side effect of me removing sink, so we can ignore it.
   After spending some time with suggested solution I see two cases and both 
fail.
   
   1. Passing useSSL=false to link in .yaml file
                jdbcUrl: 
"jdbc:mysql://127.0.0.1:3306/pulsar_mysql_jdbc_sink&useSSL=false"
                
               that brings mysql error:
               [Note] Unknown database 'pulsar_mysql_jdbc_sink&useSSL=false'
   
   2. Adding useSSL=false as additional .yaml parameter:
                  .....
                 jdbcUrl: "jdbc:mysql://127.0.0.1:3306/pulsar_mysql_jdbc_sink"
                 tableName: "pulsar_mysql_jdbc_sink"
                 useSSL: "false"
   
               This removes SSL warning but sink log reports it as unrecognized 
field and also fails:
   
               15:03:26.939 [public/default/pulsar-mysql-jdbc-sink-0] ERROR 
org.apache.pulsar.functions.instance.JavaInstanceRunnable - Sink open produced 
uncaught exception:
   com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException: 
Unrecognized field "useSSL" (class org.apache.pulsar.io.jdbc.JdbcSinkConfig), 
not marked as ignorable (8 known properties: "nonKey", "jdbcUrl", "userName", 
"timeoutMs", "tableName", "password", "key", "batchSize"])
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to