Author: shawkins
Date: 2010-03-28 23:04:36 -0400 (Sun, 28 Mar 2010)
New Revision: 2007
Modified:
trunk/adminshell/src/main/resources/connector.xsl
trunk/client/src/main/resources/vdb-deployer.xsd
Log:
TEIID-833 adding a migration tool to quickly modifiy older vdbs
Modified: trunk/adminshell/src/main/resources/connector.xsl
===================================================================
--- trunk/adminshell/src/main/resources/connector.xsl 2010-03-27 20:40:15 UTC (rev 2006)
+++ trunk/adminshell/src/main/resources/connector.xsl 2010-03-29 03:04:36 UTC (rev 2007)
@@ -1,10 +1,12 @@
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:param name="version">7.0</xsl:param>
- <xsl:output method="xml" omit-xml-declaration="yes"
indent="yes"/>
+ <xsl:output method="xml" indent="yes"/>
<xsl:strip-space elements="*"/>
- <xsl:template match="Header"/>
- <xsl:template match="VDB/ConnectorBindings/Connector">
+ <xsl:template match="VDB">
+ <xsl:if test="ConnectorBindings">
+ <connection-factories>
+ <xsl:for-each select="ConnectorBindings/Connector">
<no-tx-connection-factory>
<jndi-name><xsl:value-of select="translate(@Name, ' ',
'_')" /></jndi-name>
<xsl:choose>
@@ -45,19 +47,21 @@
<xsl:choose>
<xsl:when test="@Name='ConnectorMaxConnections' or
@Name='UsePostDelegation'
or @Name='ConnectorThreadTTL' or @Name='DeployedName'
- or @Name='ConnectorMaxThreads'
+ or @Name='ConnectorMaxThreads' or @Name='SetCriteriaBatchSize'
or @Name='ConnectorClassPath' or
@Name='SourceConnectionTestInterval'
or @Name='metamatrix.service.essentialservice' or
@Name='ServiceMonitoringEnabled'
or @Name='ConnectorClass' or @Name='ServiceClassName'
or @Name='SynchWorkers' or @Name='UseCredentialMap'
or @Name='ConnectionPoolEnabled' or
@Name='AdminConnectionsAllowed'
- or @Name='com.metamatrix.data.pool.max_connections_for_each_id' or
@Name='com.metamatrix.data.pool.live_and_unused_time'
- or @Name='com.metamatrix.data.pool.wait_for_source_time' or
@Name='com.metamatrix.data.pool.cleaning_interval'
- or @Name='com.metamatrix.data.pool.enable_shrinking' or
starts-with(@Name, 'getMax')
+ or starts-with((a)Name,'com.metamatrix.data.pool') or starts-with(@Name,
'getMax')
or starts-with(@Name, 'supports') or starts-with(@Name,
'getSupported')
or @Name='requiresCriteria' or @Name='useAnsiJoin'
or @Name='URL' or @Name='ConnectionSource'
- or @Name='User' or @Name='Password'"/>
+ or @Name='User' or @Name='Password' or starts-with(@Name,
'ResultSetCache')
+ or starts-with(@Name, 'Extension') or @Name='Driver'
+ or @Name='MaxSQLLength'">
+ <xsl:comment><config-property name="<xsl:value-of
select="@Name"/>"><xsl:value-of
select="text()"/></config-property></xsl:comment>
+ </xsl:when>
<xsl:when test="@Name='MaxResultRows' and
text()='0'">
<config-property>
<xsl:attribute name="name">
@@ -83,6 +87,7 @@
or starts-with(@ComponentType,'HSQLDB ') or
starts-with(@ComponentType,'Sybase ')
">
<config-property name="SourceJNDIName">java:<xsl:value-of
select="translate(@Name, ' ', '_')"
/>DS</config-property>
+ <xsl:message>For connector binding "<xsl:value-of
select="@Name" />" of legacy type "<xsl:value-of
select="@ComponentType" />", you will need to create a -ds.xml JDBC
DataSource with JNDI name <xsl:value-of select="translate(@Name, ' ',
'_')" />DS</xsl:message>
<xsl:choose>
<xsl:when test="starts-with(@ComponentType,'Apache ')">
<config-property
name="ExtensionTranslationClassName">org.teiid.connector.jdbc.derby.DerbySQLTranslator</config-property>
@@ -122,9 +127,12 @@
<xsl:if test="contains(@ComponentType,'XA')">
<config-property name="IsXA">true</config-property>
</xsl:if>
- <xsl:if
test="Properties/Property[@Name='ConnectorMaxConnections']">
- <max-pool-size><xsl:value-of
select="Properties/Property[@Name='ConnectorMaxConnections']/text()"/></max-pool-size>
+ <xsl:if test="Properties/Property[@Name='ConnectorMaxConnections' or
@Name='com.metamatrix.data.pool.max_connections']">
+ <max-pool-size><xsl:value-of
select="Properties/Property[@Name='ConnectorMaxConnections' or
@Name='com.metamatrix.data.pool.max_connections']/text()"/></max-pool-size>
</xsl:if>
</no-tx-connection-factory>
+ </xsl:for-each>
+ </connection-factories>
+ </xsl:if>
</xsl:template>
</xsl:stylesheet>
Modified: trunk/client/src/main/resources/vdb-deployer.xsd
===================================================================
--- trunk/client/src/main/resources/vdb-deployer.xsd 2010-03-27 20:40:15 UTC (rev 2006)
+++ trunk/client/src/main/resources/vdb-deployer.xsd 2010-03-29 03:04:36 UTC (rev 2007)
@@ -36,19 +36,7 @@
</xs:element>
</xs:sequence>
<xs:attribute name="name" type="xs:string"
use="required"/>
- <xs:attribute name="type" default="PHYSICAL">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="PHYSICAL"/>
- <xs:enumeration value="VIRTUAL"/>
- <xs:enumeration value="FUNCTION"/>
- <xs:enumeration value="TYPE"/>
- <xs:enumeration value="EXTENSION"/>
- <xs:enumeration value="LOGICAL"/>
- <xs:enumeration value="MATERIALIZATION"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
+ <xs:attribute name="type" type="xs:string"
default="PHYSICAL"/>
<xs:attribute name="visible" type="xs:boolean"
default="true"/>
<xs:attribute name="path"
type="xs:string"/>
</xs:complexType>