When connecting to a MySQL database, you may encounter this scary warning message. Thu Feb 04 14:49:25 IST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate [...]

JDBC has support for storing binary files in the database using the BLOB datatype. I covered this in a previous blog post: Reading and Writing BLOBs with MySQL. However, you may run into errors if you need to store large files. In particular, you may encounter the following error messages: Packets larger than max_allowed_packet are not allowed. Data too long [...]

I recently had a person ask the following question: For the employees table, every time I insert a new value in salary column the previous value is overwritten. Can we add new inserted value to the previous salary value before it is overwritten? Yes, we can accomplish this by using MySQL Triggers. Here's a quick run of the application so [...]

In this blog post, I'll show you how to insert data into the database with user input. When you run the program, it will prompt you to enter your last name, first name and email address. Here's a sample run of the app: [code] Enter your last name: Davis Enter your first name: Sammy Enter your email: sammy@test.com Insert complete. [...]

In this blog post, I'll show you how to insert a date and time value into the database. The date and time is collectively known as a timestamp. JDBC has builtin support for saving and reading timestamps. This support is provided by java.sql.Timestamp. Let's assume we have this database table schema below. Make note of the timestamp column called checkout_time. [...]

Download the Java Source Code