2. Step by step, 安裝完畢后,我們要配置自己的domain,點(diǎn)擊"開始/程序/BEA WebLogic Platform8.1/ Configuration Wizard"(圖一),選擇"Create a new Weblogic configuration", "NextàBasic Weblogic Server DomainàNextàEXPressàNext" 輸入"Name*,PassWord*,Descr 3. 現(xiàn)在我們可以啟動(dòng)mydomain,看是否能正常使用了。
GRANT UNLIMITED TABLESPACE, CONNECT, RESOURCE TO "TEST";
6.使用"TEST"用戶登錄;
CONNECT TEST/TEST;
正常顯示"已連接",Okay。
(三). 創(chuàng)建示例數(shù)據(jù)庫
1.建表;
CREATE TABLE count (num1 NUMBER(4,2), num2 NUMBER(5,2), result NUMBER(6,2));
2.插入數(shù)據(jù);
INSERT INTO count(num1,num2,result) VALUES(1,1,2); INSERT INTO count(num1,num2,result) VALUES(1,1,1); INSERT INTO count(num1,num2,result) VALUES(2,8,10); INSERT INTO count(num1,num2,result) VALUES(68,90,158);
圖七 接下來到"Custom"子頁,"BEA home directory:"設(shè)為d:/ bea ;" JDK installation directory:"設(shè)為d:/bea/jdk141_02 ,"Domain directory:"設(shè)為d:/bea/user_projects/mydomain,在"User name:","Possowrd:"中填入安裝WebLogic時(shí)的用戶名和密碼,將"Listen address:"改為"localhost",不選"Add an Admin Console item to the tools menu"和"Add a Configuration Wizard item to the tools menu",完成后點(diǎn)擊"OK"。
圖八
接下來在菜單欄點(diǎn)擊"Project/Default Project Properties…"à彈出"Default Project Properties"窗口,在"Server" 子頁中選中"Single server for all services in project",然后在其下面的下拉框中選擇"Weblogic Application Server 8.x",點(diǎn)擊"OK"確定。
點(diǎn)擊Continue繼續(xù),進(jìn)入Test database connection頁面,點(diǎn)擊Test Driver Configuration,進(jìn)入Create an deploy頁面,假如你看到的是綠色Connection successful字樣,說明配置成功,點(diǎn)擊Create an deploy建立oraclePool連接池。
接下來我們配置數(shù)據(jù)源testTxDataSource,單擊控制臺左側(cè)域樹的JDBC/ Data Source節(jié)點(diǎn),然后單擊右側(cè)的Configure a new JDBC Tx Data Source,進(jìn)入Configure the data source選項(xiàng)卡。