Configure two instance of Hypersonic database

[Patel Biren]

Hi,

I am running JBoss (5.1) with two instances of Hypersonic database. One as in-process database and the jndi-name is "DefaultDS". Second instance, I am running as server mode and the jndi-name is "externalDS" which runs with schema used by our applications. Both works fine however during JBoss startup it gives JVM_Bind (port in use) error for the second database. Here is the configuration for the second database in hsqldb-ds.xml

    <local-tx-datasource>

      <jndi-name>TimesTenDS</jndi-name>
    
      <connection-url>jdbc:hsqldb:hsql://localhost:5555/refdbds</connection-url>
      <driver-class>org.hsqldb.jdbcDriver</driver-class>
      <user-name>sa</user-name>
      <password></password>

      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <idle-timeout-minutes>0</idle-timeout-minutes>

      <track-statements/>
      <!--  security-domain>HsqlDbRealm</security-domain>   --> 

      <prepared-statement-cache-size>32</prepared-statement-cache-size>

      <metadata>
         <type-mapping>Hypersonic SQL</type-mapping>
      </metadata>
      <depends>jboss:service=Hypersonic,database=refdbds</depends>
    
   </local-tx-datasource>

   <mbean code="org.jboss.jdbc.HypersonicDatabase" name="jboss:service=Hypersonic,database=refdbds">
     <attribute name="Port">5555</attribute>
     <attribute name="BindAddress">${jboss.bind.address}</attribute>   
     <attribute name="Silent">true</attribute>
     <attribute name="Database">refdbds</attribute>
     <attribute name="Trace">true</attribute>
     <attribute name="No_system_exit">true</attribute>
   </mbean>

As I said both the database works fine, I am trying to resolve error during JBoss startup.