SQL Server 2005's Type 4 JDBC driver provides database connectivity from a Java application. Though the driver class and connection URL are a bit different in this version, connectivity is a snap.

Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more.

This Spring Boot, Hibernate and JPA tutorial shows how to connect Java programs to a MySQL database and test REST APIs with Swagger and JavaScript.

You could just implement a corresponding Java type that implements the SQLData interface and then tell the connection object the new SQL-Java type mapping via the Connection.setTypeMap() method.