Creating a PostgreSQL datasource with ColdFusion MX

Posted on 2009/05/03 by Balazs

To set up a PostgreSQL datasource for ColdFusion (CFMX), follow these steps:

  • Open CFMX administrator
  • Click on “Data Sources”
  • In the “add new datasource” write in a name and select “other” before clicking “add”
  • Fill our the fields as follows:
    CF Data Source Name: JDBC
URL: jdbc:postgresql://DB_server_fqdn:5432/ (as per Pedro's comment)
Driver Class: org.postgresql.Driver
Driver Name: PostgreSQL
Username: db_user_name
Password: ******
Description:
  • Click submit
  • Test connection (Status shoudl say “OK”)
This entry was posted in Java and tagged , , . Bookmark the permalink.
  • Anonymous

    Great post, thanks!

    One little correction, the URL should be “jdbc:postgresql://DB_server_name:5432/”, where DB_server_name is the hostname of the database server, or localhost if it’s the same machine.

    Cheers,

    Pedro.

NewPush has solutions to fit your business needs.  For more than a decade, our focus has been to take on the technical challenges that are the hardest and most time-consumming.  Our goal is to free up your resources to focus on the core activities of your business and to drive your business performance.  Please visit our main site at newpush.com for more information or call us at +1-303-423-4500.