Informix is old-school, as evident in how we perform SQL updates on a date column. If I had my way, Java applications that use it should start (Ahora Mismo!) moving to other RDBMSs that are modern, robust, scalable, and cheaper
Aggregate gathered number of units using MySQL With Rollup
Aggregate gathered number of units using MySQL’s With Rollup
How to List a Specific number of Random Rows in MySQL
Let’s say you have a list of 10 items you want to display but these items are randomly chosen items. In MySQL, you use the rand() function in the ORDER BY clause. This article demonstrates how to list a specific number of random rows my MySQL.
How to use Hibernate with simple JDBC application
This article demonstrates how to use Hibernate 4.3.x with MySQL 5.6.16 in Java using JDBC.
How to connect Java to PostgreSQL using JDBC
This is a simple post that shows how to connect Java to PostgreSQL using JDBC. Although most Java developers do not use this technique anymore, frameworks still do, and the codes are abstracted away from us. Meanwhile, some may still
MySQL JSON Type
MySQL has started supporting JSON column data type since MySQL 5.7.8. This post explores this new type and its basic usages.
Using @Query to execute a MySQL function
Using @Query to execute a MySQL function as follows. Here is an example that uses Spring Data @Query to execute a MySQL function that returns a string value. Let’s say we have a MySQL function that returns a predefined text.
Host multiple databases in a HSQLDB server
On this post, we’ll host multiple databases in a single HsqlDB server running locally on a Windows machine. The following are additional details about the Software application used. [wp_ad_camp_5] 1. HSQLDB 2.3.3 2. Windows 7 64-bit 3. Java 8 (JRE
How to determine the current size of a MySQL Database
Background [wp_ad_camp_1] Sometimes you may need to limit the size of a particular MySQL specially for demo applications. Limiting the size of a database requires determining its current size before any insert operation. This article demonstrates how to use SQL
Top n values without using a limit clause or its equivalent
Top n values without using a limit clause or its equivalent