JDBC Tutorial part 1/3 – Database connections

In this video, Alejandro Duarte explains how to open a connection from a Java program to an SQL database using a JDBC driver and how to safely close the connection even in error conditions. JDBC stands for Java Database Connectivity and it's the API used internally by persistence frameworks such as JPA, Hibernate, MyBatis, and jOOQ.

0:00 JDBC
0:52 Creating a new empty Maven project
1:40 Installing MariaDB ® using Brew
2:40 Checking the current database user
3:29 Checking the server port
3:44 Setting a password
4:18 Configuring IntelliJ IDEA Ultimate
5:51 Creating a new database
7:30 Adding a JDBC driver
8:48 Opening a database connection
12:45 Closing a database connection
13:35 Closing connections on errors

#Java #Databases #MariaDB #SQL

MariaDB is making a big impact on the world. Whether you’re checking your bank account, buying a coffee, shopping online, making a phone call, listening to music, taking out a loan, or ordering takeout–MariaDB is the backbone of applications used every day. Companies small and large, including 75% of the Fortune 500 run MariaDB, touching the lives of billions of people. With massive reach through Linux distributions, enterprise deployments, and public clouds, MariaDB is uniquely positioned as the leading database for modern application development.

[asdfasdfasdfasdf]

Thanks for this. Will other drivers (for Python, C, Go, Rust, etc) be considered?

[antipov]

This must be "full" version of IntelliJ? I don't find my Database tab like you opened in min 4:09.