I need to reproduce a table (in fact a view, but let's start with a simple table 😊) in IRIS as the currently used in Oracle.
I need to expose/project one column to JDBC as CLOB, in my class I have the corresponding property defined as:
Property GlobStream As %Stream.GlobalCharacter;
In JDBC this column is projected as LONGVARCHAR, this is compliant with the documentation but I need to project it as CLOB.
In addition, I'm no expert in JDBC but wit seems that LONGVARCHAR has a Maximum Length 32,700 characters in JDBC, not quite enough for an arbitrary stream.
(1).jpg)
.jpg)


.png)
.jpg)


.jpg)
.png)
