JNDI in Call Studio Database Element

[saharhanna]

Hi all,

I am trying to use the database element in Call Studio with version 9.0

I can't figure out what it is that should be used in the JNDI field and how to create the database connection.

Anyone knows how to do it in straight-forward way?

Thanks,

Sahar Hanna

[bill.king]

You might want to take a look at the Element Specifications guide to see some of the configuration that is required to specify the server, etc.

[saharhanna]

Hi,

I did check that.

Actually what I have done is

• Install the sqljdbc.jar in C:\Cisco\CVP\VXMLServer\Tomcat\common\lib
• Create an SQL database (SQL 2008 R2)
• in the server.xml file in C:\Cisco\CVP\VXMLServer\Tomcat\conf, i have added the following:

     Context path="/CVP">

  Container" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://192.168.2.166:1433;databaseName=obSurvey;integratedSecurity=true" />

and in Call Studio, in the database element, I have entered in JNDI name obSurvey

when I call the application I get the following error in ActivityLogs:

DB_Unsatisfied,element,error,A built-in element encountered an exception of type com.audium.server.AudiumException.

And in the errorlogs I get:

com.audium.server.AudiumException: There was a problem looking up the JNDI data source 'obSurvey'.

Anything missing? or wrong?

Thank you,

Sahar