PostgreSQL Connection

[Guest]

Hi

I'm trying to connect to a Postgres DB (Version 8.2) from ColdFusion MX 7 (7.0.2). Both are located on the same machine, so TCP/IP Connection should be working fine.
Apart I followed the instructions in the TechNote 18338 to get the JDBC Driver recognized by CF and also set up the datasource accordingly. However now I get the following error:

Connection verification failed for data source: mytest_post
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection

Can anyone help? A friend of mine is getting the same error with the software configuration

thanks in advance

thomas

[Newsgroup_User]

t_ray wrote:
>
> I'm trying to connect to a Postgres DB (Version 8.2) from ColdFusion MX 7
> (7.0.2). Both are located on the same machine, so TCP/IP Connection should be
> working fine.
> Apart I followed the instructions in the TechNote 18338 to get the JDBC
> Driver recognized by CF and also set up the datasource accordingly.

What exactly did you fill out in the different fields in the Administrator?

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion

[Guest · Accepted solution]

The connection works fine now that we use another driver:
apparently the JDBC version IV (8.2_505) driver does not work, the version III driver works fine

thank you for the help offered!

Thomas

[Kronin555]

On the download page:
http://jdbc.postgresql.org/download.html

"JDK 1.4, 1.5 - JDBC 3. This contains support for SSL and javax.sql, but does not require J2EE as it has been added to the J2SE release.
JDK 1.6 - JDBC4. Support for JDBC4 methods is limited. The driver builds, but the majority of new methods are stubbed out. "

So the v. 4 driver won't work unless you're running on JDK 1.6