CONTACT US: 778-373-4422 | info@mackenziemackenzie.com


Photo by Nick Wehrli from Pexels

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!

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article

About our workshop

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

About our workshop

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.

Read article

About our workshop

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.

Read article

About our workshop