ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
After upgrading from pro version 7.0 to 7.0.13a the following line of code causes an error. I checked and the correct drivers are in place. It appears that something with the alpha version is causing this.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
The error message was: ClassNotFoundException (line 140): com.microsoft.sqlserver.jdbc.SQLServerDriver--Sourced file: inline evaluation of: ``//////////////////////////////////////////////////////////// /////////////////// . . . '' : Method Invocation Class.forName
Could you try it with a
Could you try it with a CustomerClassLoader? Example:
import java.sql.*;
Connection conn;
try
{
Driver driver = CustomClassLoader.getCustomClassLoader().loadClass("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String database = "jdbc:sqlserver://127.0.0.1:<port>;databaseName=<dbName>;user=<user>;password=<password>";
Connection conn = driver.connect(database);
}
catch(Exception e)
{
log.logError(e);
}
finally
{
if(conn != null)
conn.close();
}