I am using the database element for CVP studio
Cisco Unified Call Studio
 
Version: 8.5(1)
Build id: 201012111341
Getting the following error
 
24.40.50.146.1336485642545.0.TestingDB,05/08/2012 10:00:42.576,A built-in element encountered an exception of type com.audium.server.AudiumException. The error was: There was a problem looking up the JNDI data source 'DBConnection'. The root cause was: javax.naming.NameNotFoundException: Name DBConnection is not bound in this Context
com.audium.server.AudiumException: There was a problem looking up the JNDI data source 'DBConnection'.
 
 
Here is my entry in the context.xml file
 
<!-- The contents of this file will be loaded for each web application -->
<Context>
 
    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
              
    <Manager pathname="" />
  
 
 
 
<Resource name="jdbc/DBConnect"
   auth="Container"
   type="javax.sql.DataSource"
   driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
   url="jdbc:sqlserver://MYSERVER;databaseName=MYDATABSE;user=cable\rmarin;password=MYPWD"
   />
 
 
</Context>
 
Is there anything that needs to be done for this to work?

Thanks.

Bill Thanks, that was the issue....but now I am getting

24.40.50.146.1336506203088.0.TestingDB,05/08/2012 15:43:23.354,A built-in element encountered an exception of type com.audium.server.AudiumException. The error was: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' The root cause was: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
com.audium.server.AudiumException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'


I am testing on debug mode...ty...

If you're using MS SQL - the 8.5 debugger is a little weird in that it needs a different java driver than vxml server 8.5. Hope this helps!

The following is information one of my students gave me (thanks Keith F!):

For Call Studio 8.5 SQL connections via JDBC to work in production and in debug modes:

The following files/locations are for: sqljdbc_3.0 (can be downloaded from Microsoft)

VXMLServer: C:\Cisco\CVP\VXMLServer\Tomcat\common\lib\sqljdbc4.jar

Studio Debugger: C:\Cisco\CallStudio\eclipse\plugins\com.audiumcorp.studio.runtime_8.5.1\CATALINA_HOME\common\lib\sqljdbc.jar

Thanks to all of you, this is working now.

It has to do with the windows authentication not working well I had to use the SQL Server authentication.

I noticed that this is no longer the case in CVP 9.0. Since Call Studio now uses Java 1.6, sqljdbc4.jar should be used for both Call Studio and VXML Server.
VXMLServer: C:\Cisco\CVP\VXMLServer\Tomcat\common\lib\sqljdbc4.jar
Studio Debugger: C:\Cisco\CallStudio\eclipse\plugins\com.audiumcorp.studio.runtime_9.0.1_SNAPSHOT\CATALINA_HOME\common\lib\sqljdbc4.jar

Thanks for that update Matt. Much appreciated. I'll pass this along to my students.