Advertisement
Guest User

Clojure jdbc - lazy resultset

a guest
Feb 10th, 2014
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --
  2. % lein --version
  3. Leiningen 2.3.4 on Java 1.7.0_45 OpenJDK Client VM
  4.  
  5. --
  6. % cat project.clj
  7. (defproject testdb "0.1.0-SNAPSHOT"
  8.   :dependencies [[org.clojure/clojure "1.5.1"]
  9.                  [org.clojure/java.jdbc "0.3.3"]
  10.                  [com.microsoft.sqlserver/sqljdbc4 "4.0"]
  11.                  [net.sourceforge.jtds/jtds "1.2.4"]
  12.                  [local/ojdbc6 "11.2.0.3"]])
  13.  
  14. --
  15. % cat src/testdb/core.clj
  16. (ns testdb.core
  17.   (:require [clojure.java.jdbc :as jdbc]))
  18.  
  19. #_(def db-spec
  20.     {:classname "net.sourceforge.jtds.jdbc.Driver"
  21.      :subprotocol "jtds:sqlserver"
  22.      :subname "//xxx.xxx.xxx.xxx:1433;database=xxx;user=xxx;password=xxx"})
  23.  
  24. #_(def db-spec
  25.     {:classname "com.microsoft.jdbc.sqlserver.SQLServerDriver"
  26.      :subprotocol "sqlserver"
  27.      :subname "//xxx.xxx.xxx.xxx:1433;database=xxx;user=xxx;password=xxx"})
  28.  
  29. (def db-spec
  30.   {:classname "oracle.jdbc.OracleDriver"
  31.    :subprotocol "oracle"
  32.    :subname "thin:@//xxx.xxx.xxx.xxx:1521/xxx"
  33.    :user "xxx"
  34.    :password "xxx"})
  35.  
  36. (take 10 (jdbc/query oracle
  37.             [{:fetch-size 100
  38.               :concurrency :read-only
  39.               :result-type :forward-only}
  40.              "select * from very_large_table"]))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement