Servertec   List Employees
Content
Introduction
Release Notes
Features
FAQs
Requirements
Installation
Change Log
Future Plans
Knowledge Base
Documentation
Samples
hello
args
headers
redirect
include
log
cookiecounter
protected
listemployees
connectionpool
simpleform
dumpform
pagecounter
Sales
Legal
Feedback

 

This example only works under Windows NT/9x when the Microsoft Adventure Works Microsoft Access example is already installed. The example makes use of the JDBC-ODBC bridge to access the employee table and may not work with JView.

Before using this example the following entry for AdvWorks must be defined as a System DNS in the ODBC Control Panel.

This example displays a table showing any existing rows in the employee table. The first column contains the employee's first name and the second column contains the employee's last name.

The example establishes a shared cached connection when the servlet is first loaded and uses that single connection for all client requests. The connection is finally closed when the server is stopped.

Connection caching is an efficient way of managing a limited resource.

Microsoft Adventure Works and Microsoft Access are copyright of Microsoft Corporation. Microsoft is a registered to Microsoft Corporation.

[ view source ] [ run ]

 top of page
 Built with iScript Copyright © 1997-1999 Servertec. All rights reserved.
Last Modified: Tue Jan 26 22:59:17 EST 1999