Showing 6 results.
Items per Page 50
of 1
First Previous Next Last

CVP Forum

« Back to General Discussion

Oracle integration

Combination View Flat View Tree View
Threads [ Previous | Next ]
Oracle integration
oracle
Answer
3/12/10 2:20 AM
Hi all.
 
Just started working with Call studio 7.0 , need help in how to configure call studio to talk to oracle and write queries
i am basically from peripro background..finding it harder to handle database related queries
 
Looking forward for some help to getting into call studio ;)
 
Thanks
Flag

RE: Oracle integration
Answer
4/20/10 7:11 PM as a reply to Vinay Kariyappa.
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.
Flag

RE: Oracle integration
Answer
4/23/10 12:34 PM as a reply to Justine Joubran.
Thanks Very much..
 
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.
Flag

RE: Oracle integration
Answer
11/30/12 11:47 AM as a reply to Vinay Kariyappa.
also could you provide a little more detail on where the connection needs to be specified in the server.xml file please?
should it be between the tags <GlobalNamingResources> ..to.. </GlobalNamingResources> as is the case with SQL or does it need to go after <Host appBase="webapps" autoDeploy="true" name="localhost" unpackWARs="true" xmlNamespaceAware="false" xmlValidation="false">?
Flag

RE: Oracle integration
Answer
11/30/12 10:37 AM as a reply to Justine Joubran.
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
Flag