心有猛虎，细嗅蔷薇: WLS_010：WebLogic Server基本管理之六：配置Data Source （2）

2009年3月5日星期四

WLS_010：WebLogic Server基本管理之六：配置Data Source （2）

在上一个Data Source配置中，我们使用的是pointbase数据库，在本文中，我们将使用Oracle数据库。
运行环境：WebLogic Server 10.3.5 + Oracle Database 10g Express Edition 10.2.0.1。

1. 创建数据库Schema：PBPUBLIC
以system用户作为SYSDBA登录：sqlplus system/welcome1@XE as SYSDBA
然后执行如下脚本：
REM =======================================================
REM Login as SYSTEM or SYSDBA user and run this script
REM =======================================================

DROP USER PBPUBLIC CASCADE;

CREATE USER PBPUBLIC IDENTIFIED BY PBPUBLIC;

ALTER USER PBPUBLIC DEFAULT TABLESPACE users
QUOTA UNLIMITED ON users;

ALTER USER PBPUBLIC TEMPORARY TABLESPACE temp;

GRANT create session
, create table
, create procedure
, create sequence
, create trigger
, create view
, create synonym
, alter session
TO PBPUBLIC;

CONNECT PBPUBLIC/PBPUBLIC

CREATE TABLE EMPLOYEE
(
ID INT ,
NAME CHARACTER (100) ,
TITLE CHARACTER (100) ,
SALARY CHARACTER (50) ,
BONUS_STRUCTURE CHARACTER (50) ,
TIME_OFF INT ,
SICK_TIME INT ,
HEALTH_PLAN CHARACTER (100) ,
VISION_PLAN CHARACTER (100) ,
DENTAL_PLAN CHARACTER (100) ,
PLAN INT ,
SAVINGS INT
);

CREATE TABLE WLS_CATALOG_ITEMS
(
SKU CHARACTER (50) ,
NAME CHARACTER (100) ,
DESCRIPTION CHARACTER (100) ,
PRICE DOUBLE PRECISION ,
INV_AMOUNT INT ,
CATEGORY CHARACTER (100)
);

CREATE TABLE WLS_CLIENT_INFO
(
CLIENT_ID CHARACTER (100) ,
NAME CHARACTER (100) ,
EMAIL CHARACTER (100)
);

INSERT INTO EMPLOYEE VALUES(1,'Chris Montgomery','Manager','70,000','25% Quarterly',15,5,'Blue Cross and Blue Shield','Aetna Vision','Delta Dental',25000,12000);
INSERT INTO EMPLOYEE VALUES(2,'Doris Sylvester','Programmer','55,000','15% Quarterly',10,5,'Blue Cross and Blue Shield','Aetna Vision','Aetna Dental',22000,16000);
INSERT INTO EMPLOYEE VALUES(3,'George Garcia','Senior Programmer','62,000','20% Quarterly',10,5,'Mathew Thornton Health Plan','Aetna Vision','Delta Dental',18000,9600);
INSERT INTO EMPLOYEE VALUES(4,'Jeff Hodgkins','Manager','75,000','25% Quarterly',15,5,'Blue Cross and Blue Shield','Aetna Vision','Aetna Dental',15000,22000);
INSERT INTO EMPLOYEE VALUES(5,'Jennifer Ackerman','Manager','75,000','25% Quarterly',15,5,'Mathew Thornton Health Plan','Aetna Vision','Aetna Dental',18000,23000);
INSERT INTO EMPLOYEE VALUES(6,'Jill Champagne','Senior Programmer','60,000','20% Quarterly',10,5,'Mathew Thornton Health Plan','Aetna Vision','Delta Dental',12000,16000);
INSERT INTO EMPLOYEE VALUES(7,'Katherine Frederick','Manager','70,000','25% Quarterly',15,5,'Mathew Thornton Health Plan','Aetna Vision','Aetna Dental',25000,6000);
INSERT INTO EMPLOYEE VALUES(8,'Michael Fuller','Programmer','50,000','15% Quarterly',10,5,'Blue Cross and Blue Shield','Aetna Vision','Delta Dental',13500,9500);
INSERT INTO EMPLOYEE VALUES(9,'Ryan Lewis','Programmer','52,000','15% Quarterly',10,5,'Blue Cross and Blue Shield','Aetna Vision','Delta Dental',16000,7600);
INSERT INTO EMPLOYEE VALUES(10,'Thomas Bernard','Manager','65,000','25% Quarterly',15,5,'Mathew Thornton Health Plan','Aetna Vision','Delta Dental',28520,1480);

INSERT INTO WLS_CATALOG_ITEMS VALUES('101','baseball cap','black baseball cap with company logo',19.99,44,'Clothing');
INSERT INTO WLS_CATALOG_ITEMS VALUES('102','polo shirt','white polo shirt with company logo',29.99,77,'Clothing');
INSERT INTO WLS_CATALOG_ITEMS VALUES('103','pens','a box of pens that have the company logo',5.99,100,'Office Supplies');
INSERT INTO WLS_CATALOG_ITEMS VALUES('104','paper','pads of legal paper with the company logo',9.99,120,'Office Supplies');
INSERT INTO WLS_CATALOG_ITEMS VALUES('105','beach towel','an oversized beach towel with the company logo',14.99,88,'Misc');
INSERT INTO WLS_CATALOG_ITEMS VALUES('106','sweatshirt','grey sweatshirt with the company logo',39.99,7,'Clothing');

INSERT INTO WLS_CLIENT_INFO VALUES('id2','Homer Simpson','homer.simpson@springfield.com');
INSERT INTO WLS_CLIENT_INFO VALUES('id3','Elmer Fudd','elmer.fudd@warnerbrothers.com');
INSERT INTO WLS_CLIENT_INFO VALUES('id4','Your Name','Your Email');

exit;

2. 配置Data Source：dizzyworldDS
Data Source的JNDI名称与上一个实验一样，这样正是使用Data Source的好处：
只要Data Source的JNDI名称不变，可以切换使用其它的数据库，而代码不用做任何改变。