http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/4306be5d/docs/2.2.0/client_install/index.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/client_install/index.html b/docs/2.2.0/client_install/index.html new file mode 100644 index 0000000..7805597 --- /dev/null +++ b/docs/2.2.0/client_install/index.html @@ -0,0 +1,4956 @@ + + + + + + + +Client Installation Guide + + + + + + +
+
+
+
+

License Statement

+
+
+

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file +distributed with this work for additional information regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with +the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0

+
+
+

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the +specific language governing permissions and limitations under the License.

+
+
+

Disclaimer: Apache Trafodion is an effort undergoing incubation at the Apache Software Foundation (ASF), sponsored by +the Apache Incubator PMC. Incubation is required of all newly accepted projects until a further review indicates that +the infrastructure, communications, and decision making process have stabilized in a manner consistent with other +successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, +it does indicate that the project has yet to be fully endorsed by the ASF.

+
+
+
+

Acknowledgements

+
+
+

Microsoft®, Windows®, Windows NT®, Windows® XP, and Windows Vista® are +U.S. registered trademarks of Microsoft Corporation. Intel® and Intel® +Itanium® are trademarks of Intel Corporation in the U.S. and other +countries. Java® is a registered trademark of Oracle and/or its +affiliates. Motif, OSF/1, UNIX®, X/Open®, and the X device is a +trademark of X/Open Company Ltd. in the UK and other countries.

+
+
+

OSF, OSF/1, OSF/Motif, Motif, and Open Software Foundation are trademarks of +the Open Software Foundation in the U.S. and other countries. +© 1990, 1991, 1992, 1993 Open Software Foundation, Inc.

+
+
+

The OSF documentation and the OSF software to which it relates are derived in +part from materials supplied by the following: © 1987, 1988, 1989 +Carnegie-Mellon University. © 1989, 1990, 1991 Digital Equipment +Corporation. © 1985, 1988, 1989, 1990 Encore Computer Corporation. © 1988 Free +Software Foundation, Inc. © 1987, 1988, 1989, 1990, 1991 Hewlett-Packard +Company. © 1985, 1987, 1988, 1989, 1990, 1991, 1992 International +Business Machines Corporation. © 1988, 1989 Massachusetts Institute of +Technology. © 1988, 1989, 1990 Mentat Inc. © 1988 Microsoft Corporation. +© 1987, 1988, 1989, 1990, 1991, +1992 SecureWare, Inc. © 1990, 1991 Siemens Nixdorf Informations systeme +AG. © 1986, 1989, 1996, 1997 Sun Microsystems, Inc. © 1989, 1990, 1991 +Transarc Corporation.

+
+
+

OSF software and documentation are based in part +on the Fourth Berkeley Software Distribution under license from The +Regents of the University of California. OSF acknowledges the following +individuals and institutions for their role in its development: Kenneth +C.R.C. Arnold, Gregory S. Couch, Conrad C. Huang, Ed James, Symmetric +Computer Systems, Robert Elz. © 1980, 1981, 1982, 1983, 1985, 1986, +1987, 1988, 1989 Regents of the University of California. OSF MAKES NO +WARRANTY OF ANY KIND WITH REGARD TO THE OSF MATERIAL PROVIDED HEREIN, +INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY +AND FITNESS FOR A PARTICULAR PURPOSE. OSF shall not be liable for errors +contained herein or for incidental consequential damages in connection +with the furnishing, performance, or use of this material.

+
+
+
+

Revision History

+
+ ++++ + + + + + + + + + + + + + + + + + + + + + + + + +
VersionDate

2.1.0

TBD

2.0.1

July 7, 2016

2.0.0

June 6, 2016

1.3.0

January, 2016

+
+
+
+

1. About This Document

+
+
+

This manual describes how to install and configure client applications that enable you to connect to and use a Trafodion database.

+
+
+

1.1. Intended Audience

+
+

This manual is intended for users who want to connect to and use a Trafodion database.

+
+
+
+

1.2. New and Changed Information

+
+

This manual shows updated versions for Trafodion Release 2.2.0.

+
+
+
+

1.3. Notation Conventions

+
+

This list summarizes the notation conventions for syntax presentation in this manual.

