HP Driver for JDBC User's Manual: HP 3000 MPE/iX Computer Systems

»

Technical documentation


	Complete book in PDF


»	Feedback

» Table of Contents

» Index

HP Part Number: 36216-90217

Edition: Edition 1

Published: E0399

Table of Contents

1 Introduction

JDBC
HP JDBC Components

2 Requirements

Java Requirements
HP-UX Server Requirements
MPE/iX Server Requirements
ALLBASE/SQL or IMAGE/SQL Requirements

3 Installation

HP-UX Server Components

MPE/iX Server Components

Java Client Components

Downloading the HP JDBC Archive File
Extracting the HP Driver for JDBC Class Files

Configuring HP JDBC Server

Starting and Stopping HP JDBC Monitor

HP-UX Monitor Startup and Shutdown
MPE/iX Monitor Startup and Shutdown

4 Using the HP Driver for JDBC

Java Class Path

Example on the HP 9000

Sample JDBC Client

Loading the HP Driver for JDBC

Connection Parameters

URL Syntax (Including User Name and Password)

URL Syntax (Without User Name and Password)

HP-UX Userid and Password

MPE/iX Userid and Password

5 ALLBASE/SQL Specifics

ALLBASE/SQL to JDBC Data Type Mapping
ALLBASE/SQL to JDBC Data Type Conversions
Unsupported ALLBASE/SQL Data Types
Acceptable SQL Syntax
Unsupported ALLBASE/SQL SQL Statements
Dynamic/Parameterized SQL Statements
Stored Procedures

6 Troubleshooting

Connection Process
Client Tracing
Server Logging

A Data Types

ALLBASE/SQL Data Types
JDBC Data Types

B JDBC Monitor

HP-UX Monitor
MPE/iX Monitor
HP-UX Monitor Configuration File
HP-UX Monitor Log
MPE/iX Monitor Log
HP-UX Monitor Startup and Shutdown
MPE/iX Monitor Startup and Shutdown

C HP JDBC Server

HP JDBC Server Configuration File
JDBC Server Logs

D Simple Client Source Code

E HP ALLBASE/SQL JDBC File Lists

Java Client Files
HP-UX Server Files
MPE/iX Server Files

List of Figures

1-1 JDBC Client-Server Application

List of Tables

5-1 Data Type Mapping
5-2 Data Type Conversions
5-3 Unsupported Statements


Feedback to webmaster