What is the workaround to map the BIT datatype columns asMinstance "Integer"? Please note that BIT is not supported by ADB as of ADB v3.3.1.
Article ID: KB0088291
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Resolution:
After you configure the publication using adbconfig utility,
1. Add one column in your publishing table whose type is "int".
2. Modify your triggers generated by adbconfig tool to make it select the "bit" column into this "int" column.
3. Modify your class schema of publishing table in your repository, add one more attribute whose type is "i4". The attribute name should be same as the "int" column name in the publishing table.
After you configure the publication using adbconfig utility,
1. Add one column in your publishing table whose type is "int".
2. Modify your triggers generated by adbconfig tool to make it select the "bit" column into this "int" column.
3. Modify your class schema of publishing table in your repository, add one more attribute whose type is "i4". The attribute name should be same as the "int" column name in the publishing table.
Issue/Introduction
What is the workaround to map the BIT datatype columns asMinstance "Integer"? Please note that BIT is not supported by ADB as of ADB v3.3.1.
Feedback
Yes
No
Powered by
