You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by GitBox <gi...@apache.org> on 2022/03/10 07:26:57 UTC

[GitHub] [camel-kafka-connector-examples] fywf555 opened a new issue #330: camel-kafka-connector-examples

fywf555 opened a new issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330


   ## Open the SQL configuration file at $EXAMPLES/sql/sql-source/config/CamelSqlSourceConnector.properties
   
   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=mysecretpassword
   camel.component.sql.dataSource.serverName=172.17.0.2
   camel.component.sql.dataSource=#class:org.postgresql.ds.PGSimpleDataSource
   
   camel.source.path.query=select * from accounts
   
   ## Please tell me how to select database
   i try to use 
   ```
   camel.component.sql.dataSource.serverName=172.17.0.2:5432/test
   ```
   but faild


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
taobingqing commented on issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1063744741


   I can't find it either


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
oscerd commented on issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1064795134


   No, it's not a silly question. We need to explain it better in the example. Let me improve the README.


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
oscerd commented on issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1063749015


   Read the Readme https://github.com/apache/camel-kafka-connector-examples/tree/main/sql/sql-source#setup-the-docker-image


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
oscerd commented on issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1063749222


   We write the Readme for this purpose


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
oscerd commented on issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1063744480


   You need to point to the address of an existing database. The address there is just an example 


-- 
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-unsubscribe@camel.apache.org

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

[GitHub] [camel-kafka-connector-examples] oscerd closed issue #330: camel-kafka-connector-examples

Posted by GitBox <gi...@apache.org>.
oscerd closed issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330


   


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
oscerd commented on issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1064799258


   The commit should explain a bit better how to do it. Thanks for asking. We're always trying to improve the documentation.


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
fywf555 commented on issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1063759148


   i understand....it a silly question


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
oscerd commented on issue #330:
URL: https://github.com/apache/camel-kafka-connector-examples/issues/330#issuecomment-1063755774


   Change the database nane according to the name you need to point. The error is clear 


-- 
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-unsubscribe@camel.apache.org

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

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

Posted by GitBox <gi...@apache.org>.
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-unsubscribe@camel.apache.org

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