History for pHsqlDB

changed:
-
<img src="pHsqlDB.JPG" />

Allows to connect  to the given database, disconnect, execute queries. Results are fired as SAX events according to the table.dtd. Incase of errors the error description id fired. 

Inpins:
	
 * connect – parameters for the inpin: driver name, db connection string, user name, password

 * disconnect 

 * query – the query String to be executed

Outpins:

 * SAX_EVENT_FIRED – in case of SELECT queries, fires the result as an XML of defined format

 * ERROR – error description as String (“OK” in case of successful query execution )

The HsqlDB part may be used to connect to any database but initially it was designed to connect to HSQL database and is used in LPM web application only for connection to HSQL database. 

HSQL database is a relational database engine written in Java, with a JDBC driver, supporting a reach subset of ANSI-92 SQL. It offers a small (less than 160k), fast database engine which offers both in memory and disk based tables. Embedded and server modes are available. Additionally, it includes tools such as a minimal web server, in-memory query and management tools. The detailed information can be found at http://hsqldb.sourceforge.net.