AMP and JDBC
06-06-2014 03:44 PM
|In most cases, we recommend Using_AMP's XML APIs if you're using anjother application to access AMP's data. This document describes connecting to AMP's built-in database with JDBC. Please keep in mind that the database schema changes very often from release to release.
There are JDBC drivers available at http://jdbc.postgresql.org/download.html . To know which driver to download you'll need to know which JDK version you're using and which version of PostgreSQL is running on AMP. You can tell the PostgreSQL version by connecting to the shell and entering this command:
# rpm -qa | grep postgresql
The server should already be set up to accept JDBC connections. If this is set:
tcpip_socket = true
in /var/lib/pgsql/data/postgresql.conf, then the server can accept JDBC connections.