If you want to manually set up and configure your Oracle
database for Application Center with the Apache Tomcat server, use
the following procedure.
About this task
Complete the Oracle database setup procedure before continuing.
Procedure
- Add the Oracle JDBC driver JAR file
to the directory $TOMCAT_HOME/lib.
- Prepare an XML statement that defines the data source,
as shown in the following code example. Insert this statement in the server.xml file,
as indicated in Configuring Apache Tomcat for Application Center manually
<Resource name="jdbc/AppCenterDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@oserver:1521:ORCL"
username="APPCENTER"
password="APPCENTER_password"/>
Where APPCENTER after username= is
the name of the system user with "CONNECT" access to the APPCNTR database
that you have previously created, and APPCENTER_password after password= is
this user's password. If you have defined either a different user
name, or a different password, or both, replace these values accordingly.