This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
- # admin-announcements (19)
- # announcements (1)
- # beginners (70)
- # boot (192)
- # braid-chat (55)
- # cider (3)
- # cljs-dev (42)
- # cljsjs (2)
- # cljsrn (25)
- # clojars (23)
- # clojure (162)
- # clojure-brasil (3)
- # clojure-czech (18)
- # clojure-russia (10)
- # clojurecup (3)
- # clojurescript (63)
- # code-reviews (6)
- # community-development (340)
- # core-async (7)
- # cursive (4)
- # datomic (20)
- # events (2)
- # funcool (3)
- # hoplon (20)
- # jobs (33)
- # ldnclj (11)
- # lein-figwheel (9)
- # leiningen (6)
- # off-topic (1)
- # om (79)
- # proton (4)
- # re-frame (39)
- # ring-swagger (4)
- # slack-help (2)
- # yada (2)
some-> instead of
-> at least stops if it hits nil - which isn't error checking per-se but sometimes it is all you need
hoopes: also, instead of checking explicitly for errors, we typically have exceptions and exception handlers when runtime errors are an issue
so the whole let block can be in a try/catch and then you could potentially throw at each step if there is a problem
hoopes: in practice having to opt-out of short circuiting on errors (via try) leads to better reliability than having to opt-in to checking for errors
Hey, new to clojure and the whole thing, probably a stupid question but I want to require a package only for the repl to try it out, how can I achieve that?
@donaldball: yeah, I am using lein but I can’t figure out the command with lein to do it even...
oooh, now I get what you meant. I didn’t understand you mentioned a plugin called “lein try”, thought you meant that "people use lein for that, try it"
haha, don’t worry, thanks for trying to help @donaldball! Sorry for not understanding you correctly
Has anyone dealt with this error? SQLException No suitable driver found for jdbc:sqlserver:
And if you have can you please help me get around it? I have been fighting it for a day and I can't afford more time but it is stopping my progress.
I have added the jar to my classpath and when I try
(. System getProperty "java.library.path") C:\\Program Files\\Java\\JDBC\\sqljdbc_4.1\\enu\\sqljdbc4.jar; is part of the path
CompilerException java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
tbqh I think clojure does that automatically when it tries to resolve a class, but you could try
Though curses, that’s not much help because maven doesn’t have an artifact for sqljdbc
That might at least let you make some progress until you can sort out your classpath issue with the Microsoft driver
Clojure.java.jdbc has some instructions for installing the Microsoft driver in your local maven repository: https://github.com/clojure/java.jdbc#releases-and-dependency-information
Re: MS SQL Server driver — it’s free to download and you can install it into your local Maven repo cache with
That’s how I test
clojure.java.jdbc against SQL Server. I have the Microsoft driver installed locally (on my Mac) and then just depend on it in
project.clj like all the other drivers I test against.
You can d/l the MS JDBC driver here: https://www.microsoft.com/en-us/download/details.aspx?id=11774&displaylang=en
@donaldball: I am now dealing with this: # # A fatal error has been detected by the Java Runtime Environment: # # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x000000006f577797, pid=12708, tid=20412 # # JRE version: Java(TM) SE Runtime Environment (8.0_66-b18) (build 1.8.0_66-b18) # Java VM: Java HotSpot(TM) 64-Bit Server VM (25.66-b18 mixed mode windows-amd64 compressed oops) # Problematic frame: # V [jvm.dll+0x67797] # # Failed to write core dump. Minidumps are not enabled by default on client vers ions of Windows
That is not good. Core dump tends to indicate a JVM bug or something wrong in native code.
I’d immediately be suspicious of the sqlserver driver, but @seancorfield has pretty good test in clojure.java.jdbc iirc
Folk on this thread suggest the jdbc uri format is finicky: http://stackoverflow.com/questions/27641775/a-fatal-error-has-been-detected-by-the-java-runtime-environment-microsoft-sql
ok here we go I have a new error: Jan 08, 2016 4:11:52 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit> WARNING: Failed to load the sqljdbc_auth.dll cause :- no sqljdbc_auth in java.library.path
that's likely the reason for the JNI failure. When you pulled down the sqlserver jdbc driver it should have also come with that sqljdbc_auth.dll file (a native Windows DLL). stick that file into your windows/system32 directory.
if you run the app again it should progress beyond the failure to load the underlying native code.
though a "type 4" jdbc driver- what microsoft reports you are downloading from that url- is supposed to be 100% java and not have native code dependencies.
Yeah the driver I test with is pure Java (since I deliberately test connecting to SQL Server from a non-Windows machine).
we determined that the reason the type4 driver was pulling in native code was because of the "integratedSecurity" configuration- which uses native windows authentication and authorization mechanisms between the app and the database rather than name/password credentials
with integratedSecurity=truthy the driver expects to find an appropriate sqljdbc_auth.dll
what's likely happening is that the jdbc and native driver versions were different
Ah, interesting. Never run into that. Aside from testing, I generally avoid Microsoft anything :)
yeah, absolutely. striking though that for beginners, having clojure be a "hosted" language in this particular case leads to this perfect storm of nasty platform dependencies- the java/maven ecosystem, java's funky native platform integration, and the dependency nightmare that is windows
There are definitely some added issues using Windows, but I've actually run into way less problems with Windows dependencies on when developing Clojure than .NET.
Main problem I've run into is closing files - seems like things that work elsewhere don't actually close files properly on Windows.
interesting. does it support that native authentication stuff? or only conventional username/password?
I've never tried, but according to http://stackoverflow.com/a/801113 it looks like it supports native auth as well