Servertec   List Employees Servlet
Content
Introduction
Release Notes
Features
FAQs
Requirements
Installation
Add-ons
How To
Change Log
Future Plans
Knowledge Base
Documentation
Samples
Hello World
Display Arguments
Display Headers
URL Redirect
CGI Tester
SSI Tester
Servlet Tag
Servlet Chaining
Log
Cookie Counter
Cookie Tester
Protected Page
List Employees
Connection Pool
Simple Form
Dump Form
Page Counter
File Upload
Session Tester
Context Tester
Sales
Legal
Feedback

 

This example only works under Windows NT/9x. 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 must be defined as a System DSN using the ODBC Data Source Administrator from the Control Panel.

    Driver: Microsoft Access Driver (*mdb)
    Data Source Name: iob
    Database: iws_dir\databases\iob.mdb
where:
iws_dir is the directory where iServer was installed, normally c:\iws.

This example displays a table showing any existing rows in the employee table.

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.

[ view source ] [ run ]

 top of page
 Built with iScript Copyright © 1997-2000 Servertec. All rights reserved.
Last Modified: Thu Aug 10 13:07:08 EDT 2000