Greetings,
I been browsing org.jboss.jdbc.HypersonicDatabase where on line 26 it sez :
* Note that once started it cannot be shutdown
The org.jboss.jdbc.HypersonicDatabase implements MBeanRegistration.
So all that is needed is to send a [SHUTDOWN] command in a jdbc connection
for hsql to shutdown cleanly (give it a chance to write out its memory cache
and set the 'modified=no' in its property file).
Today the MBean Server is Destroying the HypersonicDatabaseMBean without
notifying the embedded org.hsql.Server (semantics from in how it is started
?) - the result is that hsql will try to recover every time JBoss is started
anew. This will show in the default.properties field 'modified=yes' - when
it should be 'modified=no' in a clean shutdown. The default.script will grow
from last time*n and never have a chance to get flushed other then manually.
Note this will only manifest if hsql is used and then all changes during
every invocation run, will be written to the default.script file for
recovery purpose.
One solution is for the MServer to call the instance of org.hsql.Server with
a [SHUTDOWN] in a jdbc connection. Before MServer destroys the
HypersonicDatabaseMBean wrapper class.
This leads me into the opportunity of asking what the "think" is for having
both Hypersonic and InstantDB started as default MBeans ? ...
If there is seen to be merit in Hypersonic. I will try make a patch,
as a smoth introduction for me into MBeans, and if so, all feeback on how to
do it is more then welcome.
/peter
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
