search

ClickHouse / clickhouse-java

ClickHouse Java Clients & JDBC Driver
https://clickhouse.com
Apache License 2.0
1.44k stars 529 forks source link

Configure oracle WebLogic server with clickhouse-jdbc driver. #438

Open Lelik13a opened 4 years ago

Lelik13a commented 4 years ago

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 commented 4 years ago

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

bas-ter commented 4 years ago

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 commented 4 years ago

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

bas-ter commented 4 years ago

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 commented 4 years ago

No.

TunaBozkirr commented 1 year ago

@Lelik13a how did you connect odbc with clickhouse?