Hi we have an Oracle 10.2.0.3 DB which we are trying to connect to using the DB element in CVP 8.5.
 
We have several connections to SQL server DBs which work well however the Oracle one is not happy.
 
1. The C:\Cisco\CVP\VXMLServer\Tomcat\conf\server.xml file looks like this:
 
<GlobalNamingResources>
.
.
--3 perfectly working SQL Server JNDIs here--
.
.
 
<Resource name="jdbc/DEMUOracle" 
auth="Container" 
type="javax.sql.DataSource" 
driverClassName="oracle.jdbc.OracleDriver" 
url="jdbc:oracle:thin:@OracleServersIP:1521:Schema" 
username="xxxxx" 
password="xxxxx" 
maxActive="25" 
maxIdle="10" 
maxWait="10000"/>
 
 
     <!-- Test entry for demonstration purposes -->
     <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
 
     <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users -->
     <Resource auth="Container" description="User database that can be updated and saved" 
factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" 
pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/>
 
   </GlobalNamingResources>
 
 
2. I have cycled VXML Server.
 
 
3. I have placed the Oracle 10.2.0.3's ojdbc14.jar (see link below) in the directory C:\Cisco\CVP\VXMLServer\Tomcat\common\lib 
 
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html
 
 
4. The DB element contains the following:
 
Type: Single
JNDIName: DEMUOracle
SQL Query: SELECT FIELD03 FROM CTI_CUSTOMER WHERE KUNDENNUMMER='123456'
 
 
However I'm still get the following error(?):
 
xxx.xx.xx.xxx.1355910798810.0.NVS_DBLookupApplication,12/19/2012 10:53:18.826, The error was: A built-in element encountered an exception of type com.audium.server.AudiumException. There was a problem looking up the JNDI data source 'DEMUOracle'. The root cause was: javax.naming.NameNotFoundException: Name DEMUOracle is not bound in this Context
com.audium.server.AudiumException: A built-in element encountered an exception of type com.audium.server.AudiumException.
at com.audium.server.voiceElement.ActionElementBase.service(ActionElementBase.java:413)
at com.audium.server.controller.Controller.goToAction(Controller.java:2959)
at com.audium.server.controller.Controller.goToElement(Controller.java:2691)
at com.audium.server.controller.Controller.enterVoiceApplication(Controller.java:1206)
at com.audium.server.controller.Controller.newCall(Controller.java:1142)
at com.audium.server.controller.Controller.doPost(Controller.java:589)
at com.audium.server.controller.Controller.doGet(Controller.java:446)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:662)

Hi Janine - I have been using a hardcoded IP address, still the same error?

hi janine - audio file played without any isues - the wav is here http://xxx.xx.xx.xxx/nvs/en-us/MoTD/app_message0.wav and played successfully but i still get an error on the DB element. Below is the output including the activity log. (btw the activity log seems to suggest a normal call termination, this is not the case, the default error announcement is played)

ACTIVITY LOG:
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.266,Subdialog Start_01,enter,
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.766,Subdialog Start_01,exit,done
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.766,Welcome,enter,
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.766,Welcome,interaction,audio_group,initial_audio_group
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Welcome,exit,done
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Database_01,enter,
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Database_01,element,error,A built-in element encountered an exception of type com.audium.server.AudiumException.
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Database_01,exit,
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,,element,error,
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Database_01,interaction,audio_group,initial_audio_group
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:14.562,,end,how,hangup
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:14.562,,end,result,normal
xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:14.562,,end,duration,9
 
ERROR LOG:

xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844, The error was: A built-in element encountered an exception of type com.audium.server.AudiumException. There was a problem looking up the JNDI data source 'DEMUOracle'. The root cause was: javax.naming.NameNotFoundException: Name DEMUOracle is not bound in this Context
com.audium.server.AudiumException: A built-in element encountered an exception of type com.audium.server.AudiumException.
 at com.audium.server.voiceElement.ActionElementBase.service(ActionElementBase.java:413)
 at com.audium.server.controller.Controller.goToAction(Controller.java:2959)
 at com.audium.server.controller.Controller.goToElement(Controller.java:2691)
 at com.audium.server.controller.Controller.continueCall(Controller.java:2511)
 at com.audium.server.controller.Controller.doPost(Controller.java:733)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
 at java.lang.Thread.run(Thread.java:662)

please send the vxmlserver/tomcat/conf/context.xml and do you have the driver jar file in tocat/common/lib? did you restart vxml server? On 12/21/2012 2:56 AM, Cisco Developer Community Forums wrote: Faisal Zaidi has created a new message in the forum "CVP - All Versions": -------------------------------------------------------------- hi janine - audio file played without any isues - the wav is here http://xxx.xx.xx.xxx/nvs/en-us/MoTD/app_message0.wav and played successfully but i still get an error on the DB element. Below is the output including the activity log. (btw the activity log seems to suggest a normal call termination, this is not the case, the default error announcement is played) ACTIVITY LOG: xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.266,Subdialog Start_01,enter, xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.766,Subdialog Start_01,exit,done xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.766,Welcome,enter, xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.766,Welcome,interaction,audio_group,initial_audio_group xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Welcome,exit,done xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Database_01,enter, xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Database_01,element,error,A built-in element encountered an exception of type com.audium.server.AudiumException. xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Database_01,exit, xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,,element,error, xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844,Database_01,interaction,audio_group,initial_audio_group xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:14.562,,end,how,hangup xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:14.562,,end,result,normal xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:14.562,,end,duration,9  ERROR LOG: xxx.xx.xx.xxx.1356075665266.7.NVS_DBLookupApplication,12/21/2012 08:41:05.844, The error was: A built-in element encountered an exception of type com.audium.server.AudiumException. There was a problem looking up the JNDI data source 'DEMUOracle'. The root cause was: javax.naming.NameNotFoundException: Name DEMUOracle is not bound in this Context com.audium.server.AudiumException: A built-in element encountered an exception of type com.audium.server.AudiumException.  at com.audium.server.voiceElement.ActionElementBase.service(ActionElementBase.java:413)  at com.audium.server.controller.Controller.goToAction(Controller.java:2959)  at com.audium.server.controller.Controller.goToElement(Controller.java:2691)  at com.audium.server.controller.Controller.continueCall(Controller.java:2511)  at com.audium.server.controller.Controller.doPost(Controller.java:733)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)  at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)  at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)  at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)  at java.lang.Thread.run(Thread.java:662) -- To respond to this post, please click the following link: http://developer.cisco.com/web/cvp/forums/-/message_boards/view_message/9637898 or simply reply to this email. -- Janine Graves