To Create the Data Source (Oracle Waveset Installation)

Oracle Waveset Installation

To Create the Data Source

These instructions are for Tomcat 6. They will not work with Tomcat 4.x or 5.x.

Verify that the environment variable TOMCAT_HOME is set correctly.

Copy the JDBC driver JAR for your database type to Tomcat's lib directory ($TOMCAT_HOME/lib).

Define the data source for Tomcat by editing $TOMCAT_HOME/conf/web.xml and adding a resource reference as follows:

<resource-ref>
  <res-ref-name>jdbc/IDM_database</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
</resource-ref>

Define the data source for the Waveset webapp by editing the webapp deployment context (for example, $TOMCAT_HOME/conf/Catalina/localhost/idm.xml) and adding the data source resource as follows:

<Resource
  auth="Container"
  name="jdbc/IDM_database"
  type="javax.sql.DataSource"
  driverClassName="org.gjt.mm.mysql.Driver"
  password="waveset"
  maxIdle="5"
  maxWait="5000"
  username="waveset"
  url="jdbc:mysql://mysqlhost:3306/waveset"
  maxActive="150"/>

Note –

In the <resource-ref> element, the value of the <resource-ref name> element must be the same as the name attribute in the <Resource> element.

Be sure to change the attributes in the <Resource> element to match your environment.