+
+
+
    +
  • +

    UPPERCASE LETTERS

    +
    +

    Uppercase letters indicate keywords and reserved words. Type these items exactly as shown. Items not enclosed in brackets are required.

    +
    +
    +
    +
    SELECT
    +
    +
    +
  • +
  • +

    lowercase letters

    +
    +

    Lowercase letters, regardless of font, indicate variable items that you supply. Items not enclosed in brackets are required.

    +
    +
    +
    +
    file-name
    +
    +
    +
  • +
+
+
+
+
    +
  • +

    [ ] Brackets

    +
    +

    Brackets enclose optional syntax items.

    +
    +
    +
    +
    DATETIME [start-field TO] end-field
    +
    +
    +
    +

    A group of items enclosed in brackets is a list from which you can choose one item or none.

    +
    +
    +

    The items in the list can be arranged either vertically, with aligned brackets on each side of the list, or horizontally, enclosed in a pair of brackets and separated by vertical lines.

    +
    +
    +

    For example:

    +
    +
    +
    +
    DROP SCHEMA schema [CASCADE]
    +DROP SCHEMA schema [ CASCADE | RESTRICT ]
    +
    +
    +
  • +
  • +

    { } Braces

    +
    +

    Braces enclose required syntax items.

    +
    +
    +
    +
    FROM { grantee [, grantee ] ... }
    +
    +
    +
    +

    A group of items enclosed in braces is a list from which you are required to choose one item.

    +
    +
    +

    The items in the list can be arranged either vertically, with aligned braces on each side of the list, or horizontally, enclosed in a pair of braces and separated by vertical lines.

    +
    +
    +

    For example:

    +
    +
    +
    +
    INTERVAL { start-field TO end-field }
    +{ single-field }
    +INTERVAL { start-field TO end-field | single-field }
    +
    +
    +
  • +
  • +

    | Vertical Line

    +
    +

    A vertical line separates alternatives in a horizontal list that is enclosed in brackets or braces.

    +
    +
  • +
+
+
+
+
{expression | NULL}
+
+
+
+
+
    +
  • +

    … Ellipsis

    +
    +

    An ellipsis immediately following a pair of brackets or braces indicates that you can repeat the enclosed sequence of syntax items any number of times.

    +
    +
    +
    +
    ATTRIBUTE[S] attribute [, attribute] ...
    +{, sql-expression } ...
    +
    +
    +
    +

    An ellipsis immediately following a single syntax item indicates that you can repeat that syntax item any number of times.

    +
    +
    +

    For example:

    +
    +
    +
    +
    expression-n ...
    +
    +
    +
  • +
  • +

    Punctuation

    +
    +

    Parentheses, commas, semicolons, and other symbols not previously described must be typed as shown.

    +
    +
    +
    +
    DAY (datetime-expression)
    +@script-file
    +
    +
    +
    +

    Quotation marks around a symbol such as a bracket or brace indicate the symbol is a required character that you must type as shown.

    +
    +
    +

    For example:

    +
    +
    +
    +
    "{" module-name [, module-name] ... "}"
    +
    +
    +
  • +
+
+
+
+
    +
  • +

    Item Spacing

    +
    +

    Spaces shown between items are required unless one of the items is a punctuation symbol such as a parenthesis or a comma.

    +
    +
    +
    +
    DAY (datetime-expression) DAY(datetime-expression)
    +
    +
    +
    +

    If there is no space between two items, spaces are not permitted. In this example, no spaces are permitted between the period and any other items:

    +
    +
    +
    +
    myfile.sh
    +
    +
    +
  • +
  • +

    Line Spacing

    +
    +

    If the syntax of a command is too long to fit on a single line, each continuation line is indented three spaces and is separated from the preceding line by a blank line.

    +
    +
    +

    This spacing distinguishes items in a continuation line from items in a vertical list of selections.

    +
    +
    +
    +
    match-value [NOT] LIKE _pattern
    +   [ESCAPE esc-char-expression]
    +
    +
    +
  • +
+
+
+
+

1.4. Comments Encouraged

+
+

We encourage your comments concerning this document. We are committed to providing documentation that meets your +needs. Send any errors found, suggestions for improvement, or compliments to user@trafodion.incubator.apache.org.

+
+
+

Include the document title and any comment, error found, or suggestion for improvement you have concerning this document.

