JDBC.jl

JDBC.jl copied to clipboard

`executeQuery()` fails with `java.lang.NoClassDefFoundError`

7

Using a proprietary jdbc driver I experienced a `java.lang.NoClassDefFoundError`. It turned out that I could solve it by calling ```julia JDBC.JavaCall.init(["--add-opens=java.base/java.nio=ALL-UNNAMED"]) ``` instead of ```julia JDBC.init() ``` While the underlying...

hhaensel

This a PR to #62 for allowing the passing of parameters to `init()`. I chose to define constants rather than `using JavaCall: init` as I found that tab-completion did not...

hhaensel

Poor performance

9

[OraBench](https://github.com/KonnexionsGmbH/ora_bench) compares the performance of various Oracle database drivers and includes both [JDBC.jl](https://github.com/JuliaDatabases/JDBC.jl) and [Oracle.jl](https://github.com/felipenoris/Oracle.jl). There are 10 trials in each benchmark run. In each trial, 100000 rows are inserted...

walter-weinmann

Using the sqlite driver and the sample toursdb database, flights table (see package tests for details) ``` @time DataFrame(collect(JDBCRowIterator(rs))) 0.100710 seconds (451.67 k allocations: 20.420 MiB) @time JDBC.load(DataFrame, rs) 0.770983...

aviks

### Code: ``` @threads for partition_key = 1:benchmark_number_partitions println("multithreaded threadid=$(threadid())") run_select_helper( size(bulk_data_partitions[partition_key], 1), partition_key, sql_select, statements[partition_key], trial_number, ) end ``` Source: https://github.com/KonnexionsGmbH/ora_bench/blob/master/lang/julia/OraBenchJdbc.jl ### Protocol: always the same tread id !...

walter-weinmann

addBatch and executeBatch

2

Hi, I have tried to enhance the package, adding the functions ``` javascript addBatch(stmt::Union(JPreparedStatement, JCallableStatement)) = jcall(stmt, "addBatch", jint, Void, ()) executeBatch(stmt::Union(JPreparedStatement, JCallableStatement)) = jcall(stmt, "executeBatch", jint, Void, ()) ```...

krassimirkostadinov

Passing username and password as args?

4

# Problem description Hello, to my greater despair I have to work with a Pervasive SQL database. It seems the username and password are not passed to the java class...

ThibTrip

IllegalMonitorStateException on connection to Netezza DB

9

I'm trying to extract data from a Netezza database. I run the following: ```julia using JavaCall JavaCall.addClassPath("C:/JDBC/nzjdbc.jar") using JDBC JDBC.usedriver("C:/JDBC/nzjdbc.jar") JDBC.init() classforname("org.netezza.Driver") hostname = "hostname" port = "5480" database =...

metanoid

Support for IAM authentication with services like AWS Redshift etc.

1

As it wasn't documented, I'm not quite sure if this is already supported. It would be great to implement IAM authentication (in our example ADFS) to access AWS services like...

ggjersund

added decimal type

2

This fixes #53 by adding support for decimal types via Decimals.jl.

ExpandingMan