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 newContinue reading “HSQLDB CASE-Insensitive ‘LIKE’ QUERY – THREE Implementation Methods”

JTrac 2.0 released

The open source issue tracker JTrac’s new version (v2.0) is released. This version is more flexible than the old versions. So many options like the new Dashboard which includes search, view status are more useful to the user. It also features multi-language support now. The latest spring technology “Spring web flow” is also used duringContinue reading “JTrac 2.0 released”

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 diskContinue reading “HSQLDB: a lightweighted relational database”

jTrac : a lightweight Bug tracking system build on Spring

Have you ever used jTrac? … If you want to track the errors and issues causing with in the development or testing environment then, I am sure this will be better option for you. jTrac is a web-based application ideal for issue tracking with built-in workflow. It is a lightweight J2EE application built on theContinue reading “jTrac : a lightweight Bug tracking system build on Spring”