® ibm software group © 2006 ibm corporation kick-start your java apps: free software, fast...

®

IBM Software Group

© 2006 IBM Corporation

Kick-start your Java Apps: Free Software, fast development

Eclipse IDE, WASCE, DB2 Express-C

IBM Software Group | Rational software

2

The Kick-start combo

DB2 Express-C database server

WebSphere Application Server Community Edition

The Eclipse IDE


3

Agenda

Briefing on AI and How important is 3 tier model

J2EE Platform Architecture Overview

Introduce Student Kit

Eclipse Open Source IDE

WebSphere Application Server Community Edition

DB2 Express-C

Develop an example of web application: Demos


4

Before You Start

Downloading and installing DB2 Express-C

Creating databases and manipulating data with tools in DB2 Express-C

Downloading and installing Application Server

Managing Application Server through the Web console

Connecting Application Server to DB2 Express-C using a JCA 1.5 connector

Downloading and installing Eclipse

Installing the Application Server plug-in for Eclipse

Managing, browsing, and editing DB2 Express-C data through the Eclipse IDE

Testing Web applications in Eclipse with embedded control of Application Server instances

Rapidly developing and testing a JSP/JSTL Web application in Eclipse, with data access to DB2 Express-C, and deploying it to Application Server

Configuring Application Server as a general Web server on the Internet


5

Prerequisites

Familiar with Java development in general and server-side Java development specifically

Understand the general operations of a relational database

Familiar with basic J2EE Concepts


6

System Requirements

Sun JDK 1.4.2_09 or above

Or IBM JDK 1.4.2 SR3

512 MB of main memory (1GB recommended)

900MB of disk space to install the software components & examples


7

Overview

Eclipse, Application Server, and DB2 Express-C working together


8

J2EE Platform Architecture Overview

Session Beans

Entity Beans

PresentationLayer

BusinessLayer

IntegrationLayer

JavaBeans

SDOs

Java

Entity

Entity

Java

Java

JSP/JSFPages

Servlets

HTMLPages

JavaBeans

JavaBeans


9

Introducing DB2 Express-C

The robust, proven, and scalable database server

The core technology of DB2 has existed as an IBM product since 1983

International enterprises use DB2 today to maintain some of the largest databases on servers

scaling up (by adding more CPU and memory toone server) or scaling out (by adding more servers over an interconnection network)

Built-in management and business application features

32-bitmicroprocessor-based server hardware (with extensions for 64-bit CPUs)

built-in self-monitoring, maintenance, and tuning features

Transactions, XA distributed transactions, stored procedures, referential constraints, and triggers have been well-tested

DB2 Express-C can grow with your needs


10

Downloading and Installing DB2 Express-C

Downloading DB2 Express-C Go to DB2 Universal Database Express Edition for Linux and Windows

http://www-306.ibm.com/software/data/db2/udb/db2express/download.html?S_TACT=105AGX02&S_CMP=SIMPLE

Installing DB2 Express-C Unzip the downloaded file, db2exc_NT_x86.zip, to a directory.

Run SETUP.EXE to begin installing DB2 Express-C


11

Installing DB2 Express-CSetup screen for DB2 Express-C installer


12

Installing DB2 Express-C

Selecting typical installation for DB2 Express-C


13

Installing DB2 Express-C

Windows user authentication assignments for DB2 installation


14

Understanding the DB2 Express-C Components

DB2 System Services

DB2 tools and utilities for administrators, users, and developers


15

Understanding the DB2 Express-C Components DB2 System services


16

Understanding the DB2 Express-C Components

DB2 tools for administrators, users, and developers


17

Working with the DB2 Command Line Processor

Logging on the CLP of DB2 Express-C

Ex: connect to sample

select firstname, lastname, salary from employee where salary > 40000


18

DB2 Script file for creating a table

products.sql


19

Introducing WebSphere Application ServerCommunity Edition

Server for J2EE 1.4 applications and Web Services JSPs

Servlets

Custom Java coding

EJBs

Model-view-controller (MVC) frameworks

Lightweight development frameworks

JCA 1.5 resource adapters connecting to EIS or legacy systems

Other data-access components

