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.
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 Escape Column Names in HSQLDB RDBMSMay 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.
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.
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.
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.
Simplest Way To Backup WordPress From BrowserJune 8th, 2008 Traditionally WordPress is backed up by backing the database and the files separately, if required. WordPress 2.5.1 introduces a much simpler way to backup the database in xml format on your desktop.
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).
How to Backup & Restore MySQL DatabaseMay 13th, 2005 Note: My WordPress database name is wordpress. I will use it in the example below.
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.
Linux / Fedora Core: How To Use rdiff-backup To Pull BackupsMay 26th, 2007 rdiff-backup is a popular, free, open source mirroring and incremental backup system for posix based operating systems like linux & Mac OS X. It uses rysnc algorithm through librsync but it doesn't use rsync.
How To Recover Files From Hard Disk CrashFebruary 13th, 2007 My desktop computers hard-disk crashed today morning without any warning. The S.M.A.R.T.
How To Install Latest Version of rdiff-backup in Fedora Core 6 and EarlierOctober 21st, 2008 Fedora Core 6 an earlier do not have the latest version of rdiff-backup - version 1.2.2. The latest version of rdiff-backup is incompatible with the earlier versions.
How To Use AWK To Simplify Scripting: Multi-Database Backup ExampleApril 20th, 2008 AWK is an extremely versatile and powerful language for processing files and text data. Often you can use awk to perform complex tasks on Unix / Linux / Mac OS command line which would otherwise take a full-fledged programming effort.
Java, JSP, Servlet, JDBC - Back To The Basics Part 2January 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.
Comment Below | 
Email this Article
Loading ...