Using Symlinks in Windows

• Using Symlinks in Windows Vista

One of the long-awaited features in Windows Vista was the ability to use symbolic links, the way you can in linux

For instance, if you wanted to make the folder C:\Users\Geek\TestFolder available from C:\TestFolder as well, you could use the following command.

C:\mklink /D C:\TestFolder C:\Users\Geek\TestFolder

symbolic link created for C:\TestFolder <<===>> C:\Users\Geek\TestFolder




Hard Link

A hard link directly points to the file, and acts to the operating system as if it is the file itself. You’ll want to use this option the majority of the time if you are trying to fake an application’s directory.

Soft Link

A soft link is essentially a shortcut to a file or folder – if you are using Windows explorer, you’ll be redirected to the directory if you double-click on a shortcut, it won’t pretend its part of the filesystem. You can still directly reference or open a file with the symlinked path, and it mostly works.

Deleting Symlinks

To delete a symlink, you can just delete the link. Just make sure you don’t delete the original file.

http://www.howtogeek.com/howto/windows-vista/using-symlinks-in-windows-vista/

HSQLDB

• HSQLDB (HyperSQL DataBase) is the leading SQL relational database engine written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. It includes a powerful command line SQL tool and simple GUI query tools.

http://hsqldb.org/

• HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92 and SQL:2008 standards.[1] It offers a fast,[2] small (around 1300 kilobytes in version 2.2) database engine which offers both in-memory and disk-based tables. Both embedded and server modes are available for purchase.

Additionally, it includes tools such as a minimal web server, command line and GUI management tools (can be run as applets), and a number of demonstration examples. It can run on Java runtimes from version 1.1 upwards, including free Java runtimes such as Kaffe.

HSQLDB is available under a BSD license. It is used as a database and persistence engine in many open source software projects, such as OpenOffice Base, LibreOffice Base, and the Standalone Roller Demo,[3] as well as in commercial products, such as Mathematica or InstallAnywhere (starting with version 8.0)
http://en.wikipedia.org/wiki/HSQLDB

• 1. The dialect is set to the database we are using which is HSQLDB

2. The JDBC driver is also set to HSQLDB
3. We set the database to one called testdb and request that the database be shutdown when our program exits
4. The default user name and passwords are used (change if yours differs)
5. I use the create-drop option to create the database and table(s) if they doesn’t exist, if they do they are dropped leaving me with a clean database each time I run the program. Other options are: create, update and validate

http://www.giantflyingsaucer.com/blog/?p=2902

• querying using hsql database manager :

select your connection

    type: HSQL DATABASE ENGINE SERVER
    Driver: jdbc.hsqldb.jdbcDriver
    URL: jdbc:hsqldb:hsql://localhost/