Database element Error

[cdnadmin]

Subject: RE: Database element Error
Replied by: Bill Webb on 08-05-2012 03:24:47 PM
I think it's just a syntax error, if I'm reading your post correctly:

The error is:

There was a problem looking up the JNDI data source 'DBConnection'

And your XML snippet shows:

<Resource name="jdbc/DBConnect"

So I'd say you just need to change "DBConnection" in your Studio app to "DBConnect" and give it another try!

- Bill
This document was generated from CDN thread

Created by: Ronald Marin on 08-05-2012 02:43:58 PM
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.

Subject: RE: Database element Error
Replied by: Ronald Marin on 08-05-2012 03:46:01 PM
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...

Subject: RE: New Message from Ronald Marin in Customer Voice Portal (CVP) - General
Replied by: GEOFFREY THOMPSON on 08-05-2012 03:50:29 PM
SQl jar ? Where did you put it? Oracle or MS

Regards,
Geoff

Subject: RE: Database element Error
Replied by: Janine Graves on 08-05-2012 03:55:42 PM
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

Subject: RE: Database element Error
Replied by: Ronald Marin on 08-05-2012 05:04:00 PM

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

This solved the issue, I had sqljdbc4.jar and replaced it with sqljdbc.jar and worked now I am getting this...
 
24.40.50.146.1336510212640.0.TestingDB,05/08/2012 16:50:12.953,A built-in element encountered an exception of type java.lang.UnsatisfiedLinkError. The error was: java.lang.UnsatisfiedLinkError: SNISecGenClientContext
java.lang.UnsatisfiedLinkError: SNISecGenClientContext
 at com.microsoft.sqlserver.jdbc.AuthenticationJNI.SNISecGenClientContext(Native Method)
 
Thanks.

Subject: RE: Database element Error
Replied by: Ronald Marin on 09-05-2012 11:55:54 AM
Thanks to all of you, this is working now.

Subject: RE: Database element Error
Replied by: Janine Graves on 09-05-2012 12:07:53 PM
Ronald, How did you get rid of that last error  "exception of type java.lang.UnsatisfiedLinkError. The error was: java.lang.UnsatisfiedLinkError: SNISecGenClientContext"

Subject: RE: Database element Error
Replied by: Ronald Marin on 09-05-2012 01:18:34 PM
It has to do with the windows authentication not working well I had to use the SQL Server authentication.

Subject: RE: Database element Error
Replied by: Matthew Reiter on 25-10-2012 05:56:27 PM

Janine Graves:

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.

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

Subject: RE: Database element Error
Replied by: Matthew Reiter on 25-10-2012 06:03:05 PM

Janine Graves:

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.

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

Subject: Automatic reply: New Message from Matthew Reiter in Customer Voice Portal (
Replied by: ilias basha on 25-10-2012 06:03:58 PM
Hi,

Thanks for writing in.

I am currently on vacation with no access to your mail. I shall  be back to office on 29th October.

If your mail needs immediate attention please reach out Sugyani(sugyani.rath@accenture.com) for all IDV related queries and Anoop (anoop.puthenkattil@accenture.com) for other queries related to RBS-TTP.

Please expect a delay in my response.

Warm Regards,
Ilias Basha Shaik


________________________________
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited.

Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.

______________________________________________________________________________________

www.accenture.com

Subject: Re: New Message from Matthew Reiter in Customer Voice Portal (CVP) - Genera
Replied by: Janine Graves on 25-10-2012 06:16:25 PM
Thanks for that update Matt. Much appreciated. I'll pass this along to my students.