How CLOB datatype of a table is represented in BusinessEvents project after its imported as a database concept.
Article ID: KB0086341
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
Description:
============
Columns of CLOB datatypes of the tables are represented as String (java string) in the DB concepts.
Note that the String datatype can hold CLOB values when you want to insert or query them into/from the database.
The actual database datatype of the column can be seen in the extended properties of the property. Right-click on the property and click on the "Extended Properties..." button. You will see the "Extended Properties" dialog showing the property’s extended properties. The type information will be given in "DATA_TYPE" element.
This metadata information about the property would be used (ie. string would be converted to CLOB) when inserting data into the database through DB concepts.
Environment:
============
o TIBCO BusinessEvents 3.0.1
o All OS
Description:
============
Columns of CLOB datatypes of the tables are represented as String (java string) in the DB concepts.
Note that the String datatype can hold CLOB values when you want to insert or query them into/from the database.
The actual database datatype of the column can be seen in the extended properties of the property. Right-click on the property and click on the "Extended Properties..." button. You will see the "Extended Properties" dialog showing the property’s extended properties. The type information will be given in "DATA_TYPE" element.
This metadata information about the property would be used (ie. string would be converted to CLOB) when inserting data into the database through DB concepts.
Environment:
============
o TIBCO BusinessEvents 3.0.1
o All OS
Issue/Introduction
How CLOB datatype of a table is represented in BusinessEvents project after its imported as a database concept.
Feedback
Yes
No
Powered by
