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, oracle_home/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:
- Linux:
/opt/IBM/db2/V9.7/java
- Windows:
C:\Program Files\IBM\SQLLIB\java