picassoo opened a new issue #11568:
URL: https://github.com/apache/pulsar/issues/11568
**Sink Connectors can not find table**
Hi,
I tried Pulsar IO features (source and sink connectors) in standalone mode.
Source connectors works very well with debezium connector. But Sink Connector
can find table while deploying jdbc postgresql connector. Naturally , Pulsar
can not write topic message to table.
Sink Config YAML File:
```
tenant: "public"
namespace: "default"
name: "postgresql-storage-sink"
archive: "connectors/pulsar-io-jdbc-postgres-2.8.0.nar"
parallelism: 1
inputs:
- "user-avro-topic"
configs:
userName: "stream"
password: "password"
jdbcUrl:
`"jdbc:postgresql://postgreshost:5432/postgres?currentSchema=public"`
tableName: "pulsarsink"
```
**Possible Solution**
I suspect jdbcUrl can be wrong. I excanged host, database ans schema
sequentially. When I did these, Pulsar throws connection exception.
Eventually, problem is not caused from jdbcUrl. But I never seen any example
on pulsar site demostrate sink connector with database schema info.
Can you give any example that accomplish to connect postgresql with db
schema info.
Pulsar version 2.8.0
Docker version 20.10.7
postgres (PostgreSQL) 13.3
**Pictures**
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
