来源: http://maping930883.blogspot.jp/2009/03/wls010weblogic-serverdata-source-2.html

在上一个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名称不变,可以切换使用其它的数据库,而代码不用做任何改变。

为了简单起见,这里没有选用支持XA的Driver:

因此,只能支持One-phase commit:

3. 在testdatasource.jsp中访问DataSource,获取数据库连接
testdatasource.jsp代码与上一篇文章完全相同。
4. 配置XA Data Source:dizzyworldXADS
配置支持XA的Driver:

可以看出使用的Driver Class支持XA:

运行同样的testdatasource.jsp,使用dizzyworldXADS作为JNDI名称。

Project下载:conf_jdbc_obe.zip

转载请注明:WebLogic Android 博客 » WLS_010:WebLogic Server基本管理之六:配置Data Source (2)[转]