The first NamedDataSource extension will be set as default for all named datasources. datasource_column=true can be simplied as datasource_column, for example: If you're familiar with Vert.x, you can customize its configuration by changing config/httpd.json and config/vertx.json.Īll supported query parameters can be found at here. You can customize logging configuration in logging.properties. You may refer to examples at misc/quick-start/jdbc-bridge/config/queries.
Similar as named datasource, named queries are JSON configuration files under config/queries. Saved queries and scripts are under scripts directory by default. If you use modern editors like VSCode, you may find it's helpful to use JSON schema for validation and smart autocomplete. You may check examples at misc/quick-start/jdbc-bridge/config/datasources.
"driverClassName": " ",īy default, named datasource is defined in configuration file in JSON format under config/datasources directory.
query= "select * from jdbc('self?datasource_column', 'select 1') "īesides docker, you can download and install released Debian/RPM package on existing Linux system. # issue below query, and you'll see "ch-server 1" returned from ClickHouseĭocker exec -it ch-server clickhouse-client \ "echo 'jdbc-bridge9019' \ > /etc/clickhouse-server/config.d/jdbc_bridge_config.xml & /entrypoint.sh " # add named datasource and queryĭocker exec -it jdbc-bridge cp /app/config/datasources/ \ĭocker exec -it jdbc-bridge cp /app/config/queries/ \ entrypoint /bin/bash clickhouse/clickhouse-server -c \ # create a network for ClickHouse and JDBC brigde, so that they can communicate with each otherĭocker network create ch-net -attachableĭocker run -rm -d -network ch-net -name jdbc-bridge -hostname jdbc-bridge clickhouse/jdbc-bridgeĭocker run -rm -d -network ch-net -name ch-server -hostname ch-server \