This article describes the principal changes of Oracle Component.
Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.
If you have any question, any feature request or any issue, do not hesitate to contact us.
This article is dedicated to Stambia DI 2020 (S20.x.x) or higher.
JDBC Drivers classes and URLs
- Stambia DI Designer 2020 (S20.2.0) or higher
Stambia DI Designer 20.2.0 introduces an improvement which allows Components and Modules definition to provide themselves the proper JDBC drivers classes and URLs, for the connection wizard to automatically adapt depending on the Module selected.
This Component has therefore been updated to take into account this improvement and provide the necessary JDBC drivers classes and URLs information.
The component example project can now be imported directly in the "New" menu of the Project Explorer.
Maximum VARCHAR2 size
From Oracle V12, the size of VARCHAR2 type fields is no longer limited to 4000 characters.
Define the Oracle Version on your Metadata, in the "database major version".
If this version is less than 12 or empty, the size remains limited to 4000.
If this version is greater than or equal to 12, the size is no longer limited (up to 32,767 characters maximum).
Fix an issue with creation mask for VARCHAR2 and CHAR datatypes
Creation mask for VARCHAR2 and CHAR datatypes should use 'CHAR' as character type when no information is provided.
Now when loading data into Oracle from any source, if there is no character type information defined on the sources Metadata, the columns created using the creation will use "CHAR" as character type instead of specifying an empty value.
For instance: mycolumn VARCHAR2(255 CHAR) instead of mycolumn VARCHAR2(255)
This will make sure the same character type is used when no information is provided instead of relying on the database default value which may vary between databases configuration and which can cause issues.