Remember to shutdown your database

I was working on a project which uses Spring, Jdbc, Jpa and HSQLDB.

It is meant to be executed as a batch program from command line with multi threaded support.

After a while, I noticed that my final few commits to the database is never captured properly by the database. After checking to see if my threads, jpa or spring context is closed properly, I finally figured out it is because I never shutdown my HSQLDB properly. Even though I am using it as a file based database, I must still issue a shutdown command.

For those of you trying to work with embedded database, do remember to shut it down when your program exits.

Hopes this kind reminder will safe you hours of debugging.

Documentum DQL to retrieve latest version of an object

To find the latest version of a dm_document from documentum based on r_object_id, use the following dql.

select r_object_id from dm_document where i_chronicle_id in (select i_chronicle_id from dm_document(all) where r_object_id = '?')

Show current Windows Media Player music status in Google Talk

My Google Talk is not showing the current music I am playing in Windows Media Player even though I had enabled the show current music status. After consulting Google Talk Help, I found the following tips. So, the following is for the convenience of those who faced the same problem as me.

Windows Media Player is designed to disable all plug-ins (including the Google Talk music status plug-in) whenever Windows Media Player or your Windows desktop crashes. To re-enable the Google Talk plug-in:

1. Open Windows Media Player.
2. From the View menu, select Plug-ins > Options...
3. From the Category section of the Plug-ins tab, select Background.
4. Select the Google Talk Music Plugin checkbox.
5. Click OK.

You'll need to close and restart Windows Media Player for your change to take effect.