Once a Geronimo (http://geronimo.apache.org)


20

WebSphere Application Server’s open source server components


21

Downloading and Installing Application Server

Downloading Application Server Go to: Download: WebSphere Application Server Community Edition

V1.0.0.1

http://www-128.ibm.com/developerworks/downloads/ws/wasce/?S_TACT=105AGX02&S_CMP=SIMPLE

Installing Application Server Run the wasce_setup-1.0.0.1.exe file on your system


22

A system console showing output from the Application Server Startup


23

The login screen for the Application Server Administration Console


24

Operating Application Server

Starting server select IBM WebSphere > Application Server Community Edition > Start

the server from the Windows Start menu

Stopping Server Log in to the Administration Console and select Shutdown from its menu on

the left-hand side.

From the Windows Start menu, select IBM WebSphere > Application Server Community Edition > Stop the server


25

Obtain a list of installed applicationsdeploy list-modules


26

Connecting Application Server to DB2 Express-C

Deploying a resource adapter Deploy JCA 1.5 resource adapter on Application Server

Uploading the DB2 Express-C JDBC driver to the code of Application Server

Creating a deployment plan to deploy TranQL resource adapter, configured with the JDBC driver


27

Connecting Application Server to DB2 Express-C Uploading the DB2 JDBC driver and license JARs to Application Repository

db2jcc.jar

Db2jcc_license_cu.jar


28

Connecting Application Server to DB2 Express-C

Adding a system-wide database pool


29

Introducing the open source Eclipse IDE Built-in smart editors for Java code, HTML, XML, and so on Full syntax highlighting on all editors Full syntax check as you enter your code Context-sensitive code assists for supported programming languages,

including dynamic API documentation lookup Support for the development of standard Java applications, as well as J2EE

targets, such as Web applications and Web services Tight integration with popular version-control systems, such as Subversion and

CVS Tight integration with popular Java build tools, such as Apache Ant Tight integration with popular Java unit-testing frameworks, such as JUnit Ability to control, manage, and deploy applications to servers during the test

and debug cycle Tight integration with relational database sources through JDBC One-click ability to find the declaration of a type or base type anywhere in the

source code One-click ability to look up all references to a type or symbol anywhere in the

source code Refactoring tools that assist in the often tedious, complex, and error-prone refactoring process


30

Features of the Eclipse IDE user interface made available to all plug-ins


31

Downloading and installing Eclipse

Downloading Eclipse

eclipse-SDK-3.1.1-win32.zip from http://download.eclipse.org/eclipse/downloads

Unzip and install the Eclipse distribution

Double click eclipse.exe to initialize and to select workspace


32

Eclipse SDK


33

Connecting Eclipse to DB2 Express-C

From the Eclipse IDE menus, select Window > Show View > Other....


34

Exploring the SAMPLE DB2 Express-C database from Eclipse


35

Working with data in the Data Output andDatabase Explorer views

Modifying table content Examining table schema

Viewing the table content

Generating Data Definition Language (DDL) for your table


36

Demonstration: Creating a Web application with Eclipse and WTP


37

Summary Installed and became familiar with DB2 Express-C, using its rich set of

GUI tools and command-line tools Installed and worked with WebSphere Application Server Community

Edition, using its Web-based Administration Console as well as the command-line deployer tool

Connected WebSphere Application Server Community Edition to DB2 Express-C by deploying a system-wide database pool to the DB2 database

Installed the Eclipse IDE, the supporting Web Tools Platform, and the WebSphere Application Server Community Edition Eclipse plug-in

Connected Eclipse to DB2 Express-C through Eclipse's versatile Database Explorer view, which lets you view schema structure, see

table data content, modify data, and generate DDL Used Eclipse to create a Web application and deployed it to

WebSphere Application Server Community Edition with one click, supported through Installed and became familiar with DB2 Express-C, using its rich set of GUI tools and command-line tools


38

Resources

Rational and Eclipse http://www-306.ibm.com/software/rational/eclipse/

developerWorks Rational

http://www-128.ibm.com/developerworks/rational/

Eclipse

http://www.ibm.com/developerworks/opensource/top-projects/eclipse.html

Eclipse www.eclipse.org

Eclipse Technology on alphaWorks http://www.alphaworks.ibm.com/eclipse

Ready for IBM Rational software Plug-in Central http://www.ibm.com/developerworks/websphere/downloads/plugin/


39

® ibm software group © 2006 ibm corporation kick-start your java apps: free software, fast...

Documents