Page Comparison

File Location: <Tomcat-Installed-Folder>/conf/server.xml

Tomcat maintains a separate namespace of global resources for the entire server. These are configured in the <GlobalNamingResource> element within the server.xml.

The following snippet provides the sample values of the necessary elements and attributes that are to be configured within server.xml for expertctstudio: 

...

...

<GlobalNamingResources>

<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxactive="10" maxidle="10" maxwait="-1" name="jdbc/ExpertStudio" password="CT_EXPERT" type="javax.sql.DataSource" url="jdbc:oracle:thin:@localhost:1521:XE" username="CT_EXPERT"/>

...

 
<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxactive="10" maxidle="10" maxwait="-1" name="jdbc/ExpertStudioTarget" password="CT_MODEL" type="javax.sql.DataSource" url="jdbc:oracle:thin:@localhost:1521:XE" username="CT_MODEL"/>

...

</

...

GlobalNamingResources> 

Note: The <user-name> and <password> elements green highlighted in the snippet should match with the database username and password provided for expertctstudio.

Note: In case you have installed the Oracle database version 9i, then you should use oracle.jdbc.driver.OracleDriver class for JDBC connections, and for versions above 9i, you should use
oracle.jdbc.OracleDriver class.
Anchorpage12page12

A Host defines a virtual host under the engine, which can in turn support many Contexts (webapps). Tomcat by default includes this host elements in every server.xml file. Make sure that the <Host> element is configured as follows:

...

...

<Host appBase="webapps" autoDeploy="true" name="localhost" unpackWARs="true">

...

 

</

...

Host>