+
+
+
+
+
+

2. Introduction

+
+
+

This manual describes how to install and configure the following client applications, which enable you to connect to and use a Trafodion +database.

+
+
+

2.1. Client Summary

+
+

2.1.1. JDBC-Based Clients

+
+

The following table lists JDBC-based clients supported by Trafodion.

+
+ ++++ + + + + + + + + + + + + + + + + + + + + + + + + +
Client NameDescription

Trafodion JDBC Type 4 Driver

A driver that enables Java applications that run on a client workstation to connect to a Trafodion database.
+
+NOTE: The Trafodion Command Interface (trafci), DBVisualizer, and SQuirreL SQL Client require this driver to be installed on the client +workstation.

Trafodion Command Interface (trafci)

A command-line interface that allows you to connect to a Trafodion database and run SQL statements and other commands interactively or from +script files. For more information, see the Trafodion Command Interface Guide.

DBVisualizer

A third-party database tool that allows you to connect to a Trafodion database. For more information, see the DbVisualizer website.

SQuirreL SQL Client

A third-party database tool that allows you to connect to a Trafodion database. For more information, see the +SQuirreL SQL Client website.

+
+
+

2.1.2. ODBC-Based Clients

+
+

The following table lists ODBC-based clients supported by Trafodion.

+
+ ++++ + + + + + + + + + + + + + + + + + + + + + + + + +
Client NameDescription

Trafodion ODBC Driver for Linux

A driver that enables applications, which were developed for the Microsoft ODBC API and run on a Linux workstation, to connect to a +Trafodion database.

Trafodion ODBC Driver for Windows

[Not included in this release]1
+
+A driver that enables applications, which were developed for the Microsoft Open Database Connectivity (ODBC) application programming +interface (API) and which run on a Windows workstation, to connect to a Trafodion database.

Trafodion odb tool

A multi-threaded, ODBC-based command-line tool for parallel data loading and extracting. For more information, see the +Trafodion odb User Guide.

Tableau

An interactive data visualization products focused on business intelligence +For more information, see the Tableau Software website.

+
+

1 License issues prevent us from including the ODBC Driver for Windows in this release. Contact +user@trafodion.incubator.apache.org for help obtaining the driver.

+
+
+
+
+
+
+

3. Preparation

+
+
+

Trafodion provides JDBC and ODBC drivers plus clients that use those drivers. +In addition, you can configure third-party JDBC- and ODBC-based tools to work +with Trafodion.

+
+
+

Typically, you install and configure the client software in the following order:

+
+
+
    +
  1. +

    JDBC and/or ODBC drivers. (Depending on what clients you plan to use.)

    +
  2. +
  3. +

    Trafodion clients. For example, trafci and odb.

    +
  4. +
  5. +

    Third-party clients. For example, DBVisualizer, SQuirell, and/or Tableau.

    +
  6. +
+
+
+

If you don’t plan to use JDBC-based clients, then please skip ahead to +Download Client Software.

+
+
+

3.1. Java Setup

+
+

The Trafodion JDBC Type 4 Driver requires Java 1.7 or higher. You need to set +the Java path to the correct location.

+
+
+

Depending on your planned usage, you install +the Java Development Kit (JDK, if you plan to develop Java-based applications) +or the Java Runtime Environment (JRE, if you plan to use packaged JDBC-based +products only).

+
+
+

3.1.1. Verify Java Version

+
+

To display the Java version of the client workstation on the screen, enter:

+
+
+
+
java -version
+
+
+
+
Example 1: Java Installed and PATH Variable Set Correctly
+
+
C:\> java -version
+
+java version "1.7.0_45" # This is the version you need to check
+Java(TM) SE Runtime Environment (build 1.7.0_45-b18)
+Java HotSpot(TM) Client VM (build 24.45-b08, mixed mode, sharing)
+C:\>
+
+
+
+

If the version is not 1.7 or higher, then please upgrade you Java installation +See Install Java.

+
+
+

If the version is 1.7 or higher, then skip ahead to Download Client Software.

