PSQL JDBC Support
JDBC is a standard API that Java programmers can use to develop database and Internet applications using Java. It consists of interfaces to develop SQL based database applications in the Java programming language. The JDBC interfaces are included as part of the Java Developer Kit.
JDBC is the counterpart of ODBC in Java and is heavily influenced by ODBC and relational databases.
Detailed information on the JDBC API is available at Oracle’s website.
JDBC Requirements
The PSQL JDBC driver works in conjunction with PSQL. You can use the Server, Vx Server, or Workgroup engines.
JDBC Features
The following is a summary of features of the PSQL JDBC driver:
•
100% Java certified
•
JDBC 2 compliant, type 4 driver
with some JDBC 3 and JDBC 4 support
•
Supports thread safe operation
•
Supports transactions isolation levels supported by the PSQL engine, for example READ_COMMITTED, serializable
•
Performs result set caching to reduce network access
•
Supports binary data through the longvarbinary data type (2 GB limit)
•
Supports long char data through the longvarchar and nlongvarchar data types (2 GB limit)
•
Supports stored procedures with parameters
•
Encrypts connection strings to provide security
•
Support for code page filtering when reading from the database by specified the code page using a connection string parameter
•
Support for result set cursors CONCUR_UPDATABLE, TYPE_SCROLL_INSENSITIVE, and TYPE_SCROLL_SENSITIVE
•
Supports the DataSource interface to register PSQL databases in JNDI, shielding your applications from specific driver features for PSQL
•
Supports the ParameterMetaData interface