Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- % lein --version
- Leiningen 2.3.4 on Java 1.7.0_45 OpenJDK Client VM
- --
- % cat project.clj
- (defproject testdb "0.1.0-SNAPSHOT"
- :dependencies [[org.clojure/clojure "1.5.1"]
- [org.clojure/java.jdbc "0.3.3"]
- [com.microsoft.sqlserver/sqljdbc4 "4.0"]
- [net.sourceforge.jtds/jtds "1.2.4"]
- [local/ojdbc6 "11.2.0.3"]])
- --
- % cat src/testdb/core.clj
- (ns testdb.core
- (:require [clojure.java.jdbc :as jdbc]))
- #_(def db-spec
- {:classname "net.sourceforge.jtds.jdbc.Driver"
- :subprotocol "jtds:sqlserver"
- :subname "//xxx.xxx.xxx.xxx:1433;database=xxx;user=xxx;password=xxx"})
- #_(def db-spec
- {:classname "com.microsoft.jdbc.sqlserver.SQLServerDriver"
- :subprotocol "sqlserver"
- :subname "//xxx.xxx.xxx.xxx:1433;database=xxx;user=xxx;password=xxx"})
- (def db-spec
- {:classname "oracle.jdbc.OracleDriver"
- :subprotocol "oracle"
- :subname "thin:@//xxx.xxx.xxx.xxx:1521/xxx"
- :user "xxx"
- :password "xxx"})
- (take 10 (jdbc/query oracle
- [{:fetch-size 100
- :concurrency :read-only
- :result-type :forward-only}
- "select * from very_large_table"]))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement