Bugs item #844654, was opened at 2003-11-18 12:06
Message generated for change (Comment added) made by genman
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=844654&group_id=22866

Category: JBossMQ
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: Elias Ross (genman)
Assigned to: Nobody/Anonymous (nobody)
Summary: HSQL datasource -- should issue "SHUTDOWN"

Initial Comment:

This may or may not be JMS specific, but it relates to
the default Persistence Manager used in JBoss 3.2.2
which uses "cached" tables.

It appears that SHUTDOWN is not issued to the HSQL DB
when JBoss is taken down.  

It should be easy to make the HSQL plug service work
with cached tables and then do the right thing upon
shutdown.  Or, create a new service which issues the
shutdown request.

----------------------------------------------------------------------

>Comment By: Elias Ross (genman)
Date: 2003-11-18 15:18

Message:
Logged In: YES 
user_id=556458


I wrote an MBean to do this and it works okay.  I don't know
if it would be better to update the connection manager (RA
deployer???) or make people use this externally declared
MBean instead.  I'm starting to to think this is the wrong
approach:

<datasources>
   <local-tx-datasource>
      ...
      <depends>jboss:service=HSQLShutdown</depends>
   </local-tx-datasource>

   <!-- This MBean should be used for cached tables. -->
   <mbean code="org.jboss.jdbc.DBShutdown"
     name="jboss:service=HSQLShutdown">
     <attribute
name="ConnectionURL">jdbc:hsqldb:${jboss.server.data.dir}/jms</attribute>
     <attribute
name="DriverClass">org.hsqldb.jdbcDriver</attribute>
     <attribute name="UserName">sa</attribute>
     <attribute name="Password"></attribute>
     <attribute name="ShutdownSQL">SHUTDOWN COMPACT</attribute>
   </mbean>
</datasources>


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=844654&group_id=22866


-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?  SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to