Hi Shantanu, Thanks for the inputs. I was able to resolve the problem by changing the version of mysql-java-connector library to 5.1.29. I was previously using 6.0.2 (latest). Regards, Sunil
On Mon, May 2, 2016 at 7:04 PM, Sunil S Nandihalli < sunil.nandiha...@gmail.com> wrote: > Hi Shantanu, > I am attaching the error stack trace of the exception I got. I am still > unable to figure out what is happening. > Thanks, > sunil. > > On Mon, May 2, 2016 at 1:22 PM, Sunil S Nandihalli < > sunil.nandiha...@gmail.com> wrote: > >> Thanks Shantanu for the response. I installed dbvisualizer and it seems >> to work perfectly fine with infobright. >> >> >> >> On Mon, May 2, 2016 at 1:04 PM, Shantanu Kumar <kumar.shant...@gmail.com> >> wrote: >> >>> Could you try connecting to InfoBright using DbVisualizer? It is a Java >>> based tool and any differences w.r.t. the MySQL JDBC driver would be >>> evident if it fails to work with DbVisualizer. >>> >>> https://www.dbvis.com/ >>> >>> Shantanu >>> >>> >>> On Monday, 2 May 2016 12:48:16 UTC+5:30, Sunil Nandihalli wrote: >>>> >>>> Hi Everybody, >>>> I have tried to connect to infobrite server using clojure.java.jdbc . >>>> Infobrite server is supposed to be identical to mysql in terms of the >>>> protocol. I have successfully used mysqlworkbench to talk to it. When I try >>>> to connect to the infobrite server using clojure.java.jdbc, I get the >>>> following exception >>>> >>>> java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is >>>> required >>>> >>>> however if I use the exact same code to query a mysql db it works >>>> perfectly fine. Can somebody help please me with this? >>>> Thanks and regards, >>>> Sunil. >>>> >>>> The code i use is >>>> >>>> (ns cpi.core >>>> (:require [clojure.java.jdbc :as jdbc] >>>> [clojure.string :as s])) >>>> >>>> (defn run-query [{:keys [url user password db] :as cnf} & qs] >>>> (println qs) >>>> (println cnf) >>>> (jdbc/with-db-connection [db-conn {:classname "com.mysql.jdbc.Driver" >>>> :subprotocol "mysql" >>>> :subname (str "//" url "/" db) >>>> :user user >>>> :password password}] >>>> (jdbc/query db-conn qs))) >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Clojure" group. >>> To post to this group, send email to clojure@googlegroups.com >>> Note that posts from new members are moderated - please be patient with >>> your first post. >>> To unsubscribe from this group, send email to >>> clojure+unsubscr...@googlegroups.com >>> For more options, visit this group at >>> http://groups.google.com/group/clojure?hl=en >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "Clojure" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to clojure+unsubscr...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en --- You received this message because you are subscribed to the Google Groups "Clojure" group. To unsubscribe from this group and stop receiving emails from it, send an email to clojure+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
