Collect JDBC Results

#1

I am trying to extract data from an Oracle JDBC connection. I have successfully connected and can put the data out and see it in the REPL. However I want to collect the println results of the iterator in an object. How do I go about collecting the results? I have created an empty tuple and tried to append/push the results in the tuple without success.

<>

oracle_statement = createStatement(oracle_connection) # Specify SQL Connection
oracle_query = executeQuery(oracle_statement, "SQL Statement ") # Specify SQL Query

for rows in JDBCRowIterator(oracle_query)
println(rows)
end

0 Likes