can support jdbc bridge？

[wonb168]

has a clickhouse-jdbc-bridge，can chdb support this？

[auxten]

You can use the jdbc table function: https://clickhouse.com/docs/en/sql-reference/table-functions/jdbc

[wonb168]

此表函数需要单独的 clickhouse-jdbc-bridge 程序才能运行？

[auxten]

You don't need a standalone clickhouse-jdbc-bridge

[wonb168]

I tested, need install and start jdbc-bridge first:

#%%
import chdb
print(chdb.__version__)
# %%
#postgres://hvycjfbu:[email protected]:5432/hvycjfbu
url="jdbc:postgres://hvycjfbu:[email protected]:5432/hvycjfbu"
sql="select version()"
sql=f"""SELECT * FROM jdbc('{url}', '${sql}')"""
res = chdb.query(sql, 'Dataframe')
print(res)
# %%

raise error:

ChdbError: Code: 410. DB::Exception: clickhouse-jdbc-bridge is not running. Please, start it manually. (EXTERNAL_SERVER_IS_NOT_RESPONDING)

[auxten]

I did double check in the code. It seems JDBC will need clickhouse-jdbc-bridge started first, but ODBC does not need.