1

I have set up an HTTPS connection between GeoServer and an Azure database using the SQL Server extension, however I would like to add encryption options to the connection string. Is this possible in GeoServer 2.16 (currently running on Tomcat 9)? Would I have to modify the actual extension itself?

0

It looks like you would need to modify SQLServerDataStoreFactory to have some extra parameters (as documented here). Then modify getJDBCUrl to add those parameters to the generated URL, the INTSEC parameter shows how this is done.

  • disclaimer: I have never used java before. I decompiled the extension (jar), added the necessary parameters, and am trying to recompile the java into a class. This is what I'm running: javac -cp ".;dir\geoserver.war;dir\gt-jdbc-sqlserver-22.0.jar" "dir\SQLServerDataStoreFactory.java" (dir is the directory the files are in). However, I'm getting errors that packages don't exist (like org.geotools.jdbc). Where would I get these packages? – GIS87 Oct 3 '19 at 17:29
  • please see docs.geotools.org/latest/developer/docs/index.html for how to compile a GeoTools jar - – Ian Turton Oct 4 '19 at 9:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.