#227 hsqldb configuration v 1.7.1

v4.0
open
nobody
5
2002-11-11
2002-11-11
Peter Fagerlund
No

The new hsqldb.jar is vanilla distro with a commented out //
System.exit() in method windowClosing() in file
org.hsqldb.util.DatabaseManagerSwing. Fred Toussi will help to
get a fix in for that in the hsqldb tree.

Configuration changes includes 2 new fields in our MBean
definition as can be seen in the hsqldb-ds.xml file and
hsqldb_noNetwork-ds.xml.

<attribute name="No_system_exit">true</attribute>
Is 1.7.x configuration property for embedding

<attribute name="Persist">true</attribute>
Is a new flag with default set to true that together with <
connection-url>jdbc:hsqldb:hsql://localhost:1710</connection-url>
will start an instance of the org.hsqldb.Server class in a thread as
usual. If set to false together with <connection-url>
jdbc:hsqldb:hsql:.</connection-url>
We are running without starting a hsqldb.Server instance in a
separate thread as seen in the HypersonicDatabase MBean, no
Sockets, so hsqldb are *only* visible for other components inside
the same JVM, also hsqldb are not writing out to a *.script or any
other file and therefore no persistence over invocations.

Running as "persist == false" is by concept a "sql-cache" and can
be used either directly or throught a DataSource.

Example configuration : {jboss-head-src-distro}/connector/src/etc/
example-config/hsqldb_cache-ds.xml

Running as "persist==false" is scheeduled for thorough testing.
Below some first indications ...

/peter_f

***
Build is most - ./build.sh -Dtest=bank -Dnojars=true test

22:36:13,503 INFO [Server] Release ID: JBoss [Matrix2]
4.0.0alpha (build: CVSTag=HEAD date=200211112216)

Running Regular Invocation Persist==true
[junit] Running
org.jboss.test.bank.test.BankEJB20StressTestCase
[junit] Tests run: 10, Failures: 0, Errors: 0, Time elapsed: 122,799
sec
[junit] Running org.jboss.test.bank.test.BankStressTestCase
[junit] Tests run: 10, Failures: 0, Errors: 0, Time elapsed: 95,36
sec
BUILD SUCCESSFUL
Total time: 3 minutes 53 seconds

Running sql-cache Invocation Persist==false
[junit] Running
org.jboss.test.bank.test.BankEJB20StressTestCase
[junit] Tests run: 10, Failures: 0, Errors: 0, Time elapsed: 38,033
sec
[junit] Running org.jboss.test.bank.test.BankStressTestCase
[junit] Tests run: 10, Failures: 0, Errors: 0, Time elapsed: 28,032
sec
BUILD SUCCESSFUL
Total time: 1 minute 21 seconds

Discussion

  • Jeremy Boynes
    Jeremy Boynes
    2002-12-12

    Logged In: YES
    user_id=378919

    Now included in 3.2 branch as well