clojure.java.jdbc lazy query

by

First, see https://jdbc.postgresql.org/documentation/83/query.html#query-with-cursor.

Solved it like this.

(jdbc/with-db-transaction [tx connection]
  (jdbc/query tx
    [(jdbc/prepare-statement (:connection tx)
                              "select * from mytable"
                              {:fetch-size 10})]
     {:result-set-fn (fn [result-set] ...)}))

where :result-set-fn is a function that consumes the lazy result set.

with-db-transaction takes care of autoCommit set to false.
:fetch-size is not passed from query so you have to make a prepare-statement yourself.

More Related Contents:

  1. The infamous java.sql.SQLException: No suitable driver found
  2. ClassNotFoundException with PostgreSQL and JDBC
  3. PostgreSQL jsonb, `?` and JDBC
  4. What is PostgreSQL equivalent to autoincrement?
  5. How do I specify a password to ‘psql’ non-interactively?
  6. INSERT with dynamic table name in trigger function
  7. psql: FATAL: Ident authentication failed for user “postgres”
  8. Use multiple conflict_target in ON CONFLICT clause
  9. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  10. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  11. How to find table creation time?
  12. What is the format for the PostgreSQL connection string / URL?
  13. Go and IN clause in Postgres
  14. Where does PostgreSQL store the database?
  15. How to add “on delete cascade” constraints?
  16. Grant all on a specific schema in the db to a group role in PostgreSQL
  17. Can I make a plpgsql function return an integer without using a variable?
  18. Migrate database from Postgres to MySQL [closed]
  19. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  20. Why can I create a table with PRIMARY KEY on a nullable column?
  21. Oracle SQL Developer and PostgreSQL
  22. PostgreSQL array of elements that each are a foreign key
  23. Differentiate inserted and updated rows in UPSERT using system columns
  24. Postgres ERROR: could not open file for reading: Permission denied
  25. Custom ORDER BY Explanation
  26. Configure JPA to let PostgreSQL generate the primary key value
  27. How can I send some http request from postgresql function or trigger
  28. How to delete an enum type value in postgres?
  29. Why unsigned integer is not available in PostgreSQL?
  30. now() default values are all showing same timestamp

Leave a Comment