MSSQL not visible in Community edition (via Docker) in Data Source

dan.andraschko · November 29, 2024, 12:01am

Hey there,

I’ve set up HI in community edition 3.1.0 from github via Docker. It runs flawlessly but the only issue is that I can’t integrate mssql drivers to build up a connection to my mssql database.

The driver mssql-jdbc-12.8.1.jre8.jar is copied in the hi-repository/System/Drivers folder.
Is there anything else to do so that I can choose the mssql in creating data source dropdown for selecting the driver?

Another question: Is it possible that gihub project is being updated to 5.2., the current version of hice?

Thanks in avance,
Daniel

helicalforum · November 29, 2024, 9:50am

remove the older driver which you have put
download and put this driver at that location (https://repo1.maven.org/maven2/com/microsoft/sqlserver/mssql-jdbc/7.2.0.jre8/mssql-jdbc-7.2.0.jre8.jar)
then try by making a new connection. Delete browser cache also.

dan.andraschko · December 1, 2024, 10:49pm

Ive done what you’ve told me, but I still can’t access the mssql driver.

Screenshot below, Browser is Firefox - cache cleared before.

dan.andraschko · December 1, 2024, 10:59pm

And this is the content of the /hi-repository/System/Drivers/ folder:

helicalforum · December 4, 2024, 5:07am

Hello,

Please add the same driver “mssql-jdbc-7.2.0.jre8.jar” into lib folder located at “…\TOMCAT LOCATION\webapps\hi-ce\WEB-INF\lib”.

Once added in the lib, please restart Tomcat service.

If it is still not visible then drop an email to support@helicalinsight.com. We will setup a call with you and see what help we can extend on a screensharing call.

Thank you