HSQLDB CASE-Insensitive ‘LIKE’ QUERY – THREE Implementation Methods

  Method 1: We can use the following command to change the case sensitivity of the text-comparison of any table which we are going to create. SET IGNORECASE SET IGNORECASE { TRUE | FALSE }; · Disables (ignorecase = true) or enables (ignorecase = false) the case sensitivity of text comparison and indexing for new […]

‘Hibernate Dialect property’ for Different Databases

Hibernate is the most common and famous ORM using these days. It has a property called “Dialect” through which we tells Hibernate that we are using ‘this specific’ database. Here in this post you can see the dialect property values which we have to give for different databases. Click here to Read Full Article

HSQLDB: a lightweighted relational database

HSQLDB is a relational database engine written 100% in Java , with a JDBC driver. This supports a subset of ANSI-92 SQL. It is best known for its small size, ability to execute completely in memory and its speed. It offers a small (about 100k), fast database engine which offers both in memory and disk […]