"Trailing Spaces" and "Case sensitivity" settings
Article ID: KB0082854
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | ALL VERSIONS |
Description
"Trailing Spaces" and "Case sensitivity" settings
Issue/Introduction
"Trailing Spaces" and "Case sensitivity" settings
Resolution
Below mentioned settings can be modified at the data source level as follows:
• Identify the adapter type for the datasource in question. You can do that by opening the datasource and looking at “Adapter Name” in “Basic Tab” of the datasource. E.g. for oracle 10g, Adapter Name might be “microsoft_sql_server_2012”
• Go to that respective adapter subfolder in “adapters” folder inside composite installation e.g. in case of microsoft_sql_server_2012 it would be “<ADS INSTALL>\conf\adapters\system\microsoft_sql_server_2012”
• Once inside the respective adapter subfolder, open the adapter settings xml file in a text editor like notepad e.g. file “microsoft_sql_server_2012_values.xml” for microsoft_sql_server_2012 driver.
• In the xml file, search for string “comparisonCaseInSensitive” for case-sensitivity, cut and paste the following xml attribute block to the top(outside commented block but under <common:attributes xmlns:common="http://www.compositesw.com/services/system/util/common"> tag):
<ns8:attribute xmlns:ns8="http://www.compositesw.com/services/system/util/common">
<ns8:name>/runtime/query/comparisonCaseInSensitive</ns8:name>
<ns8:type>BOOLEAN</ns8:type>
<ns8:value>true</ns8:value>
<ns8:configID>jdbcds.comparisons_case_insensitive</ns8:configID>
</ns8:attribute>
Also change the value of this xml attribute to true in the pasted block, as shown shown above.
• Similarly, In the xml file, search for string “trailingSpaceIncludeInComparison” for trailing-spaces, cut and paste the following xml attribute block:
<ns26:attribute xmlns:ns26="http://www.compositesw.com/services/system/util/common">
<ns26:name>/runtime/query/trailingSpaceIncludeInComparison</ns26:name>
<ns26:type>BOOLEAN</ns26:type>
<ns26:value>false</ns26:value>
<ns26:configID>jdbcds.trailing_spaces_included_in_comparison</ns26:configID>
</ns26:attribute>
Also change the value of this xml attribute to false in the pasted block.
6) Restart the ADS server for the changes to take effect.
• Identify the adapter type for the datasource in question. You can do that by opening the datasource and looking at “Adapter Name” in “Basic Tab” of the datasource. E.g. for oracle 10g, Adapter Name might be “microsoft_sql_server_2012”
• Go to that respective adapter subfolder in “adapters” folder inside composite installation e.g. in case of microsoft_sql_server_2012 it would be “<ADS INSTALL>\conf\adapters\system\microsoft_sql_server_2012”
• Once inside the respective adapter subfolder, open the adapter settings xml file in a text editor like notepad e.g. file “microsoft_sql_server_2012_values.xml” for microsoft_sql_server_2012 driver.
• In the xml file, search for string “comparisonCaseInSensitive” for case-sensitivity, cut and paste the following xml attribute block to the top(outside commented block but under <common:attributes xmlns:common="http://www.compositesw.com/services/system/util/common"> tag):
<ns8:attribute xmlns:ns8="http://www.compositesw.com/services/system/util/common">
<ns8:name>/runtime/query/comparisonCaseInSensitive</ns8:name>
<ns8:type>BOOLEAN</ns8:type>
<ns8:value>true</ns8:value>
<ns8:configID>jdbcds.comparisons_case_insensitive</ns8:configID>
</ns8:attribute>
Also change the value of this xml attribute to true in the pasted block, as shown shown above.
• Similarly, In the xml file, search for string “trailingSpaceIncludeInComparison” for trailing-spaces, cut and paste the following xml attribute block:
<ns26:attribute xmlns:ns26="http://www.compositesw.com/services/system/util/common">
<ns26:name>/runtime/query/trailingSpaceIncludeInComparison</ns26:name>
<ns26:type>BOOLEAN</ns26:type>
<ns26:value>false</ns26:value>
<ns26:configID>jdbcds.trailing_spaces_included_in_comparison</ns26:configID>
</ns26:attribute>
Also change the value of this xml attribute to false in the pasted block.
6) Restart the ADS server for the changes to take effect.
Feedback
Yes
No
Powered by
