Below is an extract from the sample binding file so that I can change the datasource and Hypersonic port from the default 1701 to 1702 (so I can run 2 JBoss on 1 machine)

Problem is the XSL transformation does not change the port.

Unfortunately the documentation describes applying this XSL to the mbean definition - but we don't use mbeans when defining datasources we use (see hsqldb-ds.xml).

Therefore, can someone please tell me the structure for a datasource so that I can fix this "sample" XSL - or tell me the correct XSl fragment!

I'm sure other people must be hitting this problem. Basically you cannot use the sample files to start 2 JBoss instances on 1 machine because of this.

Many thanks

mark



<!-- Hypersonic related services -->
<service-config name="jboss.jca:service=LocalTxDS,name=DefaultDS"
delegateClass="org.jboss.services.binding.XSLTConfigDelegate"
>
<delegate-config>
jdbc:hsqldb:hsql://${host}:${port}
<xslt-config configName="ManagedConnectionFactoryProperties"><![CDATA[
<xsl:stylesheet
xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0'>

<xsl:output method="xml" />
<xsl:param name="host"/>
<xsl:param name="port"/>

<xsl:template match="/">
<xsl:apply-templates/>
</xsl:template>

<xsl:template match="config-property[@name='ConnectionURL']">
<config-property type="java.lang.String" name="ConnectionURL">jdbc:hsqldb:hsql://<xsl:value-of select='$host'/>:<xsl:value-of select='$port'/></config-property>
</xsl:template>
<xsl:template match="*|@*">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
]]>
</xslt-config>
</delegate-config>

</service-config>

<service-config name="jboss:service=Hypersonic"
delegateClass="org.jboss.services.binding.AttributeMappingDelegate"
>
<delegate-config portName="Port" />

</service-config>