Persist data to mssql is not working.

[ensecoz]

Hi,

I cannot setup para to be backed by mssql server. the following is my config.

para.dao = "SqlDAO"
para.sql.driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
para.sql.url = "jdbc:sqlserver://server\sub;databaseName=xxx"
para.sql.user = "user"
para.sql.password = "password"

FYI:
at para server, i have these files
/para/para-war-1.29.1.war
/para/application.conf
/para/lib/para-dao-sql-1.29.0-shaded.jar
/para/lib/mssql-jdbc-6.4.0.jre8.jar

when running para, there is warn message "[WARN ] Para configuration file 'application.(conf|json|properties)' is missing from classpath"

I am not sure why? but if I remove para.dao, everything is working fine again (without WARN message)

[albogdano]

Ok, I'll check if this is actually a bug or something else. In the meantime try running it again with -Dconfig.file=./application.conf

[ensecoz]

i'm running use your Dockerfile as base.

java $JAVA_OPTS -Djava.security.egd=file:/dev/./urandom -Dconfig.file=./application.conf -jar para-*.war

[albogdano]

The url should not start with jdbc: as that is prefix is added automatically

[albogdano]

Also that \sub; in the URL is breaking the parsing of the config file.

[ensecoz]

I removed jdbc: prefixed and update \sub to \\sub.

Now the error is much better.

[ERROR] Error loading SQL driver "com.microsoft.jdbc.sqlserver.SQLServerDriver", class not found.

Is it correct to put the driver file here?
/para/lib/mssql-jdbc-6.4.0.jre8.jar

[albogdano]

Yes, it should be put in ./lib but I'm also getting the same error... 🤔

[albogdano]

It must be a classloading issue, which I will investigate further.

[ensecoz]

@albogdano thank you for helping.

I hacked the WAR file and include the mssql-jdbc-6.4.0.jre8.jar inside the WEB-INF.

finally I get it to load driver correctly but look like the mssql syntax is not compatible with other-sql (e.g. mysql, postgresql)

This is the error i get:

Failed to create a new table for appid 'app-para' in the SQL database [Incorrect syntax near the keyword 'IF'. (Error Code: 156, SQLState: S0001)]

[albogdano]

Thanks for the report, this plugin is still kinda buggy because I haven't had the chance to fully test it with SQL Server. It's a fairly new plugin and needs some more work.

[albogdano]

This should be fixed in 1.30.0 https://github.com/Erudika/para-dao-sql/releases/tag/1.30.0