Hi,
 
You first need to edit the "C:\Cisco\CVP\VXMLServer\Tomcat\conf\server.xml" file.
Below is an example for the part to be edited:
 
        <Context
  crossContext="true"
    path="/CVP">

     <Resource
      name="jdbc/oracle"
      type="javax.sql.DataSource"
      username="[username on oracle]"
      password="[password on oracle]"
      driverClassName="oracle.jdbc.driver.OracleDriver"
      maxIdle="2"
      maxWait="5000"
      url="jdbc:oracle:thin:@[ip address of the oracle server]:1521:[instance name]"
      maxActive="4"/>
 
You also need to place to appropriate JDBC driver in the location: C:\Cisco\CVP\VXMLServer\Tomcat\common\lib
 
Once the driver can establish the connection, you can use the DB element in Call Studio and execute queries. Or you can make custom using java.
 
Hope this helps,
Justine.

Hi
 
I am trying to do exactly the same thing but am confused by the number of options for Oracle Jar files to use.
 
The Oracle DB version is 10.2.0.3 and we are on CVP v8.5.1 so would you know which .jar file we need to use? I believe the choice is between classes12.jar and ojdbc14.jar and think it should be ojdbc14.jar for JDK 1.4?
 
 
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html
 
Any help would be appreciated
 
Thanks
 
Faisal