The WebLogic Server installation directory is the wlserver_10.3 folder within
the middleware home directory. Choose a shortcut location and click on Next .
The Installation Summary lists the products that are installed, which include the
WebLogic Server and the WebLogic JDBC drivers. Click on Next to install Oracle
JDeveloper 11 g and the integrated WebLogic Server 10.3.
We also need to install the Oracle database 10 g /11 g or the lightweight Oracle XE,
which may be downloaded from http://www.oracle.com/technology/software/
products/database/index.html . When installing Oracle database, also install the
Creating a datasource in JDeveloper
Next, we create a JDBC datasource in JDeveloper. We shall use the datasource in the
EJB 3.0 entity bean for database persistence. First, we need to create a database table
in some sample schema, OE for example. Run the following SQL script in SQL *Plus:
CREATE TABLE Catalog (id INTEGER PRIMARY KEY NOT NULL, journal
VARCHAR(100), publisher VARCHAR(100), edition VARCHAR(100), title
VARCHAR(100), author VARCHAR(100));
A database table gets created in the OE sample schema.