HSQLDB Database Connection Close Doesn’t Write to Disk - Solution

March 5th, 2005 I have noticed that despite closing all connections and exiting a standalone HSQLDB database, at least one connection still remains open. The defect is manifested in HSQLDB 1.7.3 and HSQLDB 1.8.0 RC 8.

July 31st, 2007 HSQLDB is a high performance RDBMS written in pure Java. It can be used as a in-memory database or regular file based database.

July 21st, 2007 I previously discussed how to extend HSQLDB relational database with simple Java functions. The example there actually implements case insensitive like query functionality for HSQLDB.

July 6th, 2007 All I really want is to store a very large Hashtable with more reads than writes. It should be able to deal with more than 8GB of data.

July 17th, 2007 HSQLDB is an unique high performing, high quality Java based relational database which can be very easily extended with simple Java static functions. Here we will see how you can easily extend the database capability with a real-life example.

May 26th, 2007 Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character.

March 28th, 2006 Previously I had provided the gist of how to access MS Access database from JDBC using JDBC-ODBC bridge. Today I will elaborate on that and provide you with two sample classes.

May 19th, 2007 HSQLD is a mature, high-performant database written in Java. It is used in several high profile popular commercial and open source products like Open Office 2.0 (Office productivity suite; competitor of MS Office), JBoss (Application Server), JFox (Application Server), Jonas (Application Server), Mathemetica, Hibernate (ORM), Jira (Defect Tracking), TrackStudio (Defect Tracking), C-JDBC (Database Clustering) etc.

August 13th, 2007 In short in HSQLDB cached table sucks in terms of performance. To elaborate I was running a program which takes around 9 hours running on two medium sized cached tables (bigger one 163 MB).

January 9th, 2006 I informed in my previous post that I have decided to shun all java frameworks for my current project and develop with basic Java / J2SE components instead. Here is a synopsis of my journey as it is unfolding.

August 19th, 2006 I wrote about how I use a simple Java framework instead of ORM like Hibernate or Spring for effectively solving my data handling requirements. It has made me tremendously productive.

July 2nd, 2005 Sun Microsystems is looking at providing its Java Enterprise System (J2EE) customers with a database management solution that will either take advantage of existing open-source database management technologies or developed in-house. I think they should leverage from some high quality open source database management solutions rather than re-inventing the wheel.

November 16th, 2005 SimpleXML is PHP 5.x way to handle XML. It is simpler than DOMXML (which incidentally is very poorly documented in manual or elsewhere) which is available on PHP 4.x and much simpler than SAX solutions.

April 24th, 2009 If you come to internet for your work and not increase your social networking profile only, then irrespective of your profession or nature of surfing, sure you encounter with Wikipedia at least once. While the popularity of Wikipedia - the free encyclopedia online - grew so much that even MSN Encarta had to close down for lack of buyers, one problem remains at the core.

August 9th, 2006 I previously mentioned that I intended not to use any Java ORM frameworks. ORM frameworks I have seen so far have a steep learning curve and tend to shoe horn your architecture into their model.