To run you'll need to download and install the Microsoft SQL Server JDBC driver and install using maven.
The driver is not available via the normal public maven resources so you need to download it separately, then run maven build phase to ensure project dependencies are setup correctly.
- Get the Microsoft SQL Server JDBC driver.
- Install the driver.
- Run maven clean verify (
mvn clean verify
) to ensure all project dependencies are downloaded and setup. - Add to DBConnect class: database endpoint and port number, username and password.
- Check the SELECT statement in DBConnect (line 34/35) is what you expect.
- Run Main to test a SQL Server connection.