Pervasive PSQL JDBC Support
JDBC is the standard API that Java programmers use to develop database and Internet applications using Java. JDBC is included in Sun Microsystems’s Java Developer Kit in versions 1.1 and higher. JDBC is a package that primarily consists of interfaces that developers can use to develop SQL based database applications using the Java programming language.
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 java.sun.com.
JDBC Requirements
The Pervasive JDBC driver works in conjunction with Pervasive PSQL. You can use the Server or Workgroup engines.
JDBC Features
The following is a summary of features of the Pervasive JDBC driver:
•
100% Java certified
•
JDBC 2 compliant, type 4 driver
•
Supports thread safe operation
•
Supports transactions isolation levels supported by the Pervasive 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 data types (2 GB limit)
•
Supports stored procedures with parameters
•
Encrypts connection strings to provide security
•
Transmits data flows between the server and client in a native binary format that is nontrivial to decode for added security