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:1521
ataBaseInstanceWithinOracle"
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.
