JDBC providers used with ArcGIS Spatial Data Server for Java

Java DataBase Connectivity (JDBC) is an application programming interface (API) for the Java programming language. It defines how clients access a database and provides methods for querying and updating data in a database.

Download the JDBC provider required for the database you will use with the ArcGIS Spatial Data Server. See the ArcGIS Spatial Data Server System Requirements for the most up-to-date list of supported JDBC drivers.

PostgreSQL

Download the PostgreSQL 9.0 Build 8xx JDBC4 driver:

postgresql-9.0-8xx.jdbc4.jar

One place you can get this from is http://jdbc.postgresql.org/download.html.

Oracle

The Spatial Data Server for Java supports the Oracle 11g Release 2 ojdbc6.jar (version 11.2.0.2 or 11.2.0.3) driver. You can get this from the Oracle installation directory of your Oracle database, ORAHOME/jdbc/lib/ojdbc6.jar, or from Oracle's website.

DB2

You need the DB2 jar file, db2jcc4.jar (version 4.11.77). This can be found in the java folder of the DB2 installation directory of your DB2 database. The default locations are as follows:

8/21/2012