Make plans now to attend XMPP integration with CVP 2012/06/14 @ 10:00 AM at Cisco Live! in San Diego. ...Read More

 



Cisco Developer Network will be presenting a CDN Developer Track at Cisco Live! London the week of January 31, 2011.

We are presenting technical sessions which highlight Application Programming interfaces (APIs) and Software Developer Kits (SDKs) for Cisco technologies such as Unified Communications, IOS, and Access Routing Technologies ¿ including the new Cisco Cius ...Read More

 

Recently noticed that there have been repeated questions from our developer community complaining that they can't seem to get the beep to work with <record>. They have set the beep attribute to "true" alright, and the reference guide even says this is supported but why doesn't it work?
...Read More

 

August 01, 2006
Earlier today, as I was typing a comment in our internal issuing-tracking system, I hit backspace to correct a typo. WHAM! I go back to the previous page, and my long-winded comment is gone. Apparently I somehow left the context of the text area (did I tab, or spuriously click, or??), which causes backspace to act as a hotkey for "Back". The web browser was not very forgiving of my mistake.

Are your IVR applications forgiving? They should be.
...Read More

 

Mark Gibbs over at Network World has put together a spiffy little scoring system for customer service systems (including many criteria for IVR systems). How would callers score your IVR using Mark's guidelines? Place a call and find out, you may be surprised.
...Read More

 

If you're using JNDI to connect to your database through Tomcat, then it's possible you've had to deal with database connection pool leaks. Your code tests fine, it's been reviewed, but in load tests or in production your app is unable to acquire database connections, the pool is empty!

Fear not, there are some handy parameters which can be set in your application's XML configuration file (in tomcat/conf/Catalina/YOUR_IP/YOUR_APP.xml):
...Read More

 

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 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

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