Database HSQLDB Tips

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.

· Disables (ignorecase = true) or enables (ignorecase = false) the case sensitivity of text comparison and indexing for new tables.· By default, character columns in new databases are case sensitive. The sensitivity must be switched before creating tables.· Existing tables and their data are not affected.· When switched on, the data type VARCHAR is set to VARCHAR_IGNORECASE in new tables.· Alternatively, we can specify the VARCHAR_IGNORECASE type for the definition of individual columns. So it is possible to have some columns case sensitive and some not, even in the same table.· Only an administrator may do this.Link:

Method 2: We can extend HSQLDB with JAVA functions.

Java function to do the case-insensitive searchpublic static boolean containsMatch(String target, String search) {return target.toLowerCase().contains(search.toLowerCase());}

  • This function must be a public static function.
  • Same as the Stored Procedures in HSQLDB

Query used to get the dataselect distinct “COLUMN NAME” from Sheet where ""("COLUMN NAME", ‘String to search’)Link:

Method 3: We can use the methods like LCASE or UCASE to the column name. It’s giving inside the SQL QUERY itself. This will first convert that column values into a SPECIFIC CASE before comparison.

SQL QuerySelect FIELD_NAME from TABLE_NAME WHERE “+ “LCASE (FIELD_NAME) LIKE ‘%” + search_String + “%’We can also use UCASESelect FIELD_NAME from TABLE_NAME WHERE “+ “UCASE (FIELD_NAME) LIKE ‘%” + search_String + “%’Here search_String is the string which we want to search inside that database.Link:,,

HSQLDB J2EE Java jTrac opensource Spring Spring MVC Spring Web Flow

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 during it’s development.

Click here to visit JTrack’s home. To download click here

Related post :  JTrac

Technorati tags: JTrac, Opensource

Database HSQLDB Java JDBC opensource Softwares

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 based tables. Embedded and server modes are available. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets or servlets, too) and a number of demonstration examples.This is currently being used as a database and persistence engine in many Open Source Software projects and even in commercial projects and products! It is free under the Modified BSD License.

HSQLDB home : here
Features of hsqldb : here
Known problems with hsqldb: here

Technorati Tags : HSQLDB,

Frameworks Hibernate HSQLDB J2EE Java jTrac Spring

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 the Spring Framework and Hibernate. This is designed to be generic, you can customize fields to track items (like bugs) & allocate tasks etc. It has a simple user interface and using a small database called HSQLDB. To use the jTrac we just have to do the following. Copy the war file to the servlet-engine then start it 🙂 . HSQLDB will automatically starts at the time of engines startup.

Some features of the jTrac are listed below

  • Add custom fields and drop downs
  • Per-project customizable workflow
  • Field-level permissions
  • Detailed history view
  • E-mail notifications
  • File attachments
  • Full text search
  • Search and filter even on custom fields
  • Dashboard view of statistics
  • Export data and search results to Excel
  • Support for anonymous browsing of projects
  • Relate items to each other, e.g. “duplicate of”, “depends on” etc.
  • Support for all popular databases
  • Database upgrade and migration scripts available
  • Embedded database and web-app server – download and start using right away!

If you want to refer more about its features then please visit here
You can download it from here and the newest version available is 2.0-RC3-update1.

Reference: jTrack Home

Technorati Tags: jTrack, Bug tracking, Spring Framework, HSQLDB