{"id":536,"date":"2017-06-17T19:12:59","date_gmt":"2017-06-17T23:12:59","guid":{"rendered":"http:\/\/www.amixa.com\/blog\/?p=536"},"modified":"2017-06-20T21:51:11","modified_gmt":"2017-06-21T01:51:11","slug":"coldfusion-with-postgresql-timeout-issue-when-setting-up-cf-data-source","status":"publish","type":"post","link":"https:\/\/www.amixa.com\/blog\/2017\/06\/17\/coldfusion-with-postgresql-timeout-issue-when-setting-up-cf-data-source\/","title":{"rendered":"Coldfusion with PostgreSQL – Timeout issue when setting up CF Data source"},"content":{"rendered":"

Upon trying to connect to a remote POSTGRESQL database server — which I can both PING fine and connect to using the Windows POSTGRESQL odbc 32 bit drivers —<\/p>\n

you get this error<\/p>\n

Connection verification failed for data source: mytest_post<\/span>
java.sql.SQLException: Timed out trying to establish connection<\/span>
The root cause was that: java.sql.SQLException: Timed out trying to establish <\/span>connection<\/span><\/p>\n

==<\/p>\n

Here is the easy fix.\u00a0 (presumtion of CF 10)<\/p>\n

    \n
  1. make sure you apply the most current CF hotfix\n
      \n
    1. easy process – read this blog post<\/a><\/li>\n<\/ol>\n<\/li>\n
    2. \u00a0for an “out-of-the-box” setup, (noting that CF 10 is running on JRE 6.x), download the JDBC driver version 4.0 (which is for JRE 6.x)\u00a0 here<\/a><\/li>\n
    3. \u00a0put that JAR file in the following directory\n
        \n
      1. C:\\ColdFusion10\\cfusion\\lib<\/li>\n
      2. remove the old POSTGRESQL JAR file postgresql-9.3-1101.jdbc41.jar<\/li>\n
      3. restart the CF services<\/li>\n<\/ol>\n<\/li>\n
      4. Go setup the postgreSQL connection and verify it.\u00a0 Should now give you an “OK”<\/li>\n<\/ol>\n

        This was a NIGHTMARE to sort out.\u00a0 I am hoping this can help someone!<\/p>\n

         <\/p>\n","protected":false},"excerpt":{"rendered":"

        Upon trying to connect to a remote POSTGRESQL database server — which I can both PING fine and connect to using the Windows POSTGRESQL odbc 32 bit drivers — you get this error Connection verification failed for data source: mytest_postjava.sql.SQLException: Timed out trying to establish connectionThe root cause was that: java.sql.SQLException: Timed out trying to establish connection == Here is<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[133,132,8],"class_list":["post-536","post","type-post","status-publish","format-standard","hentry","category-windows-server","tag-coldfusion","tag-coldfusion-10","tag-microsoft-windows-server"],"_links":{"self":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/comments?post=536"}],"version-history":[{"count":2,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/536\/revisions"}],"predecessor-version":[{"id":540,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/536\/revisions\/540"}],"wp:attachment":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/media?parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/categories?post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/tags?post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}