IBM WebSphere and VisualAge for Java Database Integration with DB2, Oracle, and SQL Server.pdf

IBM WebSphere and VisualAge for Java

Database Integration with DB2,

Oracle, and SQL Server

Ueli Wahli, Tobias Himstedt, Sean Lee, Amir Razmara

International Technical Support Organization

www.redbooks.ibm.com

SG24-5471-00

SG24-5471-00

International Technical Support Organization

IBM WebSphere and VisualAge for Java

Database Integration with DB2,

Oracle, and SQL Server

September 1999

Take Note!

Before using this information and the product it supports, be sure to read the general information in

Appendix B, “Special Notices” on page 269.

First Edition (September 1999)

This edition applies to

• IBM WebSphere Application Server Version 2.0.2

• IBM WebSphere Studio Version 3.0 beta 2

• VisualAge for Java Version 2 with Rollup 2 and Enterprise Update

• DB2 Universal Database Version 5.2

• Oracle Version 8

• Microsoft SQL Server Version 7

for use with the Windows NT Operating System, Service Pack 4.

Sample Code on the Internet:

The sample code for this redbook is available as 5471samp.zip file on the ITSO home page on the

Internet:

ftp://www.redbooks.ibm.com/redbooks/SG245471/

Download the sample code and read Chapter 3, “ITSO Sample Applications” on page 15.

Comments may be addressed to:

IBM Corporation, International Technical Support Organization

Dept. QXXE Building 80-E2

650 Harry Road

San Jose, California 95120-6099

When you send information to IBM, you grant IBM a non-exclusive right to use or distribute the

information in any way it believes appropriate without incurring any obligation to you.

Note to U.S Government Users – Documentation related to restricted rights – Use, duplication or disclosure is

subject to restrictions set forth in GSA ADP Schedule Contract with IBM Corp.

Contents

Figures .................................................. ix

Tables ..................................................xvii

Preface ................................................. xix

TheTeamThatWroteThisRedbook...............................xx

CommentsWelcome ............................................xxi

Part 1. Introduction to IBM WebSphere and VisualAge for Java .1

Chapter 1. HTTP Server and WebSphere Application Server ....3

Environment...................................................3

IBMHTTPServer...............................................4

Installation.................................................4

Configuration ...............................................4

IBMWebSphereApplicationServer ................................5

WebSphereInstallation.......................................5

WebSphereConfiguration .....................................6

WebSphereConfigurationforJDBC.............................7

StartingandStoppingWebSphere ..............................8

Chapter 2. VisualAge for Java Enterprise Version 2 ............9

VisualAgeforJavaInstallation...................................10

VisualAgeforJavaConfigurationforJDBC.........................10

VisualAgeforJavaConfigurationforWebSphere ....................10

WebSphereinVisualAgeforJava.................................11

DefaultDirectoriesforServletsandJSPfiles ....................11

CompiledJSPs .............................................12

RunningServletsinVisualAgeforJava.........................12

Chapter 3. ITSO Sample Applications ........................15

SampleCode...............................................16

RepositoryExportFiles ......................................17

iii

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: