Its compact size and generous licensing terms make it ideal for standalone applications and for testing and prototyping. It is written entirely in Java, so it will run on all the Java platforms; it is compact, weighing only K and, since it is an open source project, there is no per CPU license. This graph is for a test in which HSQLDB blue line is over 20 times faster than comparable products image from test results published on PolePosition web site. The latest version features the most extensive set of SQL features ever in an open-srouce database engine. If the database does not exist already, it will be created automatically. Release Candidate versions have been available during and will lead to the release of version 2. Today This Week All-Time.
|Date Added:||20 November 2004|
|File Size:||37.76 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
The latest version features the most extensive set of SQL features ever in an open-srouce database engine. Hypersonic SQL operates in one of three modes: Point releases have appeared on average twice a year. Post a comment Email Article Print Article.
JDBC – ODBC Drivers, Connections and Strings (URL)
It connects as user SA and an empty password:. The Hypersonic SQL project stopped development in late and was closed in We orbc actively developed and released 8 new versions of the database since April and the code has moved on from the Hypersonic SQL original.
In other words, information is lost after the application terminates. It is also useful for testing and prototyping. Most Popular Developer Stories.
The following examples illustrates the possibilities:. The first release of 1. Recent new features include hot backup, multi-billion row tables, extended SQL syntax compatibility modes, JEE XA transactions, connection pool and many new built-in functions.
This graph is for a test in which HSQLDB blue line is over 20 times faster than comparable products image from test results published on PolePosition web site. Hypersonic SQL was a small open-source all-Java database engine, first released with source in If the database does not exist already, it will be created automatically.
We have been able to fulfil many requests for additional features or bug fixes and will continue to give priority to what users ask for.
Hypersonic SQL is an open-source database written in Java. After the release of version 1.
Second, they are too difficult to set up and maintain for your average desktop user. Completely free of cost or restrictions and fully compatible with all major open source licenses. When you contribute code, you are expected to contribute tests that validate your code. His own Web site is http: Hypersonic SQL also supports auto-numbering columns, called identity columns. We have maintained our leading position through continuous enhancements.
Since each record is automatically assigned a unique number, identity columns are ideal primary keys. Participation in the program is by annual subscription or sponsorship.
JDBC:ODBC driver for jboss-hypersonic required |JBoss Developer
It is also the database engine in OpenOffice. The following code snippet connects to a standalone database called “demo” in the “db” folder. The project enjoys a high ranking among all SourceForge projectswith over 1, direct downloads. Code for both efforts can be downloaded from the SVN repository. You are encouraged to report any issues during development and we will fix them promptly. By default, the database relies on a rudimentary file format: There are few alternatives for standalone projects.
Hypersonic SQL has several interesting characteristics: You can download the latest version from http: It simply writes the SQL statements in a script file.