Neoview JDBC Type 4 Driver Programmer's Reference (R2.2, R2.3, R2.4, R2.5)

Table of Contents
About This Document.......................................................................................................11
Release...................................................................................................................................................11
Intended Audience................................................................................................................................11
New and Changed Information............................................................................................................11
Organization of This Guide..................................................................................................................11
Typographic Conventions.....................................................................................................................12
Related Documentation........................................................................................................................13
Type 4 Driver APIs..........................................................................................................................13
Sun Microsystems Documents...................................................................................................13
Type 4 Driver Implementation-Specific APIs............................................................................13
Neoview Customer Library.............................................................................................................13
Abbreviations........................................................................................................................................14
Publishing History................................................................................................................................15
HP Encourages Your Comments..........................................................................................................15
1 Introduction to HP JDBC Type 4 Driver......................................................................17
Type 4 Driver API Package...................................................................................................................17
2 Installing and Verifying the Type 4 Driver.................................................................19
Downloading the Sofware....................................................................................................................19
Linking to Installation Instructions......................................................................................................19
Product Files.........................................................................................................................................19
Setting CLASSPATH.............................................................................................................................20
Verifying the Type 4 Driver..................................................................................................................20
3 Accessing Neoview SQL Databases..........................................................................21
Data Sources..........................................................................................................................................21
JDBC Data Source (client-side)........................................................................................................21
Server Data Source...........................................................................................................................21
Security.................................................................................................................................................22
How to Make a Connection to Neoview SQL......................................................................................22
Connection by Using the DataSource Interface....................................................................................22
Overview of Tasks to Deploy DataSource Objects..........................................................................22
DataSource Object Properties..........................................................................................................23
Programmatically Creating an Instance of the DataSource Class...................................................23
Programmatically Registering the DataSource Object....................................................................23
Retrieving a DataSource Instance by Using JNDI and Connecting to the Data Source..................24
Specifying the Properties File that Configures the Data Source.....................................................24
Connection by Using the DriverManager Class...................................................................................24
Loading and Registering the Driver................................................................................................25
Establishing the Connection............................................................................................................25
Guidelines for Connections Using the Driver Manager..................................................................25
Connection Pooling...............................................................................................................................27
Statement Pooling.................................................................................................................................28
Guidelines for Statement Pooling....................................................................................................28
Troubleshooting Statement Pooling................................................................................................28
Thread-Safe Database Access...............................................................................................................29
"Update ... Where Current of" Operations............................................................................................29
Table of Contents 3