
All Modeler patches are cumulative. All previous patches to this version of the Modeler are rolled up and 
included in this patch. The history below shows summary of all fixes addressed by this and previous patches.

This cumulative patch may also conatin patches for extension jars.  Extension jar patches should be added 
to connector binding classpathes as necessary (i.e. extensionjar:jdbcconn_PATCH.jar;extensionjar:jdbcconn.jar).

Installed Patch: dd501_070323_0070.zip

Case      Summary
=====     ====================================================================================
4284      08/11/2006 Text Connector changes for better error messages and to allow text connector to start with at least one good group/file.
----      08/11/2006 Fixes "Validate Model Transformations" action
4435      08/14/2006 Fixes transformation validation inefficiencies
4496      "
4315      08/18/2006 Fix of JDBC client handling of batching (determined by setFetchSize on the statement) results for CallableStatements.
  Fix for reading batches from connectors returning results for stored procedures.
  Usage Note: To avoid errors, CallableStatments should be created as scroll insensitive.
  Enhancement to allow the fetch size for procedures to be set as a connector binding property.  To enable this property, an entry in the ConfigurationInfo.def or server config file is needed.  For exmample:
  <Connector Name="My Sybase Connector" ComponentType="Sybase ANSI JDBC Connector" ...
    <Property Name="FetchSize">5000</Property>
    ...
  Sets a fetch size of 5000 for My Sybase Connector.  This setting can be exposed for editing through the console by adding it to the appropriate component definition.  For example:

  <ComponentType Name="Sybase ANSI JDBC Connector" ...
    <ComponentTypeDefn Deprecated="false">
      <PropertyDefinition Name="FetchSize" DisplayName="Fetch Size" ShortDescription="Fetch Size For Procedure Execution." DefaultValue="0" Multiplicity="0..1" PropertyType="Integer" ValueDelimiter="," IsConstrainedToAllowedValues="true" IsExpert="true" IsHidden="false" IsMasked="false" IsModifiable="true" IsPreferred="false"/>
    </ComponentTypeDefn>
    ...
  Allows the fetch size to be edited for all Sybase ANSI JDBC Connectors
4523      08/18/2006 Fixed NPE when using prepared statement and setting a clob
4520      08/29/2006 Fixes Issues with chaining XmlServices
4541      08/29/2006 Remove connector trace log message which contained password
----      08/29/2006 Additional Fixes for "Validate Model Transformations" action
4489      08/30/2006 Fixed mmshell/refresh command to prevent it from issuing new UUIDs
4517      09/5/2006 Resolve issue with creation of indexes in ERwin import logical models
4569      09/8/2006 Fixed error with generation of Materialized View scripts where source tables are nested in catalogs
4580      09/11/2006 Fixed JDBC URL format error that would occur if a password passed as part of the JDBC URL contains the @ symbol.
----      09/14/2006 Enhancement: JDBC connectors will now create PreparedStatements instead of Statements in many situations.  A JDBC connector can be forced to use PreparedStatements in all situations where Statement would have been used with the connector binding property UseBindVariables set to true.
4602      09/14/2006 Changed materialized view script generation to use native types where applicable
4590      09/14/2006 Changed materialized view load scripts to always explicitly add OPTION NOCACHE 
4661      09/28/2006 Resolve issues with Content By Element property for Web Service Input Messages
4704      10/6/2006 Fixed issue with Insert Into commands not getting translated by command logger
4723      10/13/2006 Implements SQLState classes for connection, communication, logon, and session failures.  This gives a connection pool the ability to detect when a connection should be considered stale.  The state classes returned are 08001, 08S01, and 28000 depending on the failure.
4723      10/13/2006 Fixes an issue in where the client may not correctly be closing a connection if an exception is thrown while the connection is being shutdown.
4514      10/17/2006 Enhanced Save Diagram process to warn if too large, and allow smaller selection-based portions to be saved
4624      10/20/2006 Fixed resolver issue with SELECT INTO temp group commands
4749      10/30/2006 Fixed construction of source sql for oracle when LIMIT is used.
4784      10/30/2006 Resolve issues with XML planning relating to passing criterial against staging tables
4747      11/08/2006 Addresses problem with resolution of import statements in schemas
4857      11/14/2006 Changes to Generic Importer to support loading into an existing Model
4845      11/15/2006 Resolve issues with Redeploy VDB action in console throwing missing VDB exception.  Requires VDBs to be modifed and rebuilt in Designer with a new version deployed the server
4863      11/17/2006 Addresses designer performance issue with open transformations.
4979      12/08/2006 Resolves issue building XML Doc from schema, with selection of first level only
4997      12/12/2006 Adds validation error check for Procedure which has group reference to itself.
5007      12/12/2006 Resolves issue with Designer Transformation Editor validation
5035      12/13/2006 Resolves issue with New Relational View Model creation with selective copy
      "
5034      12/15/2006 Resolves issue with Choice Criteria validation and removes stagingTables from allowable choice criteria
4988      12/18/2006 Fixes incorrect display of default namespace propery value
5071      12/20/2006 Fixes issue with marking XMLAttributes as excluded from document
5078      12/21/2006 Fixes incorrect display for minOccurs on Xml Choice nodes
5069      01/04/2007 Resolves issue with node ordering of xml result documents
5159      01/22/2007 Resolves problem with xml document model validation exceptions.
5197      01/29/2007 Fixes validation issue with mapping classes
5202      02/02/2007 Fixes validation problem with xml doc excluded elements
----      02/09/2007 Fixes incorrect RelationalTypeMapping string constant for TIME
----      03/14/2007 Added Designer Export and Import actions for Sql Transformations
5409      03/19/2007 Resolves issues with Columns not showing when adding tables to custom diagrams
----      03/23/2007 Additional fix for Designer Export and Import actions for Sql Transformations
