#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2001
    Location
    Chicago, IL
    Posts
    85
    Rep Power
    14

    Question Postgresql + CFMX


    Can anyone help me get CFMX running with Postgre? Does anyone have a good tutorial?
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    I have never used CFMX, but as I understand it, CFMX is heavy in Java connectivity, so I would imagine all you have to do is enable JDBC on PostgreSQL, and then you can connect just as you would with any other SQL system. Visit http://jdbc.postgresql.org/

    I'm sure CFMX supports ODBC also, so you could enable ODBC on PostgreSQL, although I think JDBC is a better choice if you can do it. Also, if you enable JDBC, there are quite a few nice reporting packages available.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    409
    Rep Power
    13

    Question


    Off the top of your head, are there any particular JDBC reporting packages that you have found useful?
  6. #4
  7. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    Here's a free one, which uses client-side Java: http://datavision.sourceforge.net/

    Here are a couple of web-based reporting suites which use Java:

    http://www.avman.net/
    http://www.quadbase.com/

    There is also a KDE reporting tool called Kugar, which you should be able to find at http://apps.kde.com (the site seems to be slashdotted right now). I don't know if Kugar uses JDBC, but anyway, it is a free reporting tool for KDE.

    We discuss this a little more at this thread.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    409
    Rep Power
    13

    Thumbs up


    Excellent!

    Thanks once again for sharing your brain!

IMN logo majestic logo threadwatch logo seochat tools logo