CVP Application success on debug but failed running in VXML Server

[muttaqin_25]

Hi all

I have try to make simple CVP Call studio application, which is using Database element. When I debug on CVP Call studio this project is running well. But when I put the application to VXML Server the application prompt an error.Can anyone help me resolve this please?

This log that i have in Application that i have running on VXML Server :

(VXML Server IP).1518074371069.25.HDTIDEV,02/08/2018 14:19:31.116, The error was: A built-in element encountered an exception of type com.audium.server.AudiumException. Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:sqlserver://x.x.x.x:1433/HDTI' The root cause was: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:sqlserver://x.x.x.x:1433/HDTI'

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:416)

    at com.audium.server.controller.Controller.goToAction(Controller.java:3927)

    at com.audium.server.controller.Controller.goToElement(Controller.java:3563)

    at com.audium.server.controller.Controller.continueCall(Controller.java:3272)

    at com.audium.server.controller.Controller.doPost(Controller.java:878)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)

    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)

    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1600)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

    at java.lang.Thread.run(Thread.java:744)

Caused by: com.audium.server.AudiumException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:sqlserver://x.x.x.x:1433/HDTI'

    at com.audium.server.action.database.DatabaseAction.doAction(DatabaseAction.java:239)

    at com.audium.server.voiceElement.ActionElementBase.service(ActionElementBase.java:390)

    ... 21 more

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:sqlserver://x.x.x.x:1433/HDTI'

    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)

    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)

    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

    at com.audium.server.action.database.DatabaseAction.doAction(DatabaseAction.java:189)

    ... 22 more

Caused by: java.sql.SQLException: No suitable driver

    at java.sql.DriverManager.getDriver(DriverManager.java:278)

    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)

    ... 25 more

this my context.xml configuration :

<!-- The contents of this file will be loaded for each web application -->

<Context>

<WatchedResource>WEB-INF/web.xml</WatchedResource>

<Manager pathname=""/>

<Resource name="jdbc/TESTDB"

    auth="Container"

    factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"

    driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

    type="javax.sql.DataSource"

    maxActive="50"

    maxIdle="10"

    maxWait="15000"

    username="user"

    password="password"

    url="jdbc:sqlserver://x.x.x.x:1433;databaseName=HDTI;"

    removeAbandoned="true"

    removeAbandonedTimeout="30"

    logAbandoned="true"

    Resourcefactory="org.apache.tomcat.jdbc.pool.DataSourceFactory"

/>

</Context>

[Gerry O'Rourke · Accepted solution]

Muhammad,

Have you copied the SQL JAR file to the VXML Server, e.g.

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

Here is simple how to I did:

http://orourke.tv/web/doku.php?id=cisco:uc:cvp:jndi-cvp

Gerry

[muttaqin_25]

Hi Gorourke

Thanks For reply, this the driver that I already put in here : C:\Cisco\CVP\VXMLServer\Tomcat\lib\sqljdbc4.jar, I also already restart the VXML Server by OS, but still doesn't work

[janinegraves]

If you're on 11.5 or 11.6, try these configuration changes

1) First try this in the context.xml and restart VXML Server. Note the

factory and url attributes.

See if it works.

<Resource name="jdbc/something"

auth="Container"

type="javax.sql.DataSource"

factory=”org.apache.tomcat.jdbc.pool.DataSourceFactory”******

**

driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"**

**

url="jdbc:sqlserver://HostName:1433;user=user;password=pwd;DatabaseName=dbName"**

***  />*

2) If that doesn't work, people with CVP 11.5 or 11.6 are having trouble

with the sqljdbc4.jar file.

They are using this  driver: tds-1.3.1.jar (From SourceForge online)

And this in the context.xml:

*

[muttaqin_25]

Hi Janine Graves

Thanks for your advice,

after several try and error,finally this JDBC work properly

Muttaqin