ORACLE INTEGRATION

[cdnadmin]

This document was generated from CDN thread

Created by: Satendra Gupta on 12-03-2010 10:26:33 AM
Hi I have an ORACLE 10g server, I need to connect it from CVp.
 
I know sqlServer n mySQL integration is available for CVP.
 
Pls tel how to integrate Oracle wd CVP

Subject: Re: New Message from Satendra Gupta in Customer Voice Portal (CVP) - CVP -
Replied by: Janine Graves on 12-03-2010 02:29:58 PM
1.To use the database element that comes with Studio, you need to modify
the Tomcat/conf/server.xml file to provide a JNDI interface to the
oracle server. I believe the configuration within the server.xml config
file is something like this for Oracle:

   <Engine defaultHost="localhost" name="Catalina">
     <Realm  className="org.apache.catalina.realm.UserDatabaseRealm"/>
     <Host appBase="webapps" name="localhost">
       <Context path="/CVP">
         <Resource
           name="jdbc/jndiAliasToUseInStudio"
           type="javax.sql.DataSource"
           password="yourPassword"
           driverClassName="oracle.jdbc.driver.OracleDriver"
           maxIdle="2"
           maxWait="5000"
           username="yourUserName"
          
url="jdbc:oracle:thin:@10.1.78.20:1521ataBaseInstanceWithinOracle"
           maxActive="4"/>
       </Context>
     </Host>
   </Engine>
</Service>
</Server>


2. You then need to get the JDBC driver for Oracle and put it into
C:/Cisco/CVP/VxmlServer/Tomcat/common/lib

3. Restart Cisco VXML Server service (Tomcat)

4. Within Studio use the database element. To do a select statement,
choose Type:  single
enter the JNDI name from the server.xml file 'jndiAliasToUseInStudio' 
in the example above (omit the quotes, do NOT use the jdbc/ prefix in
Studio)

5. Enter the command you want to execute 'select * from rxtable where
rxnum={Data.Element.rxnum.value}'  (omit the quotes, do NOT end with
semi-colon)

6. For the single select statement, vxml server will create element data
with the names of the columns being returned. So if the rxtable had
columns named 'price' and 'refills'  then you'd get element data named
'PRICE' and 'REFILLS' as part of the element data for the DATABASE
element. NOTE - Oracle always returns column names as UPPER CASE - so
your variables will be named as UPPER CASE.


Cisco Developer Community Forums wrote:
> Satendra Gupta has created a new message in the forum "CVP - All
> Versions":
>
> --------------------------------------------------------------
> Hi I have an ORACLE 10g server, I need to connect it from CVp.
> Â
> I know sqlServer n mySQL integration is available for CVP.
> Â
> Pls tel how to integrate Oracle wd CVP
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2035295>
>
> or simply reply to this email.

Subject: RE: Re: New Message from Satendra Gupta in Customer Voice Portal (CVP) - CV
Replied by: Faisal Zaidi on 30-11-2012 04:36:10 AM
Hi Janine
 
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: Re: New Message from Satendra Gupta in Customer Voice Portal (CVP) - CV
Replied by: Faisal Zaidi on 30-11-2012 05:46:24 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">?
And should it the connection i write be from <Context path="/CVP">..to..</Context> from your example below?