This document contains the following topics:
The Pervasive PSQL v9 JDBC driver is a Type 4, 100% Pure JavaTM certified client driver. The driver supports the JDBCTM 2.0 standard. As it is a certified 100% Pure JavaTM driver, it will work on all platforms that support the JVM.
Pervasive PSQL v9 JDBC driver is a thin client that does the bare minimum amount of processing and relies on the server for the core processing logic like syntax analysis, query processing etc. Communication to the Pervasive SQL Server is via the server's native LNA network protocol.
Additional information on JDBC is available on the Javasoft JDBC web page: http://java.sun.com/products/jdbc
The JDBC driver for Pervasive PSQL is shipped with the Pervasive PSQL engine. This Pervasive PSQL SDK release adds the following JDBC resources:
The JDBC driver is shipped with the Pervasive PSQL engine. This release installs samples and documentation for the driver. See the following JDBC section of the Developer Center for more information: http://www.pervasive.com/developerzone/access_methods/jdbc.asp
The following components are in the
bin directory. These files
need to be included in the the
bin directory of your Pervasive PSQL
engine. For example, assuming a default installation,
on Windows and
/usr/local/psql/bin on Linux.
So that Java applications and applets recognize the Pervasive PSQL JDBC Driver, set your CLASSPATH environment variable to include the pvjdbc2.jar, pvjdbc2x.jar, and jpscs.jar files.
set CLASSPATH=%CLASSPATH%;<path to pvjdbc2.jar directory> /pvjdbc2.jar set CLASSPATH=%CLASSPATH%;<path to pvjdbc2x.jar directory> /pvjdbc2x.jar set CLASSPATH=%CLASSPATH%;<path to jpscs.jar directory> /jpscs.jar
export CLASSPATH=$CLASSPATH:<path to pvjdbc2.jar directory> /pvjdbc2.jar export CLASSPATH=$CLASSPATH:<path to pvjdbc2x.jar directory> /pvjdbc2x.jar export CLASSPATH=$CLASSPATH:<path to jpscs.jar directory> /jpscs.jar
Windows Only. Typically, the system path is properly set at installation. However, under certain circumstances it might be necessary to set it directly.
set PATH=%PATH%;<path to pvjdbc2.jar directory> /pvjdbc2.dll
Loading the Pervasive JDBC Driver into the Java Environment
After setting the CLASSPATH, you can now reference the Pervasive JDBC Driver from your Java application. You do this by using the java.lang.Class class:
After loading the PervasiveDriver class into your Java environment, you need to pass a URL-style string to the java.sql.DriverManager class to connect to a Pervasive PSQL database. The syntax for URL for the Pervasive JDBC driver is:
|<machinename>||is the host name or IP address of the machine that runs the Pervasive DB Server|
|<portnumber>||is the port on which the Pervasive DB Server is listening – by default it is 1583|
|<datasource>||is the name of the ODBC DSN on the Pervasive database server that the application intends to use.|
For example, if your Pervasive PSQL engine is on a machine named DBSERV, and you wish to connect to the DEMODATA database, your URL would look like this (assuming the server is configured to use the default port):
So to connect to the database using the DriverManager class, you would use the syntax:
Connection conn = DriverManager.getConnection("jdbc:pervasive://DBSERV:1583/DEMODATA", loginString, passwordString);
...where "loginString" is the string that represents a user login and "passwordString" is the string that represents a user password.
Note: The Pervasive PSQL engine must be running on the specified host in order for JDBC applets and applications to access data.
To develop web based applications using JDBC, you need to place the JDBC jar file in the codebase directory containing the applet classes.
For example, if you are developing an application called MyFirstJDBCapplet, you need to place the pvjdbc2.jar file in the directory containing the MyFirstJDBCapplet class. For example, it might be C:\inetpub\wwwroot\myjdbc\.
This enables the client web browser to be able to download the JDBC driver over the network and connect to the database.
You also need to put the archive parameter within the <APPLET> tag. For example:
<applet CODE="MyFirstJDBCapplet.class" ARCHIVE="pvjdbc2.jar" WIDTH=641 HEIGHT=554>
The following are known issues with this release.
Discuss all your Pervasive development issues at DevTalk at http://www.pervasive.com/devtalk.
See some creative applications and code snippets and share your own at Pervasive ComponentZone at http://www.pervasive.com/componentzone.
PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUMENTATION
PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN
ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE
PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS FOR ANY PARTICULAR PURPOSE OR ARISING FROM COURSE OF DEALING OR USAGE OF TRADE, AMONG OTHERS.
Copyright © 1999-2006 Pervasive Software Inc. All Rights Reserved.