What do you need to know Matt? The driver dependency is here: https://github.com/geotools/geotools/blob/master/modules/plugin/jdbc/jdbc-sqlserver/pom.xml#L101 If your change this line in your pull request with the version number you need that would be good.
That dependency is added with a "profile": mvn clean install -D sqlserver=true There are instructions on how to install the sqlserver driver driver in the pom.xml file linked to above. The first time you run the tests it will make text file in your home folder: ~/.geotools You can edit the text file with the connection parameters for your database. References: * http://docs.geotools.org/latest/developer/conventions/test/online.html#junit-4-onlinetestsupport -- Jody Garnett On Thu, 11 Apr 2019 at 12:00, Matt Barclay <m...@growers.ag> wrote: > Hello, > > We use an Azure SQL Server instance with ActiveDirectoryPassword > authentication. This is not currently supported in GeoTools, so I am > working on adding it. The documentation for the connection string property > can be found here: > > > https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-2017 > > The JDBC URL should look something like: > > jdbc:sqlserver://mydomain.database.windows.net > ;DatabaseName=mydb;Authentication=ActiveDirectoryPassword > > This also requires a more recent version of the mssql-jdbc driver (min > version 6, current version 7.2.1). Also, the mssql-jdbc driver is now > hosted on the Maven central repository, so I have updated the pom.xml to > pull it from there instead of requiring a manual install of the mssql-jdbc > driver. > > My first pass at this feature is here: > > > https://github.com/mattbsea/geotools/commit/ae28a8b54c89731d2e09c2c9d6e3744e1a68bbe3 > > I'm not sure how to test it. I ultimately need this in GeoServer. When I > build the driver, I get gt-jdbc-sqlserver-22-SNAPSHOT.jar. So if I update > my GeoServer build for version 22-SNAPSHOT, I think I'll get my latest > code? I don't have much experience with java build systems... Any advice > would be greatly appreciated! > > Regards, > Matt > > > [image: photo] > *Matt Barclay* > Senior Software Engineer > 206.250.8960 | growers.ag > > _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel >
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
