
Patch: r501_061010_0014.jar

Case: 4422
Description: 08/11/2006 Corrected query criteria for three DTC queries and rebuilt DTC

Case: 4327
Description: 08/18/2006 Enhancement to push eligible criteria after the join tree is chosen.

Case: 4421
Description: 08/17/2006 Fixed NPE when no password/trustore was defined and SSL was enabled and client auth was disabled

Case: 4315
Description: 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

Case: 4489
Description: 08/30/2006 Fixed mmshell/refresh command to prevent it from issuing new UUIDs

Case: 4239
Description: 09/1/2006 Fixed error generated when sending results from cache

Case: ----
Description: 08/30/2006 Allows connection via API to a secure server 

Case: 4556
Description: 09/01/2006 Fix to the generation strategy of SQL containing inline views.

Case: 4531
Description: 09/5/2006 Fixed error with unions and symbols that cannot be projected at runtime.

Case: 4504
Description: 09/08/2006 Fix for issue with a NullPointerException from select into statements whose columns are expressions.

Case: 4603
Description: 09/11/2006 Fixed error with using the hostname of the firewall in the firewall list when the local inetaddress for the firewall is different on the server.

Case: 4580
Description: 09/11/2006 Fixed JDBC URL format error that would occur if a password passed as part of the JDBC URL contains the @ symbol.

Case: ----
Description: 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.

Case: 4612
Description: 09/14/2006 Fixed problems with Option NoCache not getting propogated down to subcommands (Uncovered when loading dependent MatViews)

Case: 4704
Description: 10/6/2006 Fixed issue with Insert Into commands not getting translated by command logger

Case: 4673
Description: 10/10/2006 Resolve issues with DBLogger being unable to reconnect after network failure
