How to Use Java with JDBC on Azure SQL databases.
08-October-2021
Java can connect to most kinds of databases that can be found, and Azure SQL databases are no different.
In this episode I’ll take you through how to use JDBC to connect to your Azure SQL databases found
online. We’ll look at which jar file you’ll need to put in your project so that JDBC will work for CRUD
on your database. I’ll demonstrate how to read data from an SQL query into a ResultSet, and how to
perform an insert into a table and receive back the auto-generated ID created on an identity column,
which you can then use to perform other operations without having to go back and look up that key.
I’ll be using Eclipse with JRE 16 and the matching JDBC driver downloaded from Microsoft.
Data Engineering Project? Contact me today!