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