|
|
|
|
|
|
The University sample applications use a database (the University database) to store all the data (for example, course names and course summaries) used in the sample applications. Before you can build and run the University sample applications, you need to install and set up the database.
This appendix describes the setup process for the database. For details about the steps, see the product documentation for the database you are using.
The University sample applications shipped with version 4.2 of the WebLogic Enterprise (WLE) software can be used with Oracle version 7.3.3 or greater. Table A-1 lists what version of Oracle is supported on each operating system.
Database Support
Table A-1 Database Support
You can use the Oracle database in the following manner:
Setup Instructions for the Oracle Database
If you are using a local instance of the Oracle database, you need to install the following Oracle components:
Setup for Local Database Instance
Use the default database created by the Oracle installation program. You need the connection string for the Oracle database and the default user id and password. Refer to the Oracle product documentation for information about obtaining this information.
Once the Oracle software is installed, you need to start the daemon for the Oracle database. The daemon is generally started as part of the start-up process for your machine. You also need to enable an XA Resource Manager and set privileges so that the XA Resource Manager can manage the interaction between the Oracle database and the sample applications (v$xatrans$
).
Enter the following command to enable an XA Resource Manager that works with the University sample applications:
SQL>grant select on v$xatrans$ to public;
Note:
Enter the following additional command only if you are using version 8.0 of the Oracle database.
SQL>grant select on dba_pending_transactions to user; SQL>commit; where user
is the default user of the Oracle database.
For more information about performing these steps, see the Oracle product documentation.
Instructions for initializing the Oracle database are included in the descriptions of building the individual sample applications.
If you are using a remote instance of the Oracle database (e.g. a database running on another machine), you need to install the following Oracle components:
Setup for Remote Database Instance
Use the SQL *Net Easy Configuration Utility to define an alias for the remote instance of the Oracle database. For more information about performing these steps, see the Oracle product documentation.
The database you are accessing needs an XA Resource Manager enabled with privileges that allow interaction between the database and the sample applications (v$xatrans$
).
Enter the following command to enable an XA Resource Manager that works with the University sample applications:
SQL>grant select on v$xatrans$ to public;
Note:
Enter the following additional command only if you are using version 8.0 of the Oracle database.
SQL>grant select on dba_pending_transactions to user; SQL>commit; where user
is the default user of the Oracle database.
Instructions for initializing the Oracle database are included in the descriptions of building the individual sample applications.
|
|
|
Copyright © 1999 BEA Systems, Inc. All rights reserved.
|