Created by: Vinay Kariyappa on 11-03-2010 08:20:02 PM 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
Subject: RE: Oracle integration Replied by: Justine Joubran on 20-04-2010 02:11:45 PM 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.
Subject: RE: Oracle integration Replied by: Vinay Kariyappa on 23-04-2010 07:34:48 AM 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.
Subject: RE: Oracle integration Replied by: Faisal Zaidi on 30-11-2012 04:37:07 AM 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
Subject: RE: Oracle integration Replied by: Faisal Zaidi on 30-11-2012 05:47:26 AM 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">?
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
