mime-version: 1.0 date: Fri, 25 Jun 2010 16:38:42 -0500 content-transfer-encoding: quoted-printable content-location: http://ww1.pervasive.com/developerzone/access_methods/readme_jdbc.html x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.5931 from: subject: Pervasive PSQL v9 JDBC content-type: text/html; charset="Windows-1252" Readme PSQL v9 JDB= C

Pervasive PSQL v9 JDBC - May 2006

This document contains the following topics:

About the Pervasive JDBC Driver

The Pervasive PSQL v9 JDBC driver is a Type 4, 100% Pure JavaTM certified client driver. The driver supports the= =20 JDBCTM 2.0 standard. As it is a certifie= d 100%=20 Pure JavaTM driver, it will work on all= =20 platforms that support the JVM.=20

Pervasive PSQL v9 JDBC driver is a thin client that does the bare minim= um=20 amount of processing and relies on the server for the core processing logi= c like=20 syntax analysis, query processing etc. Communication to the Pervasive SQL = Server=20 is via the server's native LNA network protocol.=20

Additional information on JDBC is available on the Javasoft JDBC web pa= ge: http://java.sun.com/products/jd= bc=20

The JDBC driver for Pervasive PSQL is shipped with the Pervasive PSQL e= ngine.=20 This Pervasive PSQL SDK release adds the following JDBC resources:=20

Features

System Requirements

Getting Started

Installation

The JDBC driver is shipped with the Pervasive PSQL engine. This release= =20 installs samples and documentation for the driver. See the following JDBC= =20 section of the Developer Center for more information: http://www.pervasive.com/developerzone/access_methods/jdbc.a= sp=20

Components Updated

The following components are in the bin directory. These f= iles=20 need to be included in the the bin directory of your Pervasiv= e PSQL=20 engine. For example, assuming a default installation, c:\pvsw\bin=20 on Windows and /usr/local/psql/bin on Linux.

Component

pvjdbc2.dll

pvjdbc2.jar

pvjdbc2x.jar

jpscs.jar

Setting the CLASSPATH

So that Java applications and applets recognize the Pervasive PSQL JDBC= =20 Driver, set your CLASSPATH environment variable to include the pvjdbc2.jar= ,=20 pvjdbc2x.jar, and jpscs.jar files.=20

From Windows: 

set CLASSPATH=3D%CLASSPATH%;<path to pvjdb=
c2.jar directory>
     /pvjdbc2.jar

set CLASSPATH=3D%CLASSPATH%;<path to pvjdbc2x.jar directory>
     /pvjdbc2x.jar

set CLASSPATH=3D%CLASSPATH%;<path to jpscs.jar directory>
     /jpscs.jar

From Linux: 

export CLASSPATH=3D$CLASSPATH:<path to pvjdb=
c2.jar directory>
     /pvjdbc2.jar

export CLASSPATH=3D$CLASSPATH:<path to pvjdbc2x.jar directory>
     /pvjdbc2x.jar

export CLASSPATH=3D$CLASSPATH:<path to jpscs.jar directory>
     /jpscs.jar

Setting the SYSTEM PATH

Windows Only. Typically, the system path is properly set at installatio= n.=20 However, under certain circumstances it might be necessary to set it direc= tly.=20

From Windows: 

set PATH=3D%PATH%;<path to pvjdbc2.jar dir=
ectory>
     /pvjdbc2.dll

Loading the Pervas= ive JDBC=20 Driver into the Java Environment=20

After setting the CLASSPATH, you can now reference the Pervasive JDBC D= river=20 from your Java application.  You do this by using the java.lang.Class= =20 class: 

Class.forName("com.pervasive.jdbc.v2.Driver");

Specifying a Data Source

After loading the PervasiveDriver class into your Java environment, you= need=20 to pass a URL-style string to the java.sql.DriverManager class to connect = to a=20 Pervasive PSQL database.  The syntax for URL for the Pervasive JDBC d= river=20 is: 

jdbc:pervasive://<machinename>:<portnumber>/<datas=
ource>
<machinename> is the host name or IP address of the machine that runs the Pervas= ive=20 DB Server
<portnumber> is the port on which the Pervasive DB Server is listening =96 by d= efault=20 it is 1583
<datasource> is the name of the ODBC DSN on the Pervasive database server that = the=20 application intends to use.

For example, if your Pervasive PSQL engine is on a machine named DBSERV= , and=20 you wish to connect to the DEMODATA database, your URL would look like thi= s=20 (assuming the server is configured to use the default port): 

jdbc:per=
vasive://DBSERV/DEMODATA

So to connect to the database using the DriverManager class, you would = use=20 the syntax: 

Connection conn =3D
          DriverManager.getConnection("jdbc:pervasive://DBSERV:1583/DEMODA=
TA",
          loginString, passwordString);

...where "loginString" is the string that represents a user login and=20 "passwordString" is the string that represents a user password.=20

Note: The Pervasive PSQL engine must be running on = the=20 specified host in order for JDBC applets and applications to access data.= =20

Developing JDBC Applets=

To develop web based applications using JDBC, you need to place the JDB= C jar=20 file in the codebase directory containing the applet classes.=20

For example, if you are developing an application called MyFirstJDBCapp= let,=20 you need to place the pvjdbc2.jar file in the directory containing the=20 MyFirstJDBCapplet class. For example, it might be C:\inetpub\wwwroot\myjdb= c\.=20

This enables the client web browser to be able to download the JDBC dri= ver=20 over the network and connect to the database.=20

You also need to put the archive parameter within the <APPLET> ta= g. For=20 example: 

<applet CODE=3D"MyFirstJDBCapplet.class"
        ARCHIVE=3D"pvjdbc2.jar" WIDTH=3D641 HEIGHT=3D554>
Note: The Pervasive PSQL v9 engine must be runnin= g on the=20 web server that hosts the applet.

Known Issues in this Release

The following are known issues with this release.

Issue Number Description
n/a n/a

Useful Links

Discuss all your Pervasive development issues at DevTalk at http://www.pervasive.com/devtalk= .=20

See some creative applications and code snippets and share your own at= =20 Pervasive ComponentZone at http://www.pervasive.com/c= omponentzone.=20

Disclaimer

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUME= NTATION=20 PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN=20 ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE=20 AGREEMENT.
PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER= ,=20 EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE=20 DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR = YOUR=20 COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRAN= TIES,=20 INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS= FOR=20 ANY PARTICULAR PURPOSE OR ARISING FROM COURSE OF DEALING OR USAGE OF TRADE= ,=20 AMONG OTHERS.

Copyright =A9 1999-2006 Pervasive Software Inc. All Rig= hts=20 Reserved.