[GitHub] [camel-kafka-connector-examples] fywf555 commented on issue #330: camel-kafka-connector-examples

[GitBox]

fywf555 commented on issue #330:
URL: 
https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1063753943


   it is worked and use the default database;
   
![image](https://user-images.githubusercontent.com/26627032/157612069-028a2621-0f57-497c-bf96-2e27442d56f4.png)
   
   ```
   name=CamelSqlSourceConnector
   connector.class=org.apache.camel.kafkaconnector.sql.CamelSqlSourceConnector
   key.converter=org.apache.kafka.connect.storage.StringConverter
   value.converter=org.apache.kafka.connect.storage.StringConverter
   
   topics=mytopic
   
   camel.component.sql.dataSource.user=postgres
   camel.component.sql.dataSource.password=ab.123456
   camel.component.sql.dataSource.serverName=10.14.16.4:5432
   camel.component.sql.dataSource=#class:org.postgresql.ds.PGSimpleDataSource
   camel.source.path.query=select * from account
   ```
   
![image](https://user-images.githubusercontent.com/26627032/157612680-b8edcc8d-ff94-4941-96eb-314f2c4383a4.png)
   
   
   but i want to use another database,i try 
   ```
   name=CamelSqlSourceConnector
   connector.class=org.apache.camel.kafkaconnector.sql.CamelSqlSourceConnector
   key.converter=org.apache.kafka.connect.storage.StringConverter
   value.converter=org.apache.kafka.connect.storage.StringConverter
   
   topics=mytopic
   
   camel.component.sql.dataSource.user=postgres
   camel.component.sql.dataSource.password=ab.123456
   camel.component.sql.dataSource.serverName=10.14.16.4:5432/test
   camel.component.sql.dataSource=#class:org.postgresql.ds.PGSimpleDataSource
   camel.source.path.query=select * from invoice
   ```
   and failed
   
![image](https://user-images.githubusercontent.com/26627032/157612614-893506f6-dbfc-48ea-9753-608667431352.png)
   


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

To unsubscribe, e-mail: commits-unsubscr...@camel.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org