albogdano
commented
5 years ago @jegarne Are you including the proper driver JAR inside ./lib along with the plugin JAR? Also do you set para.sql.driver in your configuration file?
Closed jegarne closed 5 years ago
albogdano
commented
5 years ago @jegarne Are you including the proper driver JAR inside ./lib along with the plugin JAR? Also do you set para.sql.driver in your configuration file?
jegarne
commented
5 years ago Yes. I've tried playing around with several different settings. I tried the driver in the root of the .\lib and also in .\lib\sqlserver\ as it looks like the code was looking for that string in the driver path to determine what flavor of SQL was running. Either way the logging is showing that its able to find that driver file correctly (when it can't find it, it complains in the logging) Driver version is 7.2.1. I've also confirmed that my SQL credentials are valid by connecting through a .udl file.
Just a theory, but I'm wondering if the Hikari config needs an additional setting? I'm see something like this in a few posts:
ds.setDataSourceClassName("com.microsoft.sqlserver.jdbc.SQLServerDataSource");
Admittedly I have little experience with Hikari.
Here are the relevant config settings:
# ms sql
para.dao = "SqlDAO"
para.sql.driver = "C:\\Para\\lib\\sqlserver\\mssql-jdbc-7.2.1.jre8.jar"
para.sql.url = "sqlserver://computername:1433;databaseName=Scoold;"
para.sql.user = "scooldAdmin"
para.sql.password = "password"@jegarne I'll start working on this issue now and I'll let you know how it goes. I'll be testing against SQL Server on Linux.
albogdano
commented
5 years ago I couldn't reproduce the issue. An example of a correct configuration would look like this:
para.dao = "SqlDAO"
para.sql.driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
para.sql.url = "sqlserver://localhost:1433"
para.sql.user = "SA"
para.sql.password = "password"I'm running SQL Server by using the official docker image. Para connects without errors. The driver and plugin JAR files should be placed inside the ./lib folder. I'm not sure what this class does: com.microsoft.sqlserver.jdbc.SQLServerDataSource.
I'm trying to connect to an MS SQL server database. When calling _setup it returns the accessKey / secretKey but it looks like the app is never created - logging is showing this error: