Configure oracle WebLogic server with clickhouse-jdbc driver.

[Lelik13a]

In config file jdbcdrivers.xml required attribute: URLHelperClassname. `<Driver

Database="ClickHouse"

Vendor="Yandex"

Type="Type 4"

DatabaseVersion="Any"

ForXA="false"

ClassName="ru.yandex.clickhouse.ClickHouseDriver"

URLHelperClassname=???

TestSql="SELECT 1">`

[enqueue]

Can you use regular Java EE DataSource? Then you won't need the WebLogic specific things. See for example Weblogic manual

[bas-ter]

Is there any progress of using Clickhouse JDBC driver with the WebLogic server? Most interested in the ability to send SQL queries from OBIEE Server using the date literal functionality like: Select * from clickhouse.table where date_column= {d'2020-01-01'}

[Lelik13a]

Finally I used clickhouse ODBC driver with weblogic. Its works.

[bas-ter]

Did you get an error like this: SMA: Maximum-Sys-Allocation Exceeded (2415919681 > 2147483647)? I'm getting this error while trying to execute this SQL statement with string column: select USER_NAME from aaa1; SMA: Maximum-Sys-Allocation Exceeded (2415919681 > 2147483647) terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc

[Lelik13a]

No.

[TunaBozkirr]

@Lelik13a how did you connect odbc with clickhouse?