metanoid

Results 18 comments of metanoid

> Yeah, I was about to say, can you just use the low level functions > > ``` > stmt = createStatement(conn) > rs = executeQuery(stmt, myquery) > for r...

The below seems to work for my needs: ```julia df_schema = Tables.schema(src) df = DataFrame(collect(df_schema.types), collect(df_schema.names)) for i in rows(csr) push!(df, i) end ```

I have: ``` java version "1.8.0_212" Java(TM) SE Runtime Environment (build 1.8.0_212-b10) Java HotSpot(TM) 64-Bit Server VM (build 25.212-b10, mixed mode) ``` I can try figure out similiar java code,...

This essentially equivalent code works in R on the same machine. ```R library(RJDBC) drv = JDBC(driverClass = "org.netezza.Driver", classPath = "C:/JDBC/nzjdbc.jar") conn = dbConnect(drv, paste0("jdbc:netezza://DCP:5480/db;user=",username,";password=",pwd)) dbListTables(conn) a = dbGetQuery(conn, "SELECT...

Unfortunately no Java stack trace is shown - maybe there's a way to make Java more verbose? ```julia julia> versioninfo() Julia Version 1.2.0 Commit c6da87ff4b (2019-08-20 00:03 UTC) Platform Info:...

> Ah could you please try with Julia 1.0.x? There are some issues with threading and Julia 1.1/1.2 Julia 1.0.5 (LTS) works for the above - thanks!

Testing on Julia 1.3.0, and this is still an issue. Error message seems more informative now? ```julia julia> cnxn = JDBC.Connection("jdbc:oracle:thin:@$(hostname):$(port)/$(service_name)", props = Dict("user" => ENV["oracle_user"], "password" => ENV["oracle_pwd"])) Exception...

[CLOBs](https://docs.oracle.com/javadb/10.10.1.2/ref/rrefclob.html) would also be very helpful