cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
49
Views
0
Helpful
0
Comments
cdnadmin
Community Member
This document was generated from CDN thread

Created by: null on 22-11-2006 09:52:09 PM
Hi,
I'm having a little trouble getting a connection to SQL 2005. We are running cvp 3.0, Audium 3.4.2 and tomcat 5.0. I have read through the other threads I found that related to the topic and tried some of the suggestions, but havent had any luck. Here is a portion of my server.xml......

[code:1:d3d417d317]<xml>
.
.
.

  • <Resource> 
<Resource>
  • <ResourceParams>
  • <parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
  • <parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
  • <ResourceParams>
  • <parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
  • <parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
  • <parameter>
<name>password</name>
<value>MYPSWD</value>
</parameter>
  • <parameter>
<name>url</name>
<value>jdbc&#58;microsoft&#58;sqlserver&#58;//MYSERVER&#58;1433;databaseName=cvpdev1;SelectMethod=cursor;</value>
</parameter>
  • <parameter>
<name>driverClassName</name>
<value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
</parameter>
  • <parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
  • <parameter>
<name>username</name>
<value>MYUSER</value>
</parameter>
</ResourceParams>
.
.
.[/code:1:d3d417d317]

my app is a simple app that does a DB element...
[b:d3d417d317]Type = single
JNDI = cvpdev1
select = select Msg from Greeting where DNIS = 12345[/b:d3d417d317]

The error I'm getting in the activity log is...
[b:d3d417d317]15:38:27,Database_01,element,error,com.audium.server.AudiumException: A built-in element encountered an exception of type com.audium.server.AudiumException.[/b:d3d417d317]

Subject: RE: SQL 2005 connection
Replied by: null on 22-11-2006 10:46:21 PM
I was able to get it working.... thanx.

Subject: RE: SQL 2005 connection
Replied by: Michael Bochynski on 23-11-2006 03:18:36 AM
Ryan,

Happy to hear that you got your issue resolved. One note - you mentioned that you use Audium Call Services 3.4.2. WE strongly suggest to upgrade to Call Services 3.4.3 release, as Call Services 3.4.2 should not be used in the production environment.

Regards,
Michael
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Quick Links