HSQLDB Tip: Case Insensitive LIKE Query in HSQLDB RDBMS & Space Crunched String ComparisonJuly 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.
Tip: How To Extend HSQLDB RDBMS With Java FunctionsJuly 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.
How To Quickly Backup HSQLDB Database...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.
HSQLDB Database Connection Close Doesn't Write to Disk - SolutionJanuary 17th, 2006 HSQLDB, the famous fast RDBMS written in Java, introduced a new feature which affects code ported over from previous versions. From version 1.7.2, in-process databases are no longer closed when the last connection to the database is explicitly closed via JDBC.
How to close all connections in HSQLDB (also prevents a locking defect)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.
How To Export MS Access Database To MySQL DatabaseAugust 30th, 2008 Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL. Use mdbtools utilities as described below:
mdb-tables displays the list of tables in MS Access
mdb-scheme export the MS Access schema to MySQL database.
HSQLDB Cached Table Versus Memory Table Performance & ConversionAugust 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).
What is The Best Database for a Souped Up Hashtable?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.
Anaconda: 3-Column WordPress Theme Sneak PreviewAugust 17th, 2006 Update: I am happy to announce the long awaited release of Anaconda theme for WordPress 2.x (and above) blogs. Your search for a good css based three column WordPress theme is finally over.
The case for HSQLDB as RDBMS for Java DevelopmentMay 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.
Yet another object database on RDBMS backend: A new projectApril 18th, 2004 I have started working on creating an Object database supported by RDBMS on backend. No it is not an ORM layer.
Free JSP, Servlet Hosting ProviderJune 23rd, 2005 I was a long time user of mycgiserver.com which is the first and only provider of free JSP Hosting that I am aware of. As some of you know it was saved at the last minute by Rick H of JavaLobby fame, who supported continual survival and health of the company.
How To Register / Resolve Your Domain Name ServersOctober 6th, 2007 Domain Name Servers resolves domain names to IP addresses. However how can you resolve the domain names of the domain name servers? For examples our domain name servers are at ns1.taragana.com and ns2.taragana.com.
Next Generation CSS Based 3 Column Anaconda Theme for WordPress ReleasedSeptember 1st, 2006 I am happy to announce the long awaited release of Anaconda theme for WordPress 2.x (and above) blogs. Your search for a good css based three column WordPress theme is finally over.
New Forum for 3 Column widgetized Anaconda Theme ( WordPress )March 22nd, 2008 A new forum for 3 column widgetized Anaconda Theme is now open. It is a highly popular free WordPress theme with tons of functionality built-in and a cool look.
October 18th, 2007 at 3:28 am
My HSQLDB JUnit tests broke when I introduced a ‘date’ field in my database schema.
Thanks a lot for the tip.