Readme JCL v9</TIT= LE> <META content=3D"text/html; charset=3Dwindows-1252" http-equiv=3DContent-T= ype> <META name=3DAUTHOR content=3D"Pervasive Software"> <META name=3DDESCRIPTION=20 content=3D"Information about the Pervasive Java Class Library"> <META name=3DOWNER content=3D"Pervasive Developer Solutions Team"> <STYLE>BODY { FONT-FAMILY: Verdana, Arial, Helvetica, MS Sans Serif; FONT-SIZE: 80%; MA= RGIN-RIGHT: 10em } A:link { FONT-FAMILY: Verdana; COLOR: #008000 } A:active { FONT-FAMILY: Verdana; COLOR: #8fbc8b } A:visited { FONT-FAMILY: Verdana; COLOR: #996699 } A:hover { BACKGROUND-COLOR: #996699; FONT-FAMILY: Verdana; COLOR: #ffffff } P { MARGIN-TOP: 0.6em; FONT-FAMILY: Verdana; MARGIN-BOTTOM: 0.6em; MARGIN-LEF= T: 1em } H1 { BORDER-BOTTOM: black solid; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 160% } H2 { MARGIN-TOP: 1.5em; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 140% } H3 { MARGIN-TOP: 1.2em; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 110%; xfont-size: 110% } H4 { MARGIN-TOP: 1.2em; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 105%; xfont-size: 105% } H5 { MARGIN-TOP: 1.2em; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 100% } BIG { FONT-SIZE: 105%; FONT-WEIGHT: bold } OL { MARGIN-TOP: 0.6em; MARGIN-BOTTOM: 0em; MARGIN-LEFT: 4em } UL { LIST-STYLE-TYPE: square; MARGIN-TOP: 0.6em; FONT-FAMILY: Verdana; MARGIN-= BOTTOM: 0em } UL UL { MARGIN-TOP: 0em } UL LI { FONT-FAMILY: Verdana } P LI { LIST-STYLE-TYPE: square; FONT-FAMILY: Verdana; MARGIN-BOTTOM: 0em } LI P { FONT-FAMILY: Verdana } TABLE { MARGIN-TOP: 1em; MARGIN-LEFT: 5em; FONT-SIZE: 100%; MARGIN-RIGHT: 5em; ce= ll-padding: 10 } TH { TEXT-ALIGN: left; FONT-FAMILY: Verdana; BACKGROUND: #d3d3d3; VERTICAL-ALI= GN: bottom } TR { VERTICAL-ALIGN: top } TD { FONT-FAMILY: Verdana; VERTICAL-ALIGN: top } STRONG { COLOR: maroon; FONT-WEIGHT: bold; TEXT-DECORATION: none } P.note { BORDER-BOTTOM: silver solid; BORDER-LEFT: silver solid; PADDING-BOTTOM: 1= %; BACKGROUND-COLOR: #ffffee; PADDING-LEFT: 1%; PADDING-RIGHT: 1%; MARGIN-= LEFT: 10em; BORDER-TOP: silver solid; MARGIN-RIGHT: 10em; BORDER-RIGHT: si= lver solid; PADDING-TOP: 1% } PRE { MARGIN-TOP: 1.2em; FONT-FAMILY: Courier; MARGIN-BOTTOM: 1.5em; COLOR: blu= e; MARGIN-LEFT: 5em; FONT-SIZE: 70% } CODE { FONT-FAMILY: Courier; COLOR: blue; FONT-SIZE: 70% } P.question { =09 } </STYLE> <META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18928">  </HEAD> <BODY> <H1>Pervasive PSQL v9 Java Class Library (JCL) - May 2006</H1> <P>This document contains the following topics: </P> <UL> <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#AboutThisUpdat= e">About=20 Java Class Library</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#Requirements">= System=20 Requirements</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#Started">Getti= ng=20 Started</A>=20 <UL> <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_P= ervasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#install">Ins= tallation</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_P= ervasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#new">New=20 in Pervasive PSQL v9</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_P= ervasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#comps">Compo= nents=20 List</A> </LI></UL> <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#Problems">Know= n=20 Issues</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#links">Useful= =20 Links</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#disclaimer">Di= sclaimer</A>=20 </LI></UL> <HR> <H2><A name=3DAboutThisUpdate></A>About Java Class Library</H2> <P>Java Class Library (JCL) is a set of classes that allow access to Btrie= ve=20 data. </P> <H2><A name=3DRequirements></A>System Requirements</H2> <UL> <LI>Existing install of Pervasive PSQL v9 Engine </LI></UL> <P><B>Note:</B> The JCL SDK is currently not supported on the Linux platfo= rm.=20 </P> <H2><A name=3DStarted></A><B>Getting Started</B></H2> <P>The Java Class Library (JCL) release includes binaries, samples, and=20 documentation that enable you to develop Java-based applications that conn= ect to=20 Pervasive PSQL v9 database engines. </P> <P>For more information about JCL, see the JCL section of the Pervasive=20 Developer Center at <A=20 href=3D"http://www.pervasive.com/developerzone/access_methods/jcl.asp"=20 target=3D_new>http://www.pervasive.com/developerzone/access_methods/jcl.as= p</A>=20 </P> <H3><A name=3Dinstall></A>Installation</H3> <P>To install Java Class Library: </P> <OL> <LI>Unpack the zip file to a directory of your choosing. For example, cr= eate a=20 directory called SDK under your Pervasive PSQL installation=20 (<CODE>c:\pvsw\sdk\</CODE>)=20 <LI>Copy <CODE>psql.jar</CODE> and <CODE>jnibtrv.dll</CODE> to the BIN=20 directory of Pervasive PSQL. For example, assuming you installed the dat= abase=20 engine to <CODE>C:\pvsw</CODE>, copy the file to <CODE>C:\pvsw\bin</CODE= >.=20 </LI></OL> <H3><A name=3Dnew></A>New in Pervasive PSQL v9 Java Class Library Release<= /H3> <P>This release of JCL supports database security and connection using URI= s that=20 were introduced with the Pervasive.SQL V8 (8.5) release. The connection me= thods=20 have been updated to support URIs. Any applications that used the previous= =20 version of JCL must be updated in order to use the Pervasive PSQL v9 Java = Class=20 Library. You can also specify the character encoding used by the Database = and=20 Table classes. </P> <P class=3Dnote><B>Note: </B>The <CODE>pmke:</CODE> and <CODE>pids:</CODE>= =20 protocols are no longer supported. You cannot use this version of JCL with= the=20 I*net Data Server.</P> <P>To make a connection to the database using the <CODE>btrv</CODE> protoc= ol=20 supported by Java Class Library: <PRE> Session session =3D Driver.establi= shSession(); Database db =3D session.connectToDatabase("btrv://user@host/dbname?pwd= =3Dpassword"); </PRE> <P>At a minimum, you should specify the database name. For example:</P><PR= E> Database db =3D session.connectToDatabase("btrv:///demodata"); </PRE> <P>You can also specify URI parameters. For more information on database U= RIs,=20 see <A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/PSQL_Program= mers_Guide.pdf">Pervasive=20 PSQL Programmer's Guide</A>.=20 <P>This table contains a list of some key changes to classes in the Pervas= ive=20 PSQL v9 Java Class Library. For a complete reference of Java Class Library= , see=20 the <A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javadoc/inde= x.html">Java=20 Class Library Reference</A>. </P> <TABLE border=3D1 cellPadding=3D5 width=3D"90%"> <TBODY> <TR> <TH vAlign=3Dtop width=3D"45%"> <P><B>Class/Method</B></P></TH> <TH vAlign=3Dtop width=3D"45%"> <P><B>Description</B></P></TH> <TH vAlign=3Dtop width=3D"10%"> <P><B>Javadoc Reference</B></P></TH> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>Session.ConnectToDatabase()</CODE> method</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Now used to connect to Pervasive PSQL databases using URIs.</P></= TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/Session.html#connectToDatabase(java.lang.String)">jav= adoc</A></P></TD></TR> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>Database.setCharEncoding()</CODE> method</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Used to specify the character encoding for the Database object.</= P></TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/Database.html#setCharsetName(java.lang.String)">javad= oc</A></P></TD></TR> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>Table.setCharEncoding()</CODE> method</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Used to specify the character encoding for the Table object.</P><= /TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/Table.html#setCharsetName(java.lang.String)">javadoc<= /A></P></TD></TR> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>DBURI</CODE> class</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Class representing a database URI object.</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/DBURI.html">javadoc</A></P></TD></TR> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>DBUtil</CODE> class</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Class with convenience methods for handling URIs.</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/DBUtil.html">javadoc</A></P></TD></TR></TBODY></TABLE> <H3><A name=3Dcomps></A>Components List</H3> <P>These are the components that comprise the Java Class Library.</P> <TABLE border=3D1 cellPadding=3D5 width=3D"90%"> <TBODY> <TR> <TH vAlign=3Dtop width=3D"20%"> <P><B>Component</B></P></TH> <TH vAlign=3Dtop width=3D"35%"> <P><B>Description</B></P> <TR> <TD vAlign=3Dtop width=3D"20%"> <P>PSQL.JAR</P></TD> <TD vAlign=3Dtop width=3D"35%"> <P>Java Class Library JAR - redistributable. Ensure this is in the=20 <CODE>CLASSPATH</CODE> for your application.</P></TD> <TR> <TD vAlign=3Dtop width=3D"20%"> <P>JNIBTRV.DLL</P></TD> <TD vAlign=3Dtop width=3D"35%"> <P>Java Native Interface for Btrieve. Place in the BIN directory of = the=20 engine. For example, <CODE>C:\pvsw\bin</CODE></P></TD></TR></TBODY><= /TABLE> <H3>Documentation for Java Class Library</H3> <P>The following documentation for the Java Class Library is provided:</P> <UL> <LI>Readme (this document)=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/PSQL_JCL_G= uide.pdf">Java=20 Class Library Guide</A> in PDF format. This manual documents the use of = the=20 Java Class Library=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/PSQL_Progr= ammers_Guide.pdf">Pervasive=20 PSQL Programmer's Guide</A> in PDF format. This manual documents concept= ual=20 information on Btrieve.=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javadoc/in= dex.html">Java=20 Class Library Reference</A> in HTML format. This is a javadoc set contai= ning=20 the reference for all the classes in </LI></UL> <H3>Samples for Java Class Library</H3> <P>The following samples for the Java Class Library are provided:</P> <UL> <LI><CODE>helloworld</CODE> - simple sample demonstrating connection to = the=20 DEMODATA database provided with Pervasive PSQL. You can pass a URI param= eter=20 if security is enabled on your machine.=20 <LI><CODE>join</CODE> - demonstrates SQL joins=20 <LI><CODE>serialization</CODE> - demonstrates how to serialize Java obje= cts.=20 <LI><CODE>pvideo</CODE> - this sample simulates the management of a vide= o=20 store. A separate Pvideo database is provided if you wish to run this sa= mple.=20 </LI></UL> <H2><A name=3DProblems></A><B>Known Issues in this Release</B></H2> <P>The following are known issues with this release.</P> <TABLE border=3D1 cellPadding=3D5 width=3D"60%"> <TBODY> <TR> <TH vAlign=3Dtop width=3D"15%">Issue Number</TH> <TH vAlign=3Dtop width=3D"83%">Description</TH></TR> <TR> <TD width=3D"15%">n/a</TD> <TD width=3D"83%">n/a</TD></TR></TBODY></TABLE> <H2><A name=3Dlinks></A>Useful Links</H2> <P>Discuss all your Pervasive development issues at DevTalk at <A=20 href=3D"http://www.pervasive.com/devtalk">http://www.pervasive.com/devtalk= </A>.=20 </P> <P>See some creative applications and code snippets and share your own at= =20 Pervasive ComponentZone at <A=20 href=3D"http://www.pervasive.com/componentzone">http://www.pervasive.com/c= omponentzone</A>.=20 </P> <H2><A name=3DDisclaimer></A>Disclaimer </H2> <P><FONT size=3D2>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.<BR>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. </FONT></P> <P><FONT size=3D-1>Copyright =A9 1999-2006 Pervasive Software Inc. All Rig= hts=20 Reserved. </FONT></P></BODY></HTML>

mime-version: 1.0 date: Fri, 25 Jun 2010 16:38:02 -0500 content-transfer-encoding: quoted-printable content-location: http://ww1.pervasive.com/developerzone/access_methods/readme_jcl.html x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.5931 from: subject: Pervasive PSQL v9 - Java Class Library content-type: text/html; charset="Windows-1252" Readme JCL v9</TIT= LE> <META content=3D"text/html; charset=3Dwindows-1252" http-equiv=3DContent-T= ype> <META name=3DAUTHOR content=3D"Pervasive Software"> <META name=3DDESCRIPTION=20 content=3D"Information about the Pervasive Java Class Library"> <META name=3DOWNER content=3D"Pervasive Developer Solutions Team"> <STYLE>BODY { FONT-FAMILY: Verdana, Arial, Helvetica, MS Sans Serif; FONT-SIZE: 80%; MA= RGIN-RIGHT: 10em } A:link { FONT-FAMILY: Verdana; COLOR: #008000 } A:active { FONT-FAMILY: Verdana; COLOR: #8fbc8b } A:visited { FONT-FAMILY: Verdana; COLOR: #996699 } A:hover { BACKGROUND-COLOR: #996699; FONT-FAMILY: Verdana; COLOR: #ffffff } P { MARGIN-TOP: 0.6em; FONT-FAMILY: Verdana; MARGIN-BOTTOM: 0.6em; MARGIN-LEF= T: 1em } H1 { BORDER-BOTTOM: black solid; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 160% } H2 { MARGIN-TOP: 1.5em; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 140% } H3 { MARGIN-TOP: 1.2em; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 110%; xfont-size: 110% } H4 { MARGIN-TOP: 1.2em; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 105%; xfont-size: 105% } H5 { MARGIN-TOP: 1.2em; MARGIN-BOTTOM: 0.5em; FONT-SIZE: 100% } BIG { FONT-SIZE: 105%; FONT-WEIGHT: bold } OL { MARGIN-TOP: 0.6em; MARGIN-BOTTOM: 0em; MARGIN-LEFT: 4em } UL { LIST-STYLE-TYPE: square; MARGIN-TOP: 0.6em; FONT-FAMILY: Verdana; MARGIN-= BOTTOM: 0em } UL UL { MARGIN-TOP: 0em } UL LI { FONT-FAMILY: Verdana } P LI { LIST-STYLE-TYPE: square; FONT-FAMILY: Verdana; MARGIN-BOTTOM: 0em } LI P { FONT-FAMILY: Verdana } TABLE { MARGIN-TOP: 1em; MARGIN-LEFT: 5em; FONT-SIZE: 100%; MARGIN-RIGHT: 5em; ce= ll-padding: 10 } TH { TEXT-ALIGN: left; FONT-FAMILY: Verdana; BACKGROUND: #d3d3d3; VERTICAL-ALI= GN: bottom } TR { VERTICAL-ALIGN: top } TD { FONT-FAMILY: Verdana; VERTICAL-ALIGN: top } STRONG { COLOR: maroon; FONT-WEIGHT: bold; TEXT-DECORATION: none } P.note { BORDER-BOTTOM: silver solid; BORDER-LEFT: silver solid; PADDING-BOTTOM: 1= %; BACKGROUND-COLOR: #ffffee; PADDING-LEFT: 1%; PADDING-RIGHT: 1%; MARGIN-= LEFT: 10em; BORDER-TOP: silver solid; MARGIN-RIGHT: 10em; BORDER-RIGHT: si= lver solid; PADDING-TOP: 1% } PRE { MARGIN-TOP: 1.2em; FONT-FAMILY: Courier; MARGIN-BOTTOM: 1.5em; COLOR: blu= e; MARGIN-LEFT: 5em; FONT-SIZE: 70% } CODE { FONT-FAMILY: Courier; COLOR: blue; FONT-SIZE: 70% } P.question { =09 } </STYLE> <META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18928">  </HEAD> <BODY> <H1>Pervasive PSQL v9 Java Class Library (JCL) - May 2006</H1> <P>This document contains the following topics: </P> <UL> <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#AboutThisUpdat= e">About=20 Java Class Library</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#Requirements">= System=20 Requirements</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#Started">Getti= ng=20 Started</A>=20 <UL> <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_P= ervasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#install">Ins= tallation</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_P= ervasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#new">New=20 in Pervasive PSQL v9</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_P= ervasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#comps">Compo= nents=20 List</A> </LI></UL> <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#Problems">Know= n=20 Issues</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#links">Useful= =20 Links</A>=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/Readme_Per= vasive%20PSQL%20v9%20-%20Java%20Class%20Library_May2006.mht#disclaimer">Di= sclaimer</A>=20 </LI></UL> <HR> <H2><A name=3DAboutThisUpdate></A>About Java Class Library</H2> <P>Java Class Library (JCL) is a set of classes that allow access to Btrie= ve=20 data. </P> <H2><A name=3DRequirements></A>System Requirements</H2> <UL> <LI>Existing install of Pervasive PSQL v9 Engine </LI></UL> <P><B>Note:</B> The JCL SDK is currently not supported on the Linux platfo= rm.=20 </P> <H2><A name=3DStarted></A><B>Getting Started</B></H2> <P>The Java Class Library (JCL) release includes binaries, samples, and=20 documentation that enable you to develop Java-based applications that conn= ect to=20 Pervasive PSQL v9 database engines. </P> <P>For more information about JCL, see the JCL section of the Pervasive=20 Developer Center at <A=20 href=3D"http://www.pervasive.com/developerzone/access_methods/jcl.asp"=20 target=3D_new>http://www.pervasive.com/developerzone/access_methods/jcl.as= p</A>=20 </P> <H3><A name=3Dinstall></A>Installation</H3> <P>To install Java Class Library: </P> <OL> <LI>Unpack the zip file to a directory of your choosing. For example, cr= eate a=20 directory called SDK under your Pervasive PSQL installation=20 (<CODE>c:\pvsw\sdk\</CODE>)=20 <LI>Copy <CODE>psql.jar</CODE> and <CODE>jnibtrv.dll</CODE> to the BIN=20 directory of Pervasive PSQL. For example, assuming you installed the dat= abase=20 engine to <CODE>C:\pvsw</CODE>, copy the file to <CODE>C:\pvsw\bin</CODE= >.=20 </LI></OL> <H3><A name=3Dnew></A>New in Pervasive PSQL v9 Java Class Library Release<= /H3> <P>This release of JCL supports database security and connection using URI= s that=20 were introduced with the Pervasive.SQL V8 (8.5) release. The connection me= thods=20 have been updated to support URIs. Any applications that used the previous= =20 version of JCL must be updated in order to use the Pervasive PSQL v9 Java = Class=20 Library. You can also specify the character encoding used by the Database = and=20 Table classes. </P> <P class=3Dnote><B>Note: </B>The <CODE>pmke:</CODE> and <CODE>pids:</CODE>= =20 protocols are no longer supported. You cannot use this version of JCL with= the=20 I*net Data Server.</P> <P>To make a connection to the database using the <CODE>btrv</CODE> protoc= ol=20 supported by Java Class Library: <PRE> Session session =3D Driver.establi= shSession(); Database db =3D session.connectToDatabase("btrv://user@host/dbname?pwd= =3Dpassword"); </PRE> <P>At a minimum, you should specify the database name. For example:</P><PR= E> Database db =3D session.connectToDatabase("btrv:///demodata"); </PRE> <P>You can also specify URI parameters. For more information on database U= RIs,=20 see <A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/PSQL_Program= mers_Guide.pdf">Pervasive=20 PSQL Programmer's Guide</A>.=20 <P>This table contains a list of some key changes to classes in the Pervas= ive=20 PSQL v9 Java Class Library. For a complete reference of Java Class Library= , see=20 the <A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javadoc/inde= x.html">Java=20 Class Library Reference</A>. </P> <TABLE border=3D1 cellPadding=3D5 width=3D"90%"> <TBODY> <TR> <TH vAlign=3Dtop width=3D"45%"> <P><B>Class/Method</B></P></TH> <TH vAlign=3Dtop width=3D"45%"> <P><B>Description</B></P></TH> <TH vAlign=3Dtop width=3D"10%"> <P><B>Javadoc Reference</B></P></TH> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>Session.ConnectToDatabase()</CODE> method</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Now used to connect to Pervasive PSQL databases using URIs.</P></= TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/Session.html#connectToDatabase(java.lang.String)">jav= adoc</A></P></TD></TR> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>Database.setCharEncoding()</CODE> method</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Used to specify the character encoding for the Database object.</= P></TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/Database.html#setCharsetName(java.lang.String)">javad= oc</A></P></TD></TR> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>Table.setCharEncoding()</CODE> method</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Used to specify the character encoding for the Table object.</P><= /TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/Table.html#setCharsetName(java.lang.String)">javadoc<= /A></P></TD></TR> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>DBURI</CODE> class</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Class representing a database URI object.</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/DBURI.html">javadoc</A></P></TD></TR> <TR> <TD vAlign=3Dtop width=3D"29%"> <P><CODE>DBUtil</CODE> class</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P>Class with convenience methods for handling URIs.</P></TD> <TD vAlign=3Dtop width=3D"25%"> <P><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javado= c/pervasive/database/DBUtil.html">javadoc</A></P></TD></TR></TBODY></TABLE> <H3><A name=3Dcomps></A>Components List</H3> <P>These are the components that comprise the Java Class Library.</P> <TABLE border=3D1 cellPadding=3D5 width=3D"90%"> <TBODY> <TR> <TH vAlign=3Dtop width=3D"20%"> <P><B>Component</B></P></TH> <TH vAlign=3Dtop width=3D"35%"> <P><B>Description</B></P> <TR> <TD vAlign=3Dtop width=3D"20%"> <P>PSQL.JAR</P></TD> <TD vAlign=3Dtop width=3D"35%"> <P>Java Class Library JAR - redistributable. Ensure this is in the=20 <CODE>CLASSPATH</CODE> for your application.</P></TD> <TR> <TD vAlign=3Dtop width=3D"20%"> <P>JNIBTRV.DLL</P></TD> <TD vAlign=3Dtop width=3D"35%"> <P>Java Native Interface for Btrieve. Place in the BIN directory of = the=20 engine. For example, <CODE>C:\pvsw\bin</CODE></P></TD></TR></TBODY><= /TABLE> <H3>Documentation for Java Class Library</H3> <P>The following documentation for the Java Class Library is provided:</P> <UL> <LI>Readme (this document)=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/PSQL_JCL_G= uide.pdf">Java=20 Class Library Guide</A> in PDF format. This manual documents the use of = the=20 Java Class Library=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/PSQL_Progr= ammers_Guide.pdf">Pervasive=20 PSQL Programmer's Guide</A> in PDF format. This manual documents concept= ual=20 information on Btrieve.=20 <LI><A=20 href=3D"http://ww1.pervasive.com/developerzone/access_methods/javadoc/in= dex.html">Java=20 Class Library Reference</A> in HTML format. This is a javadoc set contai= ning=20 the reference for all the classes in </LI></UL> <H3>Samples for Java Class Library</H3> <P>The following samples for the Java Class Library are provided:</P> <UL> <LI><CODE>helloworld</CODE> - simple sample demonstrating connection to = the=20 DEMODATA database provided with Pervasive PSQL. You can pass a URI param= eter=20 if security is enabled on your machine.=20 <LI><CODE>join</CODE> - demonstrates SQL joins=20 <LI><CODE>serialization</CODE> - demonstrates how to serialize Java obje= cts.=20 <LI><CODE>pvideo</CODE> - this sample simulates the management of a vide= o=20 store. A separate Pvideo database is provided if you wish to run this sa= mple.=20 </LI></UL> <H2><A name=3DProblems></A><B>Known Issues in this Release</B></H2> <P>The following are known issues with this release.</P> <TABLE border=3D1 cellPadding=3D5 width=3D"60%"> <TBODY> <TR> <TH vAlign=3Dtop width=3D"15%">Issue Number</TH> <TH vAlign=3Dtop width=3D"83%">Description</TH></TR> <TR> <TD width=3D"15%">n/a</TD> <TD width=3D"83%">n/a</TD></TR></TBODY></TABLE> <H2><A name=3Dlinks></A>Useful Links</H2> <P>Discuss all your Pervasive development issues at DevTalk at <A=20 href=3D"http://www.pervasive.com/devtalk">http://www.pervasive.com/devtalk= </A>.=20 </P> <P>See some creative applications and code snippets and share your own at= =20 Pervasive ComponentZone at <A=20 href=3D"http://www.pervasive.com/componentzone">http://www.pervasive.com/c= omponentzone</A>.=20 </P> <H2><A name=3DDisclaimer></A>Disclaimer </H2> <P><FONT size=3D2>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.<BR>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. </FONT></P> <P><FONT size=3D-1>Copyright =A9 1999-2006 Pervasive Software Inc. All Rig= hts=20 Reserved. </FONT></P></BODY></HTML>