AnsweredAssumed Answered

MSSQL DB Connection Issue

Question asked by Oguz Asik on Mar 9, 2017

Hello,

 

We have implemented a custom workflow in which we have a java node where we are invoking a custom java method and this method tries to make connection to an mssql database. However as below error logs explains in detail custom code is not able to resolve mssql driver which has already been deployed to aveksa server as in below picture. Please note that we also have similar custom workflow from which we are connecting to oracle type database using jdbc driver and it works just fine. So it seems something wrong with mssql driver in particular. Can you please let us wrong what could be wrong?

 

By the way, we are using VIA 7.0.1 P02 running on appliance.

 

User-added image

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    ... 114 more
2017-03-08 17:31:47,486 [Worker_actionq#ActionQ1#WPDS_2] ERROR com.workpoint.server.script.ScriptEngine  - A script error has occurred. Error occurred in Statement #1 in Script ID 3:WPDS, Script Name = 'Node - Available Asynchronous', Script type = 'Action'. Job ID = 85602:WPDS, Process Ref = 'WF_SRVC', Node Name = 'getServiceCatalogFromOneflow', WorkItem = 620335:WPDS:1
java.lang.reflect.InvocationTargetException

Outcomes