This document was generated from CDN thread
Created by: Patrik Englund on 11-11-2013 12:43:37 AM
Hi
I have today one database connection configured in CVP. Now i need to add 2 more databases so my simple question are as follows. Do i only need to modify the context file so it contains the new database information and just type in the jndi name in the database element of the database i would like to run the query against? Below is just an example of how i think it should look, im using SQL Server so the config is not accurate but i suppose the sections in context file is no different. Reason for asking and not testing it on my system is that i dont have a lab to try it in.
<Context>
<Resource name="jdbc/TestDB1" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="javauser" password="javadude1" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/javatest"/>
<Resource name="jdbc/TestDB2" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="javauser" password="javadude2" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/javatest"/>
</Context>
Subject: Re: New Message from Patrik Englund in Customer Voice Portal (CVP) - Genera
Replied by: Janine Graves on 11-11-2013 08:40:44 AM
Hi Patrik, Yes, that's all you have to do. Add the other <Resource> tags into the context.xml and then restart VxmlServer service. Enter the appropriate JNDI name into Studio.
Subject: RE: Multiple database connections
Replied by: Patrik Englund on 11-11-2013 08:52:27 AM
Hi Janine
Many thanks for the confirmation!
Br Patrik
Subject: RE: Multiple database connections
Replied by: Patrik Englund on 19-11-2013 04:20:30 PM
Hi Janine
I tried this today and it does not seem to work as it should, i see in the vxml application logs that the jndi name i added into context.xml cannot be established.
I can connect from the cvp callserver itself using a database tool with the same credentials as in the context.xml file. Is it possible to see more info regarding this connection error in som cvp logs other than the limited info in the vxml application? I assume that the sqljdbc file have nothing to do with this as that´s only for different Java versions.
Subject: Re: New Message from Patrik Englund in Customer Voice Portal (CVP) - Genera
Replied by: Janine Graves on 22-11-2013 03:42:29 AM
It's probably a firewall problem.
Can you disable the firewall temporarily or put a sniffer on the line
and see what's happening?
--
Janine Graves
