Author: vhalbert(a)redhat.com Date: 2009-09-11 15:20:59 -0400 (Fri, 11 Sep 2009) New Revision: 1329 Added: trunk/test-integration/db/src/main/resources/configuration.xml trunk/test-integration/db/src/main/resources/datasources/datasource_mapping.xml trunk/test-integration/db/src/main/resources/datasources/derby/example_connection.properties trunk/test-integration/db/src/main/resources/datasources/readme.txt trunk/test-integration/db/src/main/resources/ddl/adminparms.txt trunk/test-integration/db/src/main/resources/ddl/db2/create_tables.sql trunk/test-integration/db/src/main/resources/ddl/db2/drop_tables.sql trunk/test-integration/db/src/main/resources/ddl/db2/exec_parms.properties trunk/test-integration/db/src/main/resources/ddl/derby/create_tables.sql trunk/test-integration/db/src/main/resources/ddl/derby/drop_tables.sql trunk/test-integration/db/src/main/resources/ddl/derby/exec_parms.properties trunk/test-integration/db/src/main/resources/ddl/exec_parms.properties_template trunk/test-integration/db/src/main/resources/ddl/manage_schemas.xml trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql trunk/test-integration/db/src/main/resources/ddl/mysql/drop_tables.sql trunk/test-integration/db/src/main/resources/ddl/mysql/exec_parms.properties trunk/test-integration/db/src/main/resources/ddl/oracle/create_tables.sql trunk/test-integration/db/src/main/resources/ddl/oracle/drop_tables.sql trunk/test-integration/db/src/main/resources/ddl/oracle/exec_parms.properties trunk/test-integration/db/src/main/resources/ddl/postgres/create_tables.sql trunk/test-integration/db/src/main/resources/ddl/postgres/drop_tables.sql trunk/test-integration/db/src/main/resources/ddl/postgres/exec_parms.properties trunk/test-integration/db/src/main/resources/ddl/run_ddl.xml trunk/test-integration/db/src/main/resources/default-config.properties trunk/test-integration/db/src/main/resources/mysql/connection.properties Log: Teiid 773 - organize integration test Added: trunk/test-integration/db/src/main/resources/configuration.xml =================================================================== --- trunk/test-integration/db/src/main/resources/configuration.xml (rev 0) +++ trunk/test-integration/db/src/main/resources/configuration.xml 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,458 @@ +<?xml version="1.0" encoding="UTF-8"?> +<ConfigurationDocument> + <Header> + <ApplicationCreatedBy>Teiid</ApplicationCreatedBy> + <ApplicationVersionCreatedBy>6.0</ApplicationVersionCreatedBy> + <UserCreatedBy>Configuration</UserCreatedBy> + <ConfigurationVersion>6.0</ConfigurationVersion> + <MetaMatrixSystemVersion>6.0</MetaMatrixSystemVersion> + <Time>2009-03-20T12:23:53.919-06:00</Time> + </Header> + <Configuration Name="Next Startup" ComponentType="Configuration" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <Properties /> + </Configuration> + <Services> + <Service Name="QueryService" ComponentType="QueryService" QueuedService="false" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <Properties> + <Property Name="metamatrix.service.essentialservice">false</Property> + <Property Name="ProcessPoolMaxThreads">64</Property> + <Property Name="ProcessPoolThreadTTL">120000</Property> + <Property Name="ServiceClassName">com.metamatrix.server.query.service.QueryService</Property> + <Property Name="ProcessorTimeslice">2000</Property> + <Property Name="MaxCodeTables">50</Property> + <Property Name="MaxCodeTableRecords">10000</Property> + <Property Name="MinFetchSize">100</Property> + <Property Name="MaxFetchSize">20000</Property> + <Property Name="ResultSetCacheEnabled">0</Property> + <Property Name="ResultSetCacheMaxSize">0</Property> + <Property Name="ResultSetCacheMaxAge">0</Property> + <Property Name="ResultSetCacheScope">vdb</Property> + <Property Name="MaxPlanCacheSize">100</Property> + </Properties> + </Service> + </Services> + <ComponentTypes> + <ComponentType Name="Service" ComponentTypeCode="1" Deployable="false" Deprecated="false" Monitorable="false" ParentComponentType="VM" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ServiceClassName" DisplayName="Service Class Name" ShortDescription="" PropertyType="String" IsModifiable="false" IsMasked="false" /> + <PropertyDefinition Name="metamatrix.service.essentialservice" DisplayName="Essential Service" ShortDescription="Indicates if the service is essential to operation of the Integration Server" DefaultValue="false" PropertyType="Boolean" IsModifable="false" IsMasked="false" /> + </ComponentType> + <ComponentType Name="QueryService" ComponentTypeCode="1" Deployable="true" Deprecated="false" Monitorable="true" SuperComponentType="Service" ParentComponentType="Integration Server" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + </ComponentType> + <ComponentType Name="Configuration" ComponentTypeCode="0" Deployable="true" Deprecated="false" Monitorable="false" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + </ComponentType> + <!-- + ************************************************************************************* + Connector Type (This section gets filled by build process at kit building time) + ************************************************************************************* + --> + <ComponentType Name="Connector" ComponentTypeCode="2" Deployable="false" Deprecated="false" Monitorable="true" SuperComponentType="Service" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.916-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.916-06:00"> + <PropertyDefinition Name="SourceConnectionTestInterval" DisplayName="Data Source Test Connect Interval (seconds)" ShortDescription="How often (in seconds) to create test connections to the underlying datasource to see if it is available." DefaultValue="600" IsRequired="true" PropertyType="Integer" IsExpert="true" /> + <PropertyDefinition Name="ConnectorClassPath" DisplayName="Class Path" ShortDescription="" /> + <PropertyDefinition Name="ConnectorTypeClassPath" DisplayName="Connector Type Class Path" ShortDescription="Connector Type classpath (defined by system)" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="UsePostDelegation" DisplayName="Use Separate Classloader" ShortDescription="Set to true to indicate that the connector classpath and connector type classpath entries should be loaded by a connector specific post-delegation class loader." PropertyType="Boolean" IsRequired="true" IsExpert="true" DefaultValue="false"/> + <PropertyDefinition Name="ExceptionOnMaxRows" DisplayName="Exception on Exceeding Max Rows" ShortDescription="Indicates if an Exception should be thrown if the specified value for Maximum Result Rows is exceeded; else no exception and no more than the maximum will be returned" DefaultValue="true" IsRequired="true" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="metamatrix.service.essentialservice" DisplayName="Essential Service" ShortDescription="Indicates if the service is essential to operation of the Integration Server" DefaultValue="false" IsRequired="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="ServiceMonitoringEnabled" DisplayName="Data Source Monitoring Enabled" ShortDescription="Whether to monitor the underlying data source to see if it is available." DefaultValue="true" IsRequired="true" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="Immutable" DisplayName="Is Immutable" ShortDescription="True if the source never changes." DefaultValue="false" IsRequired="true" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="ConnectorMaxConnections" DisplayName="Maximum Concurrent Connections" ShortDescription="" DefaultValue="20" IsRequired="true" PropertyType="Integer" IsExpert="true" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" IsRequired="true" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="ServiceClassName" DisplayName="Service Class Name" ShortDescription="" DefaultValue="com.metamatrix.server.connector.service.ConnectorService" IsRequired="true" IsModifiable="false" /> + <PropertyDefinition Name="MaxResultRows" DisplayName="Maximum Result Rows" ShortDescription="" DefaultValue="10000" IsRequired="true" PropertyType="Integer" IsExpert="true" /> + <PropertyDefinition Name="SynchWorkers" DisplayName="Synchronous Workers" ShortDescription="Whether worker threads will be bound to connections. Asynch connectors should set this value to false." DefaultValue="true" IsRequired="true" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="ResultSetCacheEnabled" DisplayName="ResultSet Cache Enabled" ShortDescription="" DefaultValue="false" PropertyType="Boolean" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="ResultSetCacheMaxSize" DisplayName="ResultSet Cache Maximum Size (megabytes)" ShortDescription="" DefaultValue="20" PropertyType="Integer" IsExpert="true" /> + <PropertyDefinition Name="ResultSetCacheMaxAge" DisplayName="ResultSet Cache Maximum Age (milliseconds)" ShortDescription="" DefaultValue="3600000" PropertyType="Long" IsExpert="true" /> + <PropertyDefinition Name="ResultSetCacheScope" DisplayName="ResultSet Cache Scope" ShortDescription="" DefaultValue="vdb" IsExpert="true"> + <AllowedValue>vdb</AllowedValue> + <AllowedValue>session</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Set to true if this is an XA Connector" DefaultValue="false" IsRequired="true" PropertyType="Boolean" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="ConnectionPoolEnabled" DisplayName="Connection Pool Enabled" ShortDescription="Enable the use of connection pooling with this connector." DefaultValue="true" IsRequired="true" PropertyType="Boolean" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="UseCredentialMap" DisplayName="Requires Credential Map" ShortDescription="Set to true if this connector requires credentials to be passed via a credential map." DefaultValue="false" IsRequired="true" PropertyType="Boolean" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="AdminConnectionsAllowed" DisplayName="Admin Connections Allowed" ShortDescription="Whether admin connections without an execution context are allowed." DefaultValue="true" IsRequired="true" PropertyType="Boolean" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="com.metamatrix.data.pool.max_connections_for_each_id" DisplayName="Pool Maximum Connections for Each ID" ShortDescription="Set the maximum number of connections for each connector ID for the connection pool" DefaultValue="20" IsRequired="true" PropertyType="Integer" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="com.metamatrix.data.pool.live_and_unused_time" DisplayName="Pool Connection Idle Time (seconds)" ShortDescription="Set the idle time of the connection before it should be closed if pool shrinking is enabled" DefaultValue="60" PropertyType="Integer" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="com.metamatrix.data.pool.wait_for_source_time" DisplayName="Pool Connection Waiting Time (milliseconds)" ShortDescription="Set the time to wait if the connection is not available" DefaultValue="120000" PropertyType="Integer" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="com.metamatrix.data.pool.cleaning_interval" DisplayName="Pool cleaning Interval (seconds)" ShortDescription="Set the interval to cleaning the pool" DefaultValue="60" PropertyType="Integer" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="com.metamatrix.data.pool.enable_shrinking" DisplayName="Enable Pool Shrinking" ShortDescription="Set whether to enable the pool shrinking" DefaultValue="false" PropertyType="Boolean" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="supportsCompareCriteriaEquals" DisplayName="supportsCompareCriteriaEquals" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsCompareCriteriaOrdered" DisplayName="supportsCompareCriteriaOrdered" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsInCriteria" DisplayName="supportsInCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="getMaxInCriteriaSize" DisplayName="getMaxInCriteriaSize" ShortDescription="" PropertyType="Integer" IsExpert="true" /> + <PropertyDefinition Name="supportsIsNullCriteria" DisplayName="supportsIsNullCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsLikeCriteria" DisplayName="supportsLikeCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsLikeCriteriaEscapeCharacter" DisplayName="supportsLikeCriteriaEscapeCharacter" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsNotCriteria" DisplayName="supportsNotCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsOrCriteria" DisplayName="supportsOrCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsBetweenCriteria" DisplayName="supportsBetweenCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsSelectDistinct" DisplayName="supportsSelectDistinct" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsSelectExpression" DisplayName="supportsSelectExpression" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsInnerJoins" DisplayName="supportsInnerJoins" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsAliasedGroup" DisplayName="supportsAliasedGroup" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsSelfJoins" DisplayName="supportsSelfJoins" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsOuterJoins" DisplayName="supportsOuterJoins" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsFullOuterJoins" DisplayName="supportsFullOuterJoins" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="getMaxFromGroups" DisplayName="getMaxFromGroups" ShortDescription="" PropertyType="Integer" IsExpert="true" /> + <PropertyDefinition Name="getSupportedJoinCriteria" DisplayName="getSupportedJoinCriteria" ShortDescription="" PropertyType="String" IsExpert="true" > + <AllowedValue>ANY</AllowedValue> + <AllowedValue>THETA</AllowedValue> + <AllowedValue>EQUI</AllowedValue> + <AllowedValue>KEY</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="supportsOrderBy" DisplayName="supportsOrderBy" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsGroupBy" DisplayName="supportsGroupBy" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsFunctionsInGroupBy" DisplayName="supportsFunctionsInGroupBy" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsHaving" DisplayName="supportsHaving" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsAggregatesSum" DisplayName="supportsAggregatesSum" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsAggregatesAvg" DisplayName="supportsAggregatesAvg" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsAggregatesMin" DisplayName="supportsAggregatesMin" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsAggregatesMax" DisplayName="supportsAggregatesMax" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsAggregatesCount" DisplayName="supportsAggregatesCount" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsAggregatesCountStar" DisplayName="supportsAggregatesCountStar" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsAggregatesDistinct" DisplayName="supportsAggregatesDistinct" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsInCriteriaSubquery" DisplayName="supportsInCriteriaSubquery" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsExistsCriteria" DisplayName="supportsExistsCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsQuantifiedCompareCriteriaSome" DisplayName="supportsQuantifiedCompareCriteriaSome" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsQuantifiedCompareCriteriaAll" DisplayName="supportsQuantifiedCompareCriteriaAll" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsScalarSubqueries" DisplayName="supportsScalarSubqueries" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsCorrelatedSubqueries" DisplayName="supportsCorrelatedSubqueries" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsCaseExpressions" DisplayName="supportsCaseExpressions" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsSearchedCaseExpressions" DisplayName="supportsSearchedCaseExpressions" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="getSupportedFunctions" DisplayName="getSupportedFunctions" ShortDescription="" PropertyType="string" IsExpert="true" /> + <PropertyDefinition Name="supportsInlineViews" DisplayName="supportsInlineViews" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsSetQueryOrderBy" DisplayName="supportsSetQueryOrderBy" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsUnions" DisplayName="supportsUnions" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsIntersect" DisplayName="supportsIntersect" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsExcept" DisplayName="supportsExcept" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="requiresCriteria" DisplayName="requiresCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="useAnsiJoin" DisplayName="useAnsiJoin" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsBatchedUpdates" DisplayName="supportsBatchedUpdates" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsBulkUpdate" DisplayName="supportsBulkUpdate" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsInsertWithQueryExpression" DisplayName="supportsInsertWithQueryExpression" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsRowLimit" DisplayName="supportsRowLimit" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="supportsRowOffset" DisplayName="supportsRowOffset" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> + </ComponentType> + <ComponentType Name="JDBC Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.952-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.952-06:00"> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:" IsRequired="true" PropertyType="String"/> + <PropertyDefinition Name="User" DisplayName="User Name" ShortDescription="" /> + <PropertyDefinition Name="Password" DisplayName="Password" ShortDescription="" IsMasked="true" /> + <PropertyDefinition Name="ConnectorTypeClassPath" DisplayName="Connector Type Class Path" ShortDescription="Connector Type classpath (defined by system, do not modify)" DefaultValue="extensionjar:connector_patch.jar;extensionjar:connector-jdbc-6.2.0-SNAPSHOT.jar;" IsModifiable="false" /> + <PropertyDefinition Name="UseBindVariables" DisplayName="Use prepared statements and bind variables" ShortDescription="" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="ExtensionCapabilityClass" DisplayName="Extension Capability Class" ShortDescription="" IsExpert="true" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.JDBCConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="DatabaseTimeZone" DisplayName="Database time zone" ShortDescription="Time zone of the database, if different than Integration Server" IsExpert="true" /> + <PropertyDefinition Name="TransactionIsolationLevel" DisplayName="Transaction Isolation Level" ShortDescription="Set the data source transaction isolation level" IsExpert="true" > + <AllowedValue>TRANSACTION_READ_UNCOMMITTED</AllowedValue> + <AllowedValue>TRANSACTION_READ_COMMITTED</AllowedValue> + <AllowedValue>TRANSACTION_SERIALIZABLE</AllowedValue> + <AllowedValue>TRANSACTION_NONE</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.translator.Translator" IsExpert="true" /> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" IsRequired="true" /> + <PropertyDefinition Name="TrimStrings" DisplayName="Trim string flag" ShortDescription="Right Trim fixed character types returned as Strings" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="UseCommentsInSourceQuery" DisplayName="Use informational comments in Source Queries" ShortDescription="This will embed /*comment*/ style comment with session/request id in source SQL query for informational purposes" DefaultValue="false" PropertyType="Boolean" IsExpert="true"/> + </ComponentType> + <ComponentType Name="Oracle Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="oracle.jdbc.driver.OracleDriver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:oracle:thin:@&lt;host&gt;:1521:&lt;sid&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.oracle.OracleSQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + </ComponentType> + <ComponentType Name="Oracle XA Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="oracle.jdbc.xa.client.OracleXADataSource" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:oracle:thin:@&lt;host&gt;:1521:&lt;sid&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.oracle.OracleSQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="DB2 Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.ibm.db2.jcc.DB2Driver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:db2://&lt;server&gt;:50000/&lt;db-name&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.db2.DB2SQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + </ComponentType> + <ComponentType Name="DB2 XA Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.ibm.db2.jcc.DB2XADataSource" IsRequired="true" /> + <PropertyDefinition Name="PortNumber" DisplayName="Port Number" DefaultValue="50000" ShortDescription="" IsRequired="true" PropertyType="Integer" IsMasked="false" /> + <PropertyDefinition Name="ServerName" DisplayName="Server Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="DatabaseName" DisplayName="Database Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="DriverType" DisplayName="Driver Type" ShortDescription="" DefaultValue="4" IsRequired="true" PropertyType="Integer" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.db2.DB2SQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="SQL Server Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.microsoft.sqlserver.jdbc.SQLServerDriver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:sqlserver://&lt;host&gt;:1433;databaseName=&lt;db-name&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.sqlserver.SqlServerSQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + </ComponentType> + <ComponentType Name="SQL Server XA Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.microsoft.sqlserver.jdbc.SQLServerXADataSource" IsRequired="true" /> + <PropertyDefinition Name="PortNumber" DisplayName="Port Number" DefaultValue="1433" ShortDescription="" IsRequired="true" PropertyType="Integer" IsMasked="false" /> + <PropertyDefinition Name="ServerName" DisplayName="Server Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="DatabaseName" DisplayName="Database Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.sqlserver.SqlServerSQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="MySQL JDBC Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.mysql.jdbc.Driver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:mysql://&lt;host&gt;:3306/&lt;databaseName&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.mysql.MySQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + </ComponentType> + <ComponentType Name="MySQL 5 JDBC Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.mysql.jdbc.Driver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:mysql://&lt;host&gt;:3306/&lt;databaseName&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.mysql.MySQL5Translator" PropertyType="String" IsExpert="true" IsMasked="false" /> + </ComponentType> + <ComponentType Name="MySQL JDBC XA Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" IsRequired="true" /> + <PropertyDefinition Name="PortNumber" DisplayName="Port Number" DefaultValue="3306" ShortDescription="" IsRequired="true" PropertyType="Integer" IsMasked="false" /> + <PropertyDefinition Name="ServerName" DisplayName="Server Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="DatabaseName" DisplayName="Database Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.mysql.MySQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="MySQL 5 JDBC XA Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" IsRequired="true" /> + <PropertyDefinition Name="PortNumber" DisplayName="Port Number" DefaultValue="3306" ShortDescription="" IsRequired="true" PropertyType="Integer" IsMasked="false" /> + <PropertyDefinition Name="ServerName" DisplayName="Server Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="DatabaseName" DisplayName="Database Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.mysql.MySQL5Translator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="PostgreSQL JDBC Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="org.postgresql.Driver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:postgresql://&lt;host&gt;:5432/&lt;databaseName&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.postgresql.PostgreSQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="DatabaseVersion" DisplayName="Database Version" ShortDescription="PostgreSQL Version i.e. 8.3" DefaultValue="8.0" PropertyType="String" /> + </ComponentType> + <ComponentType Name="PostgreSQL XA JDBC Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="org.postgresql.xa.PGXADataSource" IsRequired="true" /> + <PropertyDefinition Name="PortNumber" DisplayName="Port Number" DefaultValue="5432" ShortDescription="" IsRequired="true" PropertyType="Integer" IsMasked="false" /> + <PropertyDefinition Name="ServerName" DisplayName="Server Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="DatabaseName" DisplayName="Database Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.postgresql.PostgreSQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + <PropertyDefinition Name="DatabaseVersion" DisplayName="Database Version" ShortDescription="PostgreSQL Version i.e. 8.3" DefaultValue="8.0" PropertyType="String" /> + </ComponentType> + <ComponentType Name="Apache Derby Embedded Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="org.apache.derby.jdbc.EmbeddedDriver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:derby:&lt;databaseName&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.derby.DerbySQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="DatabaseVersion" DisplayName="Database Version" ShortDescription="Derby Version i.e. 10.3" DefaultValue="10.1" PropertyType="String" /> + </ComponentType> + <ComponentType Name="Apache Derby Network Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="org.apache.derby.jdbc.ClientDriver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:derby://localhost:1527/&lt;path/to/db&gt;" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.derby.DerbySQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="DatabaseVersion" DisplayName="Database Version" ShortDescription="Derby Version i.e. 10.3" DefaultValue="10.1" PropertyType="String" /> + </ComponentType> + <ComponentType Name="Apache Derby XA Network Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="org.apache.derby.jdbc.ClientXADataSource" IsRequired="true" /> + <PropertyDefinition Name="PortNumber" DisplayName="Port Number" DefaultValue="1527" ShortDescription="" IsRequired="true" PropertyType="Integer" IsMasked="false" /> + <PropertyDefinition Name="ServerName" DisplayName="Server Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="DatabaseName" DisplayName="Database Name" ShortDescription="" IsRequired="true" PropertyType="String" IsMasked="false" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.derby.DerbySQLTranslator" PropertyType="String" IsExpert="true" IsMasked="false" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="Teiid 6 JDBC Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.metamatrix.jdbc.MMDriver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:metamatrix:&lt;vdbName&gt;@mm://&lt;host&gt;:&lt;port&gt;" IsRequired="true" /> + </ComponentType> + <ComponentType Name="JDBC ODBC Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="sun.jdbc.odbc.JdbcOdbcDriver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:odbc:&lt;data-source-name&gt;[;UID=&lt;xxx&gt; ;PWD=&lt;xxx&gt;]" IsRequired="true" /> + </ComponentType> + <ComponentType Name="MS Access Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" CreatedBy="ConfigurationStartup"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="sun.jdbc.odbc.JdbcOdbcDriver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=&lt;data-source-name&gt;" IsRequired="true" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.access.AccessSQLTranslator" IsExpert="true" /> + </ComponentType> + <ComponentType Name="MS Excel Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2006-02-08T11:02:36.029-06:00" CreatedBy="ConfigurationStartup" CreationDate="2006-02-08T11:02:36.029-06:00"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="sun.jdbc.odbc.JdbcOdbcDriver" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:odbc:Driver={MicroSoft Excel Driver (*.xls)};DBQ=&lt;filePathToExcelFile&gt;" IsRequired="true" /> + </ComponentType> + <!-- + <ComponentType Name="Datadirect DB2 8 Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.928-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.928-06:00"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.metamatrix.jdbcx.db2.DB2DataSource" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:mmx:db2://&lt;host&gt;:50000;DatabaseName=&lt;databasename&gt;;CollectionID=&lt;collectionid&gt;;PackageName=&lt;packagename&gt;" IsRequired="true" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.db2.DB2SQLTranslator" IsExpert="true" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="Datadirect Oracle 9 Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.923-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.923-06:00"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.metamatrix.jdbcx.oracle.OracleDataSource" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:mmx:oracle://&lt;host&gt;:1521;SID=&lt;sid&gt;" IsRequired="true" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.oracle.OracleSQLTranslator" IsExpert="true" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="Datadirect SQL Server 2003 Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.935-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.935-06:00"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.metamatrix.jdbcx.sqlserver.SQLServerDataSource" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:mmx:sqlserver://&lt;host&gt;:1433;DatabaseName=&lt;databasename&gt;" IsRequired="true" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.sqlserver.SqlServerSQLTranslator" IsExpert="true" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + </ComponentType> + <ComponentType Name="Datadirect Sybase 12 Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="JDBC Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.930-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.930-06:00"> + <PropertyDefinition Name="ConnectionSource" DisplayName="Connection Source Class" ShortDescription="Driver, DataSource, or XADataSource class name" DefaultValue="com.metamatrix.jdbcx.sybase.SybaseDataSource" IsRequired="true" /> + <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:mmx:sybase://&lt;host&gt;:5000;DatabaseName=&lt;databasename&gt;" IsRequired="true" /> + <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.sybase.SybaseSQLTranslator" IsExpert="true" /> + <PropertyDefinition Name="IsXA" DisplayName="Is XA" ShortDescription="Is XA" DefaultValue="true" IsRequired="true" PropertyType="Boolean" /> + <PropertyDefinition Name="SetCriteriaBatchSize" DisplayName="Max Values in IN Predicate" ShortDescription="Max number of values in an IN Predicate. Must be &gt;= 0." DefaultValue="250" PropertyType="Integer" IsExpert="true" /> + </ComponentType> + --> <ComponentType Name="LDAP Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.946-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.946-06:00"> + <PropertyDefinition Name="ConnectorTypeClassPath" DisplayName="Connector Type Class Path" ShortDescription="Connector Type classpath (defined by system, do not modify)" DefaultValue="extensionjar:connector_patch.jar;extensionjar:connector-ldap-6.2.0-SNAPSHOT.jar;" IsModifiable="false" /> + <PropertyDefinition Name="SearchDefaultBaseDN" DisplayName="Default Search Base DN" ShortDescription="Default Base DN for LDAP Searches" IsExpert="true" /> + <PropertyDefinition Name="LdapAdminUserDN" DisplayName="Ldap Admin User DN" ShortDescription="User DN for the LDAP admin account." DefaultValue="cn=&lt;&gt;,ou=&lt;&gt;,dc=&lt;&gt;" IsRequired="true" /> + <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.ldap.LDAPConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="LdapAdminUserPassword" DisplayName="Ldap Admin Password" ShortDescription="Password of the LDAP admin user account." IsRequired="true" IsMasked="true" /> + <PropertyDefinition Name="SearchDefaultScope" DisplayName="Default Search Scope" ShortDescription="Default Scope for LDAP Searches" DefaultValue="SUBTREE_SCOPE" IsRequired="true"> + <AllowedValue>OBJECT_SCOPE</AllowedValue> + <AllowedValue>ONELEVEL_SCOPE</AllowedValue> + <AllowedValue>SUBTREE_SCOPE</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="RestrictToObjectClass" DisplayName="Restrict Searches To Named Object Class" ShortDescription="Restrict Searches to objectClass named in the Name field for a table" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="LdapTxnTimeoutInMillis" DisplayName="Ldap Transaction Timeout (ms)" ShortDescription="Timeout value for LDAP searches. Defaults to TCP timeout value." /> + <PropertyDefinition Name="LdapUrl" DisplayName="Ldap URL" ShortDescription="Ldap URL of the server, including port number." DefaultValue="ldap://&lt;ldapServer&gt;:&lt;389&gt;" IsRequired="true" /> + </ComponentType> + <ComponentType Name="Loopback Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.945-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.945-06:00"> + <PropertyDefinition Name="ConnectorTypeClassPath" DisplayName="Connector Type Class Path" ShortDescription="Connector Type classpath (defined by system, do not modify)" DefaultValue="extensionjar:connector_patch.jar;extensionjar:connector-loopback-6.2.0-SNAPSHOT.jar;" IsModifiable="false" /> + <PropertyDefinition Name="CapabilitiesClass" DisplayName="Capabilities Class" ShortDescription="" DefaultValue="com.metamatrix.connector.loopback.LoopbackCapabilities" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="WaitTime" DisplayName="Max Random Wait Time" ShortDescription="" DefaultValue="0" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.loopback.LoopbackConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="RowCount" DisplayName="Rows Per Query" ShortDescription="" DefaultValue="1" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + </ComponentType> + <ComponentType Name="Salesforce Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="Connector" ParentComponentType="Connectors" LastChangedDate="2008-10-31T10:26:19.916-06:00" CreationDate="2008-10-31T10:26:19.916-06:00"> + <PropertyDefinition Name="ConnectorTypeClassPath" DisplayName="Connector Type Class Path" ShortDescription="Connector Type classpath (defined by system, do not modify)" DefaultValue="extensionjar:connector_patch.jar;extensionjar:connector-salesforce-6.2.0-SNAPSHOT.jar;extensionjar:commons-codec-1.2.jar;extensionjar:commons-discovery-0.2.jar;extensionjar:commons-httpclient-3.0.1.jar;extensionjar:xmlsec-1.3.0.jar;extensionjar:axis-1.3.jar;extensionjar:axis-jaxrpc-1.3.jar;extensionjar:axis-saaj-1.2.jar;extensionjar:axis-schema-1.3.jar;extensionjar:commons-discovery-0.2.jar;extensionjar:jms-1.1.jar;extensionjar:jaxen-1.1.1.jar;extensionjar:nux-1.6.jar;extensionjar:opensaml-1.1b.jar;extensionjar:salesforce-api-6.2.0-SNAPSHOT.jar;extensionjar:jetty-6.1.9.jar;extensionjar:jetty-util-6.1.9.jar;extensionjar:servlet-api-2.5-6.1.9.jar;extensionjar:wsdl4j-1.5.1.jar;extensionjar:wss4j-1.5.0.jar;extensionjar:xalan-2.7.0.jar;extensionjar:xom-1.2.jar" IsModifiable="false" /> + <PropertyDefinition Name="UsePostDelegation" DisplayName="Use Separate Classloader" ShortDescription="Set to true to indicate that the connector classpath and connector type classpath entries should be loaded by a connector specific post-delegation class loader." PropertyType="Boolean" IsRequired="true" IsExpert="true" DefaultValue="true"/> + <PropertyDefinition Name="username" DisplayName="User Name" ShortDescription="Name value for Salesforce authentication" DefaultValue="" IsRequired="true" /> + <PropertyDefinition Name="ConnectorStateClass" DisplayName="Connector State Class" ShortDescription="" DefaultValue="com.metamatrix.connector.salesforce.ConnectorState" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.salesforce.Connector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="password" DisplayName="Password" ShortDescription="Password value for Salesforce authentication" DefaultValue="" IsRequired="true" IsMasked="true" /> + <PropertyDefinition Name="URL" DisplayName="Salesforce URL" ShortDescription="URL for connecting to Salesforce" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="ConnectorCapabilities" DisplayName="Connector Capabilities Class" ShortDescription="The class to use to provide the Connector Capabilities" DefaultValue="com.metamatrix.connector.salesforce.SalesforceCapabilities" IsExpert="true" /> + </ComponentType> + <ComponentType Name="Text File Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.945-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.945-06:00"> + <PropertyDefinition Name="ConnectorTypeClassPath" DisplayName="Connector Type Class Path" ShortDescription="Connector Type classpath (defined by system, do not modify)" DefaultValue="extensionjar:connector_patch.jar;extensionjar:connector-text-6.2.0-SNAPSHOT.jar;" IsModifiable="false" /> + <PropertyDefinition Name="PartialStartupAllowed" DisplayName="Partial Startup Allowed" ShortDescription="" DefaultValue="true" IsRequired="true" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="DescriptorFile" DisplayName="Text File Descriptor" ShortDescription="" IsRequired="true" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.text.TextConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="EnforceColumnCount" DisplayName="Enforce Column Count" ShortDescription="This forces the number of columns in text file to match what was modeled" DefaultValue="false" PropertyType="Boolean" /> + <PropertyDefinition Name="DateResultFormatsDelimiter" DisplayName="Date Result Formats Delimiter" ShortDescription="" IsExpert="true" /> + <PropertyDefinition Name="DateResultFormats" DisplayName="Date Result Formats" ShortDescription="" IsExpert="true" /> + <PropertyDefinition Name="Immutable" DisplayName="Is Immutable" ShortDescription="True if the source never changes." DefaultValue="true" IsRequired="true" PropertyType="Boolean" IsExpert="true" /> + </ComponentType> + <ComponentType Name="XML Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="Connector" ParentComponentType="Connectors" LastChangedDate="2008-10-31T10:26:19.917-06:00" CreationDate="2008-10-31T10:26:19.917-06:00"> + <PropertyDefinition Name="ConnectorTypeClassPath" DisplayName="Connector Type Class Path" ShortDescription="Connector Type classpath (defined by system, do not modify)" DefaultValue="extensionjar:connector_patch.jar;extensionjar:connector-xml-6.2.0-SNAPSHOT.jar;extensionjar:commons-codec-1.2.jar;extensionjar:commons-discovery-0.2.jar;extensionjar:commons-httpclient-3.0.1.jar;extensionjar:xmlsec-1.3.0.jar;extensionjar:axis-1.3.jar;extensionjar:axis-jaxrpc-1.3.jar;extensionjar:axis-saaj-1.2.jar;extensionjar:axis-schema-1.3.jar;extensionjar:commons-discovery-0.2.jar;extensionjar:jms-1.1.jar;extensionjar:jaxen-1.1.1.jar;extensionjar:nux-1.6.jar;extensionjar:opensaml-1.1b.jar;extensionjar:jetty-6.1.9.jar;extensionjar:jetty-util-6.1.9.jar;extensionjar:servlet-api-2.5-6.1.9.jar;extensionjar:wsdl4j-1.5.1.jar;extensionjar:wss4j-1.5.0.jar;extensionjar:xalan-2.7.0.jar;extensionjar:xom-1.2.jar" IsModifiable="false"/> + <PropertyDefinition Name="UsePostDelegation" DisplayName="Use Separate Classloader" ShortDescription="Set to true to indicate that the connector classpath and connector type classpath entries should be loaded by a connector specific post-delegation class loader." PropertyType="Boolean" IsRequired="true" IsExpert="true" DefaultValue="true"/> + </ComponentType> + + <ComponentType Name="XML File Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="XML Connector" ParentComponentType="Connectors" LastChangedDate="2008-10-31T10:26:19.917-06:00" CreationDate="2008-10-31T10:26:19.917-06:00"> + <PropertyDefinition Name="CharacterEncodingScheme" DisplayName="File Encoding Used" ShortDescription="A character-encoding scheme is a mapping between a coded character set and a set of octet (eight-bit byte) sequences. Some samples are UTF-8,ISO-8859-1,UTF-16)" DefaultValue="ISO-8859-1" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.xmlsource.XMLSourceConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="ConnectionType" DisplayName="Type Of XML Connection" ShortDescription="Connection type used to get the XML data" DefaultValue="com.metamatrix.connector.xmlsource.file.FileConnection" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="DirectoryLocation" DisplayName="XML File(s) Directory Location" ShortDescription="" DefaultValue="" IsRequired="true" /> + </ComponentType> + <ComponentType Name="XML SOAP Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="XML Connector" ParentComponentType="Connectors" LastChangedDate="2008-10-31T10:26:19.917-06:00" CreationDate="2008-10-31T10:26:19.917-06:00"> + <PropertyDefinition Name="AuthPassword" DisplayName="Authentication User Password" ShortDescription="Password value for authentication" DefaultValue="" IsExpert="true" IsMasked="true" /> + <PropertyDefinition Name="SAMLPropertyFile" DisplayName="SAML Property File (only required when SAML profile used)" ShortDescription="SAML Security property file (saml.properties)" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="wsdl" DisplayName="WSDL File (URL)" ShortDescription="URL to Web Service Definition File" DefaultValue="" IsRequired="true" /> + <PropertyDefinition Name="AuthUserName" DisplayName="Authentication User Name" ShortDescription="Name value for authentication" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="WSSecurityType" DisplayName="WS-Security Type(UsernameToken, SAML..)" ShortDescription="Type of WS-Security to be used; Combinations of multiple security types can be used with a space in-between. Allowed types are: (UsernameToken, UsernameToken-Digest, SAMLTokenUnsigned, SAMLTokenSigned, Signature, Timestamp, Encrypt)" DefaultValue="" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.xmlsource.XMLSourceConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="EncryptUserName" DisplayName="Encrypt UserName (only if Encrypt profile used)" ShortDescription="The username to be used in the encryption; if blank uses auth username" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="EndPoint" DisplayName="Alternate End Point" ShortDescription="An alternate service endpoint other than one specified in WSDL, to execute the service" DefaultValue="" /> + <PropertyDefinition Name="SecurityType" DisplayName="WebService Security Used(None, HTTPBasic, WS-Security)" ShortDescription="Type of Authentication to used with the web service; If WS-Secuirty is being used, then WS-Secuirty type must be defined" DefaultValue="None" IsRequired="true" /> + <PropertyDefinition Name="CryptoPropertyFile" DisplayName="User Crypto Property File (If SAML or Signature profile used)" ShortDescription="The file defines properties of cryptography;defines the certificates;(crypto.properties)" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="ConnectionType" DisplayName="Type Of XML Connection" ShortDescription="Connection type used to get the XML data" DefaultValue="com.metamatrix.connector.xmlsource.soap.SoapConnection" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="EncryptPropertyFile" DisplayName="Encrypt crypto property file (only if Encrypt profile used)" ShortDescription="The file defines properties of cryptography for encryption of the message;(crypto.properties)" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="TrustType" DisplayName="Trust Type:(DirectReference or IssuerSerial)" ShortDescription="Only required for Signature and Signed SAML; The issuer-serial method presumes that all trusted users of the service are known to the service and have pre-registered their certificate chains before using the service. The direct-reference method presumes that the service operator trusts all users with certificates issued by a trusted CA." DefaultValue="DirectReference" IsExpert="true" /> + </ComponentType> + <ComponentType Name="XML-Relational File Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="XML Connector" ParentComponentType="Connectors" LastChangedDate="2008-10-31T10:26:19.918-06:00" CreationDate="2008-10-31T10:26:19.918-06:00"> + <PropertyDefinition Name="FilePath" DisplayName="File Path" ShortDescription="" IsRequired="true" /> + <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="CacheEnabled" DisplayName="Enable Document Caching" ShortDescription="" DefaultValue="false" IsRequired="true" PropertyType="Boolean" /> + <PropertyDefinition Name="SaxFilterProviderClass" DisplayName="XML Filter Provider" ShortDescription="The class the provides extended XML Filters" DefaultValue="com.metamatrix.connector.xml.base.NoExtendedFilters" IsExpert="true" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.xml.base.XMLConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="ConnectorStateClass" DisplayName="Connector State Class" ShortDescription="" DefaultValue="com.metamatrix.connector.xml.file.FileConnectorState" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="LogRequestResponseDocs" DisplayName="Log XML Request and Response Documents" ShortDescription="Write the request and response documents to the log at Info level" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="InputStreamFilterClass" DisplayName="Input Stream Filter Class" ShortDescription="The class to use to preprocess raw XML input stream" DefaultValue="com.metamatrix.connector.xml.base.PluggableInputStreamFilterImpl" IsExpert="true" /> + <PropertyDefinition Name="FileName" DisplayName="File Name" ShortDescription="" DefaultValue="" /> + <PropertyDefinition Name="QueryPreprocessorClass" DisplayName="Query Preprocessor Class" ShortDescription="The class to use to preprocess the IQuery" DefaultValue="com.metamatrix.connector.xml.base.NoQueryPreprocessing" IsExpert="true" /> + <PropertyDefinition Name="ConnectorCapabilities" DisplayName="Connector Capabilities Class" ShortDescription="The class to use to provide the Connector Capabilities" DefaultValue="com.metamatrix.connector.xml.base.XMLCapabilities" IsExpert="true" /> + </ComponentType> + <ComponentType Name="XML-Relational HTTP Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="XML Connector" ParentComponentType="Connectors" LastChangedDate="2008-10-31T10:26:19.920-06:00" CreationDate="2008-10-31T10:26:19.921-06:00"> + <PropertyDefinition Name="SaxFilterProviderClass" DisplayName="XML Filter Provider" ShortDescription="The class the provides extended XML Filters" DefaultValue="com.metamatrix.connector.xml.base.NoExtendedFilters" IsExpert="true" /> + <PropertyDefinition Name="XMLParmName" DisplayName="XML Parameter Name" ShortDescription="" /> + <PropertyDefinition Name="RequestTimeout" DisplayName="Request Timeout (in Milliseconds)" ShortDescription="" DefaultValue="10000" IsRequired="true" PropertyType="Integer" /> + <PropertyDefinition Name="Authenticate" DisplayName="Authentication Required" ShortDescription="" DefaultValue="false" PropertyType="Boolean" IsModifiable="true" /> + <PropertyDefinition Name="ConnectorStateClass" DisplayName="Connector State Class" ShortDescription="" DefaultValue="com.metamatrix.connector.xml.http.HTTPConnectorState" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="HttpBasicAuthPassword" DisplayName="HTTP Basic Authentication Password" ShortDescription="Password value for HTTP basic authentication" DefaultValue="" IsExpert="true" IsMasked="true" /> + <PropertyDefinition Name="AccessMethod" DisplayName="Access Method" ShortDescription="" DefaultValue="get" IsRequired="true"> + <AllowedValue>get</AllowedValue> + <AllowedValue>post</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="ProxyUri" DisplayName="Proxy Server URI" ShortDescription="The URI of the proxy server" DefaultValue="" /> + <PropertyDefinition Name="ConnectorCapabilities" DisplayName="Connector Capabilities Class" ShortDescription="The class to use to provide the Connector Capabilities" DefaultValue="com.metamatrix.connector.xml.base.XMLCapabilities" IsExpert="true" /> + <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="HttpBasicAuthUserName" DisplayName="HTTP Basic Authentication Name" ShortDescription="Name value for HTTP basic authentication" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.xml.base.XMLConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="Uri" DisplayName="Server URI" ShortDescription="The URI of the HTTP source" IsRequired="true" /> + <PropertyDefinition Name="UseHttpBasic" DisplayName="Use HTTP Basic authentication" ShortDescription="Use basic HTTP Authentication" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="LogRequestResponseDocs" DisplayName="Log XML Request and Response Documents" ShortDescription="Write the request and response documents to the log at Info level" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="TrustDeserializerClass" DisplayName="Trust Deserializer Class" ShortDescription="The class to use to process trusted payloads and execution payloads" DefaultValue="com.metamatrix.connector.xml.http.DefaultTrustDeserializer" IsExpert="true" /> + <PropertyDefinition Name="ParameterMethod" DisplayName="Parameter Method" ShortDescription="" DefaultValue="None" IsRequired="true"> + <AllowedValue>None</AllowedValue> + <AllowedValue>Name/Value</AllowedValue> + <AllowedValue>XMLRequest</AllowedValue> + <AllowedValue>XMLInQueryString</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="InputStreamFilterClass" DisplayName="Input Stream Filter Class" ShortDescription="The class to use to preprocess raw XML input stream" DefaultValue="com.metamatrix.connector.xml.base.PluggableInputStreamFilterImpl" IsExpert="true" /> + <PropertyDefinition Name="HostnameVerifier" DisplayName="Hostname Verifier" ShortDescription="Class implementing javax.net.ssl.HostnameVerifier. Used to implement a hostname mismatch workaround." IsExpert="true" /> + <PropertyDefinition Name="QueryPreprocessorClass" DisplayName="Query Preprocessor Class" ShortDescription="The class to use to preprocess the IQuery" DefaultValue="com.metamatrix.connector.xml.base.NoQueryPreprocessing" IsExpert="true" /> + </ComponentType> + <ComponentType Name="XML-Relational SOAP Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="XML Connector" ParentComponentType="Connectors" LastChangedDate="2008-10-31T10:26:19.919-06:00" CreationDate="2008-10-31T10:26:19.919-06:00"> + <PropertyDefinition Name="AuthPassword" DisplayName="Authentication User Password" ShortDescription="Password value for authentication" DefaultValue="" IsExpert="true" IsMasked="true" /> + <PropertyDefinition Name="SaxFilterProviderClass" DisplayName="XML Filter Provider" ShortDescription="The class the provides extended XML Filters" DefaultValue="com.metamatrix.connector.xml.base.NoExtendedFilters" IsExpert="true" /> + <PropertyDefinition Name="AuthUserName" DisplayName="Authentication User Name" ShortDescription="Name value for authentication" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="WSSecurityType" DisplayName="WS-Security Type(UsernameToken, SAML..)" ShortDescription="Type of WS-Security to be used; Combinations of multiple security types can be used with a space in-between. Allowed types are: (UsernameToken, UsernameToken-Digest, SAMLTokenUnsigned, SAMLTokenSigned, Signature, Timestamp, Encrypt)" DefaultValue="" /> + <PropertyDefinition Name="XMLParmName" DisplayName="XML Parameter Name" ShortDescription="" DefaultValue="" IsModifiable="false" /> + <PropertyDefinition Name="EncryptUserName" DisplayName="Encrypt UserName (only if Encrypt profile used)" ShortDescription="The username to be used in the encryption; if blank uses auth username" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="ExceptionOnSOAPFault" DisplayName="Exception on SOAP Fault" ShortDescription="Throw connector exception when SOAP fault is returned from source." DefaultValue="true" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="RequestTimeout" DisplayName="Request Timeout (in Milliseconds)" ShortDescription="" DefaultValue="10000" IsRequired="true" PropertyType="Integer" /> + <PropertyDefinition Name="CryptoPropertyFile" DisplayName="User Crypto Property File (If SAML or Signature profile used)" ShortDescription="The file defines properties of cryptography;defines the certificates;(crypto.properties)" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="ConnectorStateClass" DisplayName="Connector State Class" ShortDescription="" DefaultValue="com.metamatrix.connector.xml.soap.SOAPConnectorState" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="SOAPAction" DisplayName="SOAP-Action" ShortDescription="Value for SOAP-Action header" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="AccessMethod" DisplayName="Access Method (Get, Post)" ShortDescription="" DefaultValue="post" IsModifiable="false"> + <AllowedValue>get</AllowedValue> + <AllowedValue>post</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="ProxyUri" DisplayName="Proxy Server URI" ShortDescription="The URI of the proxy server" DefaultValue="" /> + <PropertyDefinition Name="EncryptPropertyFile" DisplayName="Encrypt crypto property file (only if Encrypt profile used)" ShortDescription="The file defines properties of cryptography for encryption of the message;(crypto.properties)" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="ConnectorCapabilities" DisplayName="Connector Capabilities Class" ShortDescription="The class to use to provide the Connector Capabilities" DefaultValue="com.metamatrix.connector.xml.base.XMLCapabilities" IsExpert="true" /> + <PropertyDefinition Name="SAMLPropertyFile" DisplayName="SAML Property File (only required when SAML profile used)" ShortDescription="SAML Security property file (saml.properties)" DefaultValue="" IsExpert="true" /> + <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> + <PropertyDefinition Name="EncodingStyle" DisplayName="Encoding Style (RPC - Encoded, RPC - Literal, Document - Literal, Document - Encoded)" ShortDescription="Encoding Style" DefaultValue="Document - Literal" IsRequired="true"> + <AllowedValue>RPC - Encoded</AllowedValue> + <AllowedValue>RPC - Literal</AllowedValue> + <AllowedValue>Document - Literal</AllowedValue> + <AllowedValue>Document - Encoded</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.xml.base.XMLConnector" IsRequired="true" IsExpert="true" /> + <PropertyDefinition Name="Uri" DisplayName="Server URI" ShortDescription="The URI of the HTTP source" IsRequired="true" /> + <PropertyDefinition Name="SecurityType" DisplayName="WebService Security Used(None, HTTPBasic, WS-Security)" ShortDescription="Type of Authentication to used with the web service; If WS-Secuirty is being used, then WS-Secuirty type must be defined" DefaultValue="None" IsRequired="true" /> + <PropertyDefinition Name="LogRequestResponseDocs" DisplayName="Log XML Request and Response Documents" ShortDescription="Write the request and response documents to the log at Info level" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> + <PropertyDefinition Name="TrustDeserializerClass" DisplayName="Trust Deserializer Class" ShortDescription="The class to use to process trusted payloads and execution payloads" DefaultValue="com.metamatrix.connector.xml.soap.DefaultSoapTrustDeserializer" IsExpert="true" /> + <PropertyDefinition Name="ParameterMethod" DisplayName="Parameter Method (None, Name/Value, XMLRequest, XMLInQueryString)" ShortDescription="" DefaultValue="XMLRequest" IsModifiable="false"> + <AllowedValue>None</AllowedValue> + <AllowedValue>Name/Value</AllowedValue> + <AllowedValue>XMLRequest</AllowedValue> + <AllowedValue>XMLInQueryString</AllowedValue> + </PropertyDefinition> + <PropertyDefinition Name="InputStreamFilterClass" DisplayName="Input Stream Filter Class" ShortDescription="The class to use to preprocess raw XML input stream" DefaultValue="com.metamatrix.connector.xml.base.PluggableInputStreamFilterImpl" IsExpert="true" /> + <PropertyDefinition Name="HostnameVerifier" DisplayName="Hostname Verifier" ShortDescription="a class implmenting javax.net.ssl.HostnameVerifier. Used to implement a hostname mismatch workaround." IsExpert="true" /> + <PropertyDefinition Name="TrustType" DisplayName="Trust Type:(DirectReference or IssuerSerial)" ShortDescription="Only required for Signature and Signed SAML; The issuer-serial method presumes that all trusted users of the service are known to the service and have pre-registered their certificate chains before using the service. The direct-reference method presumes that the service operator trusts all users with certificates issued by a trusted CA." DefaultValue="DirectReference" IsExpert="true" /> + <PropertyDefinition Name="QueryPreprocessorClass" DisplayName="Query Preprocessor Class" ShortDescription="The class to use to preprocess the IQuery" DefaultValue="com.metamatrix.connector.xml.base.NoQueryPreprocessing" IsExpert="true" /> + </ComponentType> + + </ComponentTypes> +</ConfigurationDocument> \ No newline at end of file Property changes on: trunk/test-integration/db/src/main/resources/configuration.xml ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/datasources/datasource_mapping.xml =================================================================== --- trunk/test-integration/db/src/main/resources/datasources/datasource_mapping.xml (rev 0) +++ trunk/test-integration/db/src/main/resources/datasources/datasource_mapping.xml 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,77 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- ====================================================================== + Aug 26, 2009 9:05:03 AM + + description: This datasource configuration file is used to define the + different datasources that "may be" used during test execution. + I say may be used, because these are all the types that are supported + by Teiid, but only if the defined "dir" exist under the "datasources" + directory that contains a connection.properties file will it actually be used. + + The organization of the datasources splits them between groups XA and Non-XA + related transactional types so that when a test is run the process will obtain + a connection from a datasoure defined for that group. + + To use a datasource(s) in a test, map the model(s) to a datasource indicated here. + The mapping is done in the configuration properties file (see default-config.properties). + + This configuration specifies the following information: + - It indicates the location ("dir") to find the datasource connection + information that is used to populate the connector bindings and create + direct connections to the source + - It provides a mapping to the Connector Type that needs + to be specified when deploying the ConnectorBinding and assigning it to + the mapped model (see default.config.properties) + + NOTE: the name of datasource must be unique across all datasources in the file + + vanhalbert + ====================================================================== --> + +<datasourceconfig> + <datasourcetype name="nonxa"> + <datasource name="ds_mysql"> + <property name="dir">mysql</property> + <property name="connectortype">MySQL JDBC Connector</property> + </datasource> + <datasource name="ds_oracle"> + <property name="dir">oracle</property> + <property name="connectortype">Oracle Connector</property> + </datasource> + <datasource name="ds_db2"> + <property name="dir">db2</property> + <property name="connectortype">DB2 Connector</property> + </datasource> + <datasource name="ds_postgres"> + <property name="dir">postgres</property> + <property name="connectortype">PostgreSQL JDBC Connector</property> + </datasource> + + <datasource name="ds_derby"> + <property name="dir">derby</property> + <property name="connectortype">Apache Derby Network Connector</property> + </datasource> + + </datasourcetype> + + <datasourcetype name="xa"> + <datasource name="ds_mysql_xa"> + <property name="dir">mysql</property> + <property name="connectortype">MySQL JDBC XA Connector</property> + </datasource> + <datasource name="ds_oracle_xa"> + <property name="dir">oracle</property> + <property name="connectortype">Oracle XA Connector</property> + </datasource> + <datasource name="ds_db2_xa"> + <property name="dir">db2</property> + <property name="connectortype">DB2 XA Connector</property> + </datasource> + <datasource name="ds_postgres_xa"> + <property name="dir">postgres</property> + <property name="connectortype">PostgreSQL XA JDBC Connector</property> + </datasource> + + </datasourcetype> + +</datasourceconfig> \ No newline at end of file Property changes on: trunk/test-integration/db/src/main/resources/datasources/datasource_mapping.xml ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/datasources/derby/example_connection.properties =================================================================== --- trunk/test-integration/db/src/main/resources/datasources/derby/example_connection.properties (rev 0) +++ trunk/test-integration/db/src/main/resources/datasources/derby/example_connection.properties 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,17 @@ +db.type=derby +driver=org.apache.derby.jdbc.ClientDriver +URL=jdbc:derby://localhost:1527//(derby location) +User= +Password= + +servername=localhost +databasename= +portnumber=1527 +ds-jndiname=localhost_1527 + +Immutable=true + + + + + Property changes on: trunk/test-integration/db/src/main/resources/datasources/derby/example_connection.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/datasources/readme.txt =================================================================== --- trunk/test-integration/db/src/main/resources/datasources/readme.txt (rev 0) +++ trunk/test-integration/db/src/main/resources/datasources/readme.txt 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,9 @@ +the datasources directory is the location to define each database schema that can be used during the running of the tests +a datasource here is defined as a unique connection to a specific schema + +To setup a datasource, do the following: + +1. open datasource_mapping.xml to see the name of the directory ("dir") name to use associated the type of datasource +1. create the directory, if it doesn't exist +2. create (or place) a connection.properties file in the newly created directory +3. \ No newline at end of file Property changes on: trunk/test-integration/db/src/main/resources/datasources/readme.txt ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/ddl/adminparms.txt =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/adminparms.txt (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/adminparms.txt 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,57 @@ +sa +-- DB2 parms + (databasename) + (username) + - On DB2, remember an OS user must be created first with the same name as the db2user + + +-- oracle parms +(username) +(password) + +-- mysql +(username) +(password) + +-- postgres +(username) +(password) + +-- sqlserver +(username) +(password) +-- On sql server, CHECK AND CHANGE THE PATH OF THE DATAFILES TO WHAT YOUR DB IS SETUP WITH + + +SQLSERVER +slntdb02 2000 (8.00.859) Repositories sa mmsa +slntds05 2000 (8.00.859) Data Source sa mmsa +slntdb07 2005 (9.00.1399.06) Repositories sa metamatrix +ENGNTDBS14 2008 sa metamatrix + +ORACLE +slntdb03, SID=DB03 9i (9.2.0.4.0) Repositories system mmsystem +slntdb08, SID=DB08 10g (10.1.0.2.0) Repositories system mmsystem +slntds04, SID=DS04 9i (9.2.0.1.0) Data Source system mmsystem +slntds08, SID=DS08 10g (10.1.0.2.0) Data Source system mmsystem +dbo3 machine administrator quad +ds04 administrator jboss42 +englxdbs11 11 sys mm system mm + +DB2 +slntds05, DATABASE=DS05 8.1.11.973(Previously 8.1.8.762) Data Source db2admin mm +ENGNTDBS12 db2admin mm + +SYBASE +slntds17 12.5.1 Data Source sa metamatrix + +MYSQL +slntds03 4.1.14 Data Source root mmroot +slwxp174 5 root mmroot + +POSTGRESQL +slntds04 8.3 both metamatrix +slntds11 8.1.2 Data Source postgres metamatrix + + +* For Oracle system will do to create users, but for admin work I use sys/mmsys as SYSDBA login Property changes on: trunk/test-integration/db/src/main/resources/ddl/adminparms.txt ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/ddl/db2/create_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/db2/create_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/db2/create_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,13 @@ + +-- these tables are used by custom junit test for testing transactions + +create Table g1 ( + e1 NUMERIC(5), + e2 varchar(50), + PRIMARY KEY (e1) +); +create Table g2 ( + e1 NUMERIC(5) REFERENCES g1 (e1), + e2 varchar(50) +); + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/db2/drop_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/db2/drop_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/db2/drop_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,7 @@ + +-- drop the tables + +drop Table g2; +drop Table g1; + + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/db2/exec_parms.properties =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/db2/exec_parms.properties (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/db2/exec_parms.properties 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,3 @@ +delim=% +delimtype=normal +rdbms.type=db2 Property changes on: trunk/test-integration/db/src/main/resources/ddl/db2/exec_parms.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/ddl/derby/create_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/derby/create_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/derby/create_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,13 @@ + +-- these tables are used by custom junit test for testing transactions + +create Table g1 ( + e1 NUMERIC(5), + e2 varchar(50), + PRIMARY KEY (e1) +); +create Table g2 ( + e1 NUMERIC(5) REFERENCES g1 (e1), + e2 varchar(50) +); + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/derby/drop_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/derby/drop_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/derby/drop_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,7 @@ + +-- drop the tables + +drop Table g2; +drop Table g1; + + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/derby/exec_parms.properties =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/derby/exec_parms.properties (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/derby/exec_parms.properties 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,3 @@ +delim=; +delimtype=normal +rdbms.type=derby Property changes on: trunk/test-integration/db/src/main/resources/ddl/derby/exec_parms.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/ddl/exec_parms.properties_template =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/exec_parms.properties_template (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/exec_parms.properties_template 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,10 @@ +# These properties are used in the execution of the sql statements +# using the SQL Ant tasks. + +# Each database type in the "ddl" directory must have an exec_parms.properties file. + +# For property setting options, see the Sql ant task page at @ http://ant.apache.org/manual/index.html + +delim=; +delimtype=normal +rdbms.type=oracle Added: trunk/test-integration/db/src/main/resources/ddl/manage_schemas.xml =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/manage_schemas.xml (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/manage_schemas.xml 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,68 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project name="create_schemas" default="manage.schemas" basedir="../../"> + <property name="resources.dir" value="${basedir}/${relative.resources.dir}"></property> + + <property name="target.dir" value="${basedir}/target"></property> + + <!-- + This script triggers the running of the process for creating schemas + --> + + + <target name="manage.schemas" depends="check, init, manage.all.schemas, manage.single.schemas"> + <echo>Ran create schemas</echo> + + </target> + + + <target name="check"> + <echo>Running for USERNAME = ${User}</echo> + <echo>Perform check</echo> + <condition property="all"> + <not> + <isset property="single"/> + </not> + </condition> + + </target> + + <target name="init"> + <mkdir dir="${target.dir}"/> + </target> + + <target name="manage.all.schemas" if="all"> + <echo>Creating all schemas from datasource dir ${resources.dir}</echo> + <!-- + This will process each directory located under the refid location. + Its expects the following: + - each directory represents one datasource. + - connection.properties file must exist in the directory to be used + --> + <subant genericantfile="${resources.dir}/ddl/run_ddl.xml" inheritall="true" > + <dirset dir="${resources.dir}/datasources/" /> + <property name="sql.ddl.dir" value="${resources.dir}/ddl"/> + + </subant> + + <echo>Completed creating all schemas</echo> + </target> + + + <target name="manage.single.schemas" if="single"> + <echo>Creating single schema ${single}</echo> + + <available file="${resources.dir}/datasources/${single}" property="dir.exist"/> + <fail unless="dir.exist" message="The datasource single was not found at ${resources.dir}/datasources/${single}" /> + + + <ant inheritAll="true" antfile="${resources.dir}/ddl/run_ddl.xml"> + <property name="basedir" value="${resources.dir}/datasources/${single}"/> + <property name="sql.ddl.dir" value="${resources.dir}/ddl"/> + + </ant> + + <echo>Completed creating single schema ${single}</echo> + + </target> + +</project> \ No newline at end of file Property changes on: trunk/test-integration/db/src/main/resources/ddl/manage_schemas.xml ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,6 @@ + +-- these tables are used by custom junit test for testing transactions + +create Table g1 (e1 NUMERIC(5) PRIMARY KEY, e2 varchar(50)); +create Table g2 (e1 NUMERIC(5) REFERENCES g1 (e1), e2 varchar(50)); + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/mysql/drop_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/mysql/drop_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/mysql/drop_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,7 @@ + +-- drop the tables + +drop Table g2; +drop Table g1; + + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/mysql/exec_parms.properties =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/mysql/exec_parms.properties (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/mysql/exec_parms.properties 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,3 @@ +delim=; +delimtype=normal +rdbms.type=mysql Property changes on: trunk/test-integration/db/src/main/resources/ddl/mysql/exec_parms.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/ddl/oracle/create_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/oracle/create_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/oracle/create_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,6 @@ + +-- these tables are used by custom junit test for testing transactions + +create Table g1 (e1 number(5) PRIMARY KEY, e2 varchar2(50)); +create Table g2 (e1 number(5) REFERENCES g1, e2 varchar2(50)); + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/oracle/drop_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/oracle/drop_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/oracle/drop_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,7 @@ + +-- drop the tables + +drop Table g2; +drop Table g1; + + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/oracle/exec_parms.properties =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/oracle/exec_parms.properties (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/oracle/exec_parms.properties 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,3 @@ +delim=; +delimtype=normal +rdbms.type=oracle Property changes on: trunk/test-integration/db/src/main/resources/ddl/oracle/exec_parms.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/ddl/postgres/create_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/postgres/create_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/postgres/create_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,13 @@ + +-- these tables are used by custom junit test for testing transactions + +create Table g1 ( + e1 NUMERIC(5), + e2 VARCHAR(50), + PRIMARY KEY (e1) +); +create Table g2 ( + e1 NUMERIC(5) REFERENCES g1 (e1), + e2 VARCHAR(50) +); + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/postgres/drop_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/postgres/drop_tables.sql (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/postgres/drop_tables.sql 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,6 @@ + +-- drop the tables + +drop Table g2; +drop Table g1; + \ No newline at end of file Added: trunk/test-integration/db/src/main/resources/ddl/postgres/exec_parms.properties =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/postgres/exec_parms.properties (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/postgres/exec_parms.properties 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,3 @@ +delim=; +delimtype=normal +rdbms.type=postgres Property changes on: trunk/test-integration/db/src/main/resources/ddl/postgres/exec_parms.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/ddl/run_ddl.xml =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/run_ddl.xml (rev 0) +++ trunk/test-integration/db/src/main/resources/ddl/run_ddl.xml 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,287 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project name="run_ddl" default="run.ddl" basedir="."> + + + <!-- + + NOTES: + 1. sql.scripts.dir variable must be set to the root directory where the sql script directories are found + 2. rdbms.type value must match the folder name (ddl script directory) for its repective scripts in the sql.ddl.dir + + --> + + <target name="run.ddl" if="conn.props.exist" depends="init" > + <echo>Loading connection properties ${basedir}/connection.properties</echo> + <!-- + Load the datasource specific connection properties + --> + <loadproperties srcFile="${basedir}/connection.properties"/> + + <!-- + Load the ddl specific parms in order to execute the ddl appropriately against the database type + --> + <loadproperties srcFile="${sql.ddl.dir}/${db.type}/exec_parms.properties"/> + + <antcall target="execute.create.schema" inheritall="true" /> + <antcall target="execute.create.tables" inheritall="true" /> + + + </target> + + <target name="init"> + <echo>Initializing at base dir ${basedir}</echo> + + <available file="${sql.ddl.dir}" property="dir.exist"/> + + <fail unless="dir.exist" message="${sql.ddl.dir} does not exist or was not set" /> + + <!-- + ${basedir}/ + --> + <available file="connection.properties" property="conn.props.exist"/> + + <!-- + due to the ddl supported syntax for certain databases ('if'), there is a need to + seperate the drop logic so that it can be executed with the option to not fail + if the user/schema doesn't exist. Because we want a failure to occur if the + schema cannot be create (don't care if an error occurs when it doesn't exist) + --> + <!-- + <property name="drop.script" value="${sql.ddl.dir}/${db.type}/drop_schema.sql" /> + <available file="${drop.script}" property="drop.exist"/> +--> + <!-- + <condition property="dont.create.schema"> + <isfalse value="${create.schema}" /> + </condition> + --> + + <condition property="create.database"> + <isset property="${adminuser}"/> + </condition> + <echo>Will only create/drop table be done ${create.database}</echo> + + <!-- + <condition property="dont.create.schema"> + <and> + <isset property="${create.schema}"/> + + <isfalse value="${create.schema}"/> + + </and> + </condition> +--> + + </target> + + + + <target name="execute.create.schema" + if="create.database"> + + <antcall target="execute.drop.schema" inheritall="true" /> + + + <echo>Executing sql for rdbms ${db.type} using delim ${delim}</echo> + <echo>Connecting using url ${adminurl}</echo> + <echo>using admin account ${adminuser} and pwd ${adminpassword}</echo> + + <property name="onerror" value="abort" /> + <property name="autocommit" value="true" /> + + <property name="create.script" value="${sql.ddl.dir}/${db.type}/create_schema.sql" /> + + <property name="target.create.script" value="${target.dir}/${db.type}_create_schema.sql" /> + + <available file="${create.script}" property="create.schema.script.exist"/> + + <fail unless="create.schema.script.exist" message="${create.script} does not exist" /> + + + <antcall target="make.sql.file" inheritall="true" > + <param name="script.file" value="${create.script}"/> + <param name="target.script.file" value="${target.create.script}"/> + </antcall> + + <antcall target="execute.schema.sql" inheritall="true" > + <param name="script.file" value="${target.create.script}"/> + </antcall> + + </target> + + <target name="execute.drop.schema" > + + <echo>Executing drop sql for rdbms ${db.type} </echo> + <property name="onerror" value="continue" /> + <property name="autocommit" value="true" /> + + <property name="drop.schema.script" value="${sql.ddl.dir}/${db.type}/drop_schema.sql" /> + <available file="${drop.schema.script}" property="create.schema.script.exist"/> + + <fail unless="create.schema.script.exist" message="${drop.schema.script} does not exist" /> + + + <property name="target.drop.schema.script" value="${target.dir}/${db.type}_drop_schema.sql" /> + + <antcall target="make.sql.file" inheritall="true" > + <param name="script.file" value="${drop.schema.script}"/> + <param name="target.script.file" value="${target.drop.schema.script}"/> + </antcall> + + <antcall target="execute.schema.sql" inheritall="true" > + <param name="script.file" value="${target.drop.schema.script}"/> + </antcall> + + </target> + + <target name="execute.create.tables" depends="execute.drop.tables" > + + <echo>Executing sql to load tables for ${db.type} </echo> + <echo>Connecting using url ${URL}</echo> + <echo>using username ${User} and password ${Password}</echo> + + <property name="create.table.script" value="${sql.ddl.dir}/${db.type}/create_tables.sql" /> + + <available file="${create.table.script}" property="create.table.script.exist"/> + + <fail unless="create.table.script.exist" message="${create.table.script} does not exist" /> + + + <property name="onerror" value="abort" /> + <property name="autocommit" value="true" /> + + <antcall target="execute.tables.sql" inheritall="true" > + <param name="script.file" value="${create.table.script}"/> + </antcall> + + </target> + + <target name="execute.drop.tables" > + + <echo>Executing sql to drop tables for ${db.type} </echo> + <echo>Connecting using url ${URL}</echo> + <echo>using username ${User} and password ${Password}</echo> + + <property name="drop.table.script" value="${sql.ddl.dir}/${db.type}/drop_tables.sql" /> + + <available file="${drop.table.script}" property="drop.table.script.exist"/> + + <fail unless="drop.table.script.exist" message="${drop.table.script} does not exist" /> + + + <property name="onerror" value="continue" /> + <property name="autocommit" value="true" /> + + <antcall target="execute.tables.sql" inheritall="true" > + <param name="script.file" value="${drop.table.script}"/> + </antcall> + </target> + + + <target name="make.sql.file" > + + <available file="${script.file}" property="script.file.exist"/> + + <fail unless="script.file.exist" message="${script.file} does not exist" /> + + <echo>Updating script file ${target.script.file}</echo> + + <delete file="${target.script.file}"/> + <copy file="${script.file}" tofile="${target.script.file}"/> + + <replace + file="${target.script.file}"> + <replacefilter + token="(username)" + value="${username}"/> + <replacefilter + token="(password)" + value="${password}"/> + <replacefilter + token="(databasename)" + value="${databasename}"/> + </replace> + </target> + + <!-- + This executes using the admin username and password because + it requires specific rights to create schema + --> + <target name="execute.schema.sql" > + <echo>Executing schema script file ${script.file}</echo> + <echo>Admin account: ${adminuser} url: ${adminurl}</echo> + + <available file="${script.file}" property="script.file.exist"/> + + <fail unless="script.file.exist" message="${script.file} does not exist" /> + + <sql driver="${driver}" + url="${adminurl}" + userid="${adminuser}" + password="${adminpassword}" + src="${script.file}" + rdbms="${rdbms.type}" + delimiter="${delim}" + delimitertype="${delimtype}" + autocommit="${autocommit}" + onerror="${onerror}" + classpath="${maven.runtime.classpath}" + /> + + + </target> + + <!-- + This executes using the username and password for the so that tables + are created under this user and not the admin + --> + <target name="execute.tables.sql" > + <echo>Executing table script file ${script.file}</echo> + <echo>User account: ${User} url: ${URL}</echo> + <echo>Classpath: ${maven.runtime.classpath}</echo> + + <available file="${script.file}" property="script.file.exist"/> + + <fail unless="script.file.exist" message="DDL ${script.file} does not exist" /> + + + <sql driver="${driver}" + url="${URL}" + userid="${User}" + password="${Password}" + src="${script.file}" + rdbms="${rdbms.type}" + delimiter="${delim}" + delimitertype="${delimtype}" + autocommit="${autocommit}" + onerror="${onerror}" + classpath="${maven.runtime.classpath}" + /> + + </target> + + <target name="does.user.schema.exist" > + <echo>Executing table script file ${script.file}</echo> + <echo>User account: ${adminuser} url: ${url}</echo> + + <available file="${script.file}" property="script.file.exist"/> + + <fail unless="script.file.exist" message="DDL ${script.file} does not exist" /> + + + <sql driver="${driver}" + url="${URL}" + userid="${adminuser}" + password="${adminpassword}" + src="${script.file}" + rdbms="${rdbms.type}" + delimiter="${delim}" + delimitertype="${delimtype}" + autocommit="${autocommit}" + onerror="${onerror}" + classpath="${maven.runtime.classpath}" + /> + + </target> + +</project> \ No newline at end of file Property changes on: trunk/test-integration/db/src/main/resources/ddl/run_ddl.xml ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/default-config.properties =================================================================== --- trunk/test-integration/db/src/main/resources/default-config.properties (rev 0) +++ trunk/test-integration/db/src/main/resources/default-config.properties 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,67 @@ +########################################## +# Common Properties for everybody +########################################## +#available types (datasource, driver, jndi) +#connection-type=datasource +connection-type=driver + +process-batch = 20 +connector-batch = 20 + +# local, xa, jndi +transaction-type=local + +# autocommit applies to local transaction-type only +# default is true +autocommit=false + +# this is how to submit queries to Teiid +# default is true +execute.in.batch=false + + +# AUTO_WRAP_OFF = "OFF" +# AUTO_WRAP_ON = "ON" +# AUTO_WRAP_PESSIMISTIC = "PESSIMISTIC" +# AUTO_WRAP_OPTIMISTIC = "OPTIMISTIC" + +# txnAutoWrap= + +########################################## +# properties for MetaMatrix connection +########################################## +driver=com.metamatrix.jdbc.EmbeddedDataSource +URL=jdbc:metamatrix:Transaction@target/classes/transactions/transaction.properties +User=metamatrixadmin +Password=mm +databasename=Transaction +servername=target/classes/transactions/transaction.properties +portnumber=0 +application-name=txn-test + +# jboss +# mm.ds-jndiname=java:mmXA +# usertxn-jndiname=UserTransaction + +# weblogic +mm.ds-jndiname=mmXA +usertxn-jndiname=java:comp/UserTransaction + +# === Mode-to-Datasource Mapping ====== +# <model>=<datasource type name> + +# This mapping will be used by the set of testcases that load this config file. +# These mapping control what datasource is mapped to which model +# +# See the resources/datasources/datasource_mapping.xml for the available datasource type names +# +# <datasource type name> can be the name of either a datasourcegroup or datasource +# +# + +pm1=nonxa +pm2=nonxa + + + + Property changes on: trunk/test-integration/db/src/main/resources/default-config.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Added: trunk/test-integration/db/src/main/resources/mysql/connection.properties =================================================================== --- trunk/test-integration/db/src/main/resources/mysql/connection.properties (rev 0) +++ trunk/test-integration/db/src/main/resources/mysql/connection.properties 2009-09-11 19:20:59 UTC (rev 1329) @@ -0,0 +1,22 @@ +db.type=mysql +driver=com.mysql.jdbc.Driver +URL=jdbc:mysql://slntds03.mm.atl2.redhat.com:3306/rep_unit_test +User=rep_unit_test +#rep_unit_test +Password=mm + +servername=slntds03.mm.atl2.redhat.com +databasename=rep_unit_test +portnumber=3306 +ds-jndiname=slntds03_mysql + +Immutable=true + +#adminuser=root +#adminpassword=mmroot +#adminurl=jdbc:mysql://slntds03.mm.atl2.redhat.com:3306 + + + + + Property changes on: trunk/test-integration/db/src/main/resources/mysql/connection.properties ___________________________________________________________________ Name: svn:mime-type + text/plain