tomekw/hikari-cp

need informix datasource

Closed this issue · 3 comments

cashmerelandscapes commented

Hi I've cloned the repo and added the informix datasource. what else do I need to do apart from testing with an informix database?

tomekw commented

@cashmerelandscapes AFAIK you need the datasource name and the Informix DB driver in the classpath.

Does it answer your question?

cashmerelandscapes commented

yep however you dont have it your adapters.Also I added it but when I use
it I get a datasource not found error does that mean I have to set my
informix jdbc maven name like the datasource fqdn name?

(def uccxhr-options {:username "uccxwallboard"

 #_=>                            :password              "Cisco12345"

 #_=>                            :database-name         "db_cra"

 #_=>                            :server-name

"atea_dev_uccx11"

 #_=>                            :port-number           1504

 #_=>                             :adapter    "informix"})

#'edge.db/uccxhr-options

edge.db=> (def uccxhr-src (make-datasource uccxhr-options))

clojure.lang.Compiler$CompilerException: java.lang.RuntimeException:
java.lang.ClassNotFoundException: com.informix.jdbcx.IfxDataSource,
compiling:(boot.user1758748878520355008.clj:1:17)

         java.lang.RuntimeException: java.lang.ClassNotFoundException:

com.informix.jdbcx.IfxDataSource

   java.lang.ClassNotFoundException: com.informix.jdbcx.IfxDataSource

when I use jdbc-url I also get an error

(def uccxhr-options {:username "uccxwallboard"

 #_=>                            :password      "Cisco12345"

 #_=>                           :jdbc-url       "jdbc:informix-sqli://

9.1.1.162:1504/db_cra:informixserver=atea_dev_uccx11_uccx"})

#'edge.db/uccxhr-options

edge.db=> (def uccxhr-src (make-datasource uccxhr-options))

                  clojure.lang.Compiler$CompilerException:

com.zaxxer.hikari.pool.HikariPool$PoolInitializationException:
Failed to initialize pool: com.informix.asf.IfxASFException: Attempt to
connect to database server (atea_dev_uccx11_uccx) failed.,
compiling:(boot.user1758748878520355008.clj:1:17)

com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to
initialize pool: com.informix.asf.IfxASFException: Attempt to connect to
database server (atea_dev_uccx11_uccx) failed.

                                    java.sql.SQLException:

com.informix.asf.IfxASFException:
Attempt to connect to database server (atea_dev_uccx11_uccx) failed.

                         com.informix.asf.IfxASFException: Attempt to

connect to database server (atea_dev_uccx11_uccx) failed.

                                 java.net.SocketException: Network is

unreachable

from my build.boot I have the jdbc driver as:

[org.clojars.frap66/hikari-cp "1.7.4"]

;; [duct/hikaricp-component "0.1.0"]

;;[clojure.jdbc/clojure.jdbc-hikari "0.3.3"]

[com.informix/ifxjdbc "4.10.JC6DE"]

Sorry not sure how datasource is suppose to work vai jdbc urls..

Gas gas@red-elvis.net
87 Campbell St
Karori 6012
Nouvelle Zelande
+64 4 9798840

2016-09-14 21:30 GMT+12:00 Tomek Wałkuski notifications@github.com:

@cashmerelandscapes https://github.com/cashmerelandscapes AFAIK you
need the datasource name and the Informix DB driver in the classpath.

Does it answer your question?

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#40 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AKx4554_O2DrQSutJXkOgSc4wNIHXasPks5qp76egaJpZM4J8kjH
.

tomekw commented

Closing due to inactivity. I'm sorry but I don't think any of us has access to Informix server.