Author Message
onurcan.oz
Joined: Jul 11, 2019
Messages: 4
Offline
I am trying to connect MSSQL 2016 through sqljdbc4.jar.

I am receiving the following exception

Assigning [session:aai] to [getData:_ID]
Executing DB statement : [{ ? = call dbo.SP_IVR_GETPARAMSBYCALLID;1 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }]
Capturing exception [org.apache.tomcat.dbcp.dbcp.SQLNestedException]. Message [RegisterPool failed]

I downloaded sqljdbc4.jar and uploaded to tomcat lib via WinSCP
How can i fix this problem ?
WilsonYu
Joined: Nov 6, 2013
Messages: 3950
Offline
What version is the Tomcat you are deploying apps to? Make sure the Tomcat version you select in Export Wizard matches.
onurcan.oz
Joined: Jul 11, 2019
Messages: 4
Offline
Tomcat version (6.0.43) and Export Wizard version (Tomcat 6.0) matches and I selected Experience Portal but I got this error again
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver i got this error on catalina.log
WilsonYu
Joined: Nov 6, 2013
Messages: 3950
Offline
This error means Tomcat can not find the jdbc driver file in the class path or there is no such class in the jdbc driver file. You need to make sure the jdbc driver file is in the Tomcat/lib directory and it's got the right access permission when when Tomcat is started.
Go to:   
Mobile view