LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  JDBC/ODBC connection problem with PostgreSQL database

    Employee
    Posted 02-28-2012 22:10

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ashishkghosh

    We have database PostgreSQL where we want to upload data from MDA.

    We are trying to get the necessary JDBC driver files.

    In the mean time, please help us understand how to configure the graph to connect to this database.


    Relevant point to be highlighted:

    1. How/where to deploy the driver fro MDA to pick up.

    2. How to configure details of this DB.


    BR//
    Ashish


  • 2.  RE: JDBC/ODBC connection problem with PostgreSQL database

    Employee
    Posted 02-29-2012 14:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    The details of the database and path has much to do with the driver you are using, so I would first look at the documentation on the Node and the JDBC driver documentation.

    The driver doc should provide you with the information you need to populate the two parameters, DbUrl and DbDriver, using the database information (machine name or ip address, probably).

    As to where you want to put the driver, go to the install directory, there should be a lib/java directory. Create the directory "ext" under lib/java (if it isn't already there), and you can put the driver jar file there. In some older installations, there is a Java/lib directory in the install directory, instead of lib/java, but similarly, you would create a Java/lib/ext directory there.

    Cheers
    Rich