+
+
+
Example 2: Path Not Set
+
+
'java' is not recognized as an internal or external command, operable program or batch file.`
+
+
+
+

If you have installed Java, then this message indicates that you’ve not included +the Java directory in your search path. See Set Up PATH Variable.

+
+
+
+

3.1.2. Install Java

+ +
+

Once installed, follow the instruction in Set Up PATH Variable +to ensure that your Java environment has been set up properly.

+
+
+
+
+

3.2. Download Client Software

+
+

The Trafodion client software is available from the Trafodion Download page. There is one +Trafodion Clients package per release listed under <version> Binaries.

+
+
+

The Trafodion Clients package consists of a zipped tar file that contains the Trafodion Clients tar file. +The Trafodion Client binaries are in the clients folder, which contains the following files:

+
+ ++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
FileUsage

DISCLAIMER

Trafodion Apache incubation disclaimer.

JDBCT4.zip

Trafodion JDBC Type 4 Driver.

LICENCE

Apache license.

NOTICE

Apache notice.

odbc64_linux.tar.gz

Trafodion odb tool.

TRAF_ODBC_Linux_Driver_64.tar.gz

Trafodion ODBC driver for Linux.

trafci.zip

The Trafodion command interpreter trafci.

TFODBC64-*.exe

[Not included in this release]1 Trafodion ODBC Driver for Windows.

+
+

1 License issues prevent us from including the ODBC Driver for Windows in this release. Contact +user@trafodion.incubator.apache.org for help obtaining the driver.

+
+
+
+

3.2.1. Windows Download

+
+

Do the following:

+
+
+
    +
  1. +

    Create a download folder on the client workstation. For example, c:\trafodion.

    +
  2. +
  3. +

    Open a Web browser and navigate to the Trafodion downloads site http://trafodion.incubator.apache.org/download.html.

    +
  4. +
  5. +

    Orient yourself to the binaries for the release you’re installing. +Click on the Trafodion Clients link to start downloading the Trafodion clients tar file to your workstation.

    +
  6. +
  7. +

    Place the apache-trafodion-clients-*.tar.gz file into the download folder.

    +
    +
      +
    • +

      Unpack the apache-trafodion-clients-*.tar.gz file using an unzip program of your choice. This creates +an apache-trafodion-clients-*.tar file.

      +
    • +
    • +

      Unpack the apache-trafodion-clients-*.tar file using an unzip program of your choice.

      +
    • +
    +
    +
  8. +
  9. +

    Verify content of the clients directory:

    +
    +
    +
    DISCLAIMER JDBCT4.zip LICENSE NOTICE odb64_linux.tar.gz trafci.zip TRAF_ODBC_Linux_Driver_64.tar.gz
    +
    +
    +
    +

    You use these files to install the different Trafodion clients.

    +
    +
  10. +
+
+
+
+
+

3.2.2. Linux Download

+
+

Do the following:

+
+
+
    +
  1. +

    Create a download directory on the client workstation. For example, $HOME/trafodion.

    +
  2. +
  3. +

    Open a Web browser and navigate to the Trafodion downloads site http://trafodion.incubator.apache.org/download.html.

    +
  4. +
  5. +

    Orient yourself to the binaries for the release you’re installing. +Right-click on the Trafodion Clients link and select Copy link address.

    +
  6. +
  7. +

    Go to the download directory on the client workstation and use wget to download the client package +using the URL you copied in step 3 above.

    +
  8. +
  9. +

    Unpack the apache-trafodion-clients-*.tar.gz using tar.

    +
    +

    Example

    +
    +
    +
    +
    $ mkdir $HOME/trafodion
    +$ cd $HOME/trafodion
    +$ wget <link to package>
    +$ tar -xzvf apache-trafodion_clients-*-incubating.tar.gz
    +$ cd clients
    +$ ls
    +DISCLAIMER  LICENSE  odb64_linux.tar.gz  TRAF_ODBC_Linux_Driver_64.tar.gz
    +JDBCT4.zip  NOTICE   trafci.zip
    +$
    +
    +
    +
    +

    You use these files to install the different Trafodion clients.

    +
    +
  10. +
+
+
+
+
+
+

3.3. Unpack Client Software

+
+

The client packages are located on the client subdirectory where you unpacked +the Trafodion distribution file. For example, c:\trafodion\clients (Windows) +or $HOME/trafodion/clients (Linux).

+
+
+

Unpack the client software and its dependencies you intend to use as follows.

+
+
+

3.3.1. Unpack JDBC-Based Client Software

+ +++++ + + + + + + + + + + + + + + + + + + + +
FileDescriptionRecommended Target Directory

JDBCT4.zip

JDBC Type 4 Driver

+
    +
  • +

    Windows: c:\trafodion\jdbct4

    +
  • +
  • +

    Linux: $HOME/trafodion/jdbct4

    +
  • +
+

trafci.zip

Command Interface

+
    +
  • +

    Windows: c:\trafodion\trafci

    +
  • +
  • +

    Linux: $HOME/trafodion/trafci

    +
  • +
+
+
+

Windows

+
+
+

Use your favorite compress/uncompress utility to unpack the file to the target directory +defined in the table above.

+
+
+

Linux

+
+
+

Unpack the .zip file using the unzip <file> -d <target-directory> command:

+
+
+
+
$ cd $HOME/trafodion/clients
+$ unzip JDBCT4.zip -d $HOME/trafodion/jdbct4
+.
+.
+.
+$ unzip trafci.zip -d $HOME/trafodion/trafci
+.
+.
+.
+$ cd ..
+$ ls
+apache-trafodion_clients-2.0.1-incubating.tar.gz  clients  jdbct4  trafci
+$
+
+
+
+

Once complete, a fully-installed c:\trafodion (Windows) or +$HOME/trafodion directory should contain the following directories:

+
+
+
    +
  • +

    clients: The compressed client software.

    +
  • +
  • +

    jdbct4: The Trafodion JDBC Type 4 driver installation directory.

    +
  • +
  • +

    trafci: The Trafodion Command Interpreter installation directory.

    +
  • +
+
+
+
+

3.3.2. Unpack ODBC-Based Client Software

+ +++++ + + + + + + + + + + + + + + + + + + + +
FileDescriptionRecommended Target Directory

TRAF_ODBC_Linux_Driver_64.tar.gz

Linux ODBC Driver

$HOME/trafodion/odbc

odb64_linux.tar.gz

Linux odb Utility

$HOME/trafodion/odb

+
+

Linux

+
+
+

Unpack the .tar.gz file using the tar -xzvf <file> -C <target-directory> command.

+
+
+
+
$ cd $HOME/trafodion/clients
+$ mkdir $HOME/trafodion/odbc
+$ tar -xzvf TRAF_ODBC_Linux_Driver_64.tar.gz -C $HOME/trafodion/odbc
+.
+.
+.
+$ mkdir $HOME/trafodion/odb
+$ tar -xzvf odb64_linux.tar.gz -C $HOME/trafodion/odb
+.
+.
+.
+$ cd ..
+$ ls
+apache-trafodion_clients-2.0.1-incubating.tar.gz  clients  odb  odbc
+
+
+
+

Once complete, a fully-installed c:\trafodion (Windows) or +$HOME/trafodion directory should contain:

+
+
+
    +
  • +

    clients: The compressed client software.

    +
  • +
  • +

    odb: The Trafodion odb utility installation directory.

    +
  • +
  • +

    odbc: The Trafodion ODBC driver installation directory.

    +
  • +
+
+
+
+
+
+
+

4. Install JDBC Type-4 Driver

+
+
+

4.1. Prerequisites

+
+

If you have not done so already, please ensure that you have setup your Java environment +and unpackaged the Trafodion client software.

+
+
+

The examples in this chapter assumes that you have unpackaged the JDBC Type 4 driver installation files +to c:\trafodion\jdbct4 (Windows) or $HOME/trafodion/jdbct4 (Linux).

+
+
+
+

4.2. Validate Install Directory

+
+

The content of the jdbct4 installation directory is as follows:

+
+ +++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Installation FolderFilesDescription

/lib

jdbcT4.jar

Product JAR file.

/samples

t4jdbc.properties

Properties file that you can configure for your application environment.

README

Readme file that explains how to use the common sample set.

/samples/common

sampleUtils.java

Sample source code for creating, populating, and dropping sample tables.

/samples/DBMetaSample

DBMetaSample.java

Sample source code for getting metadata about the sample tables.

README

Readme file that explains how to use this sample set.

/samples/PreparedStatementSample

PreparedStatementSample.java

Sample code for simple or parameterized SELECT statements that are prepared.

README

Readme file that explains how to use this sample set.

/samples/ResultSetSample

README

Readme file that explains how to use this sample set.

ResultSetSample.java

Sample source code for fetching rows from a result set.

/samples/StatementSample

README

Readme file that explains how to use this sample set.

StatementSample.java

Sample source code for fetching rows from a simple SELECT statement.

+
+
+
+

4.3. Set Up Client Environment

+
+

4.3.1. Java Development

+
+

If you plan to write and run Java applications that use the Trafodion JDBC Type 4 Driver to connect to a Trafodion database, then set these +environment variables on the client workstation, replacing jdk-directory with the location of your Java Development Kit and +replacing jdbc-installation-directory with the name of the directory where you downloaded the JDBC Type 4 driver:

+
+ +++++ + + + + + + + + + + + + + + + + + + + + + + + + +
Environment VariableOn WindowsOn Linux

JAVA_HOME

set JAVA_HOME="jdk-directory"1

export JAVA_HOME=jdk-directory

PATH

set PATH=%PATH%;%JAVA_HOME%\bin

export PATH=$PATH:$JAVA_HOME/bin

CLASSPATH

set CLASSPATH=%CLASSPATH%;_jdbc-installation-directory_\lib\jdbcT4.jar;

export CLASSPATH=$CLASSPATH:_jdbc-installation-directory_/lib/jdbcT4.jar:

+
+

1 Enclose the jdk-directory in quotes to ensure that Windows can find the directory correctly. You can use the set <variable> command to verify the setting.

+
+
+
+
+

4.3.2. Configure Applications

+
+

Edit the t4jdbc.properties file in the samples folder. Refer to the README file in the samples folder for instructions.

+
+
+

Set these values for your environment:

+
+
+
    +
  • +

    catalog: Specify a catalog that exists in the database.

    +
  • +
  • +

    schema: Specify a schema that exists in the database.

    +
  • +
  • +

    user: Specify the name of a user who will be accessing the database.

    +
  • +
  • +

    password: Specify the password of a user who will be accessing the database.

    +
  • +
  • +

    url: Specify this string: jdbc:t4jdbc://<host-name>:<port-number>/:

    +
  • +
+
+
+

<host-name> is the IP address or host name of the database platform.

+
+
+

<port-number> is the location where the +Trafodion Database Connectivity Service (DCS) is running. (Default: 23400).

+
+
+

See the Trafodion Database Connectivity Services Reference Guide +for information about how to configure the DCS port.

+
+
+

Example

+
+
+

In this example, Trafodion authentication has not been enabled. Therefore, you can use a dummy +user and password. If authentication is enabled, then use your user and password information.

+
+
+
+
catalog = TRAFODION
+schema = SEABASE
+user = usr
+password = pwd
+
+url = jdbc:t4jdbc://trafodion.host.com:23400/:
+
+
+
+ + + + + +
+ + +The driver’s class name is org.trafodion.jdbc.t4.T4Driver. +
+
+
+
+
+
+

4.4. Test Programs

+
+ + + + + +
+ + +You must use JDK and set up the environmental variables as documented in +Java Development to build the test programs. +
+
+
+

The README file in the samples folder provide information for how you build and run sample Java programs. +You can use these programs to verify the setup of the Trafodion JDBC Type-4 driver.

+
+
+

See the Validate Install Directory section above for information on the different +sample programs that are included with the Trafodion JDBC Type-4 driver.

+
+
+

Windows Example

+
+
+

Build and run the StatementSample test program to verify the JDBC Type-4 driver installation.

+
+
+
+
C:\trafodion\jdbct4\samples> cd StatementSample
+
+C:\trafodion\jdbct4\samples\StatementSample> %JAVA_HOME%\bin\javac -classpath ..\..\lib\jdbcT4.jar *.java ..\common\*.java
+
+Note: ..\common\sampleUtils.java uses or overrides a deprecated API.
+Note: Recompile with -Xlint:deprecation for details.
+
+C:\trafodion\jdbct4\samples\StatementSample> %JAVA_HOME%\bin\java -classpath ..\..\lib\jdbcT4.jar;..;. -Dt4jdbc.properties=..\t4jdbc.properties StatementSample
+
+Mar 16, 2016 9:36:54 PM common.sa