Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagexml
<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.


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:

...