ColdFusion and PostgreSQL 8

by @jehiah on 2005-01-22 15:03UTC
Filed under: All , ColdFusion

It was easier than I thought to setup ColdFusion 6.1 to talk to the new PostgreSQL 8.0 which was just released.

  1. Download the 8.0 driver for JDBC3
  2. Save the jar file in {jrun_root}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib (or somewhere else in your classpath)
  3. Restart ColdFusion
  4. Setup the ColdFusion Data Source
    1. In the ColdFusion Admin add data source as type other
    2. Setup the JDBC URL jdbc:postgresql://localhost/database where database is the name of the database (duh), and localhost is the name of the database server. More details on setting up the JDBC URL are here
    3. Set both Driver Class and Driver Name to org.postgresql.Driver
    4. I used the username and password as postgres because coldfusion doesn’t like them blank; but you can configure Postgresql to accept something else.
Subscribe via RSS ı Email
Jehiah Czebotar