Features Deprecated in Virtual DataPort 7.0¶
This section lists the features that are currently deprecated in Denodo Virtual DataPort 7.0. This list is updated when a feature is marked as deprecated (last update of this list: Nov 30, 2018)
Deprecated features are not actively maintained and may be removed in the next major version of the Denodo Platform. We strongly recommend not using them anymore.
- Data Type “Date”
- VQL Syntax
- Aracne Data Sources
- Deprecated Functions
- Denodo Stored Procedures
- Denodo Stored Procedures API: getNumOfAffectedRows Method
- Denodo Custom Wrappers API: Deprecated Methods
- Denodo JDBC Driver
- Denodo Web Services
- Script Export
Starting with Denodo 7.0, the data type “date” is deprecated, although is maintained for compatibility reasons. The fields with this data type will behave in the same way as in prior versions 6.0. Instead use the new types: localdate, time, timestamp or timestamptz.
Starting with Denodo 6.0, the
SQLFRAGMENT clause of the
CREATE WRAPPER JDBC statement has
Starting with Denodo 6.0, the syntax
ALTER TABLE <base view name>
ADD SEARCHMETHOD is
When creating a base view, define the search methods in the
CREATE TABLE statement instead of executing a
CREATE TABLE and
then, adding the search methods with the statement
This reduces the number of statements Virtual DataPort has to process.
For example, instead of running this:
CREATE TABLE internet_inc I18N us_est ( iinc_id:long, summary:text, ... ... ); ALTER TABLE internet_inc CACHE OFF TIMETOLIVEINCACHE DEFAULT ADD SEARCHMETHOD internet_inc( I18N us_est CONSTRAINTS ( ADD iinc_id (any) OPT ANY ADD summary (any) OPT ANY ... ... ) OUTPUTLIST (iinc_id, specific_field1, specific_field2, summary, taxid, ttime ) WRAPPER (jdbc internet_inc) );
Run the following (i.e. just one command)
CREATE TABLE internet_inc I18N us_est ( iinc_id:long, summary:text, ... ... ) CACHE OFF TIMETOLIVEINCACHE DEFAULT ADD SEARCHMETHOD internet_inc( I18N us_est CONSTRAINTS ( ADD iinc_id (any) OPT ANY ADD summary (any) OPT ANY ... ... ) OUTPUTLIST (iinc_id, specific_field1, specific_field2, summary, taxid, ttime ) WRAPPER (jdbc internet_inc) );
Starting with Denodo 5.5, the parameter
VIEWPROPERTIES of the
CONTEXT clause of
SELECT statements is deprecated.
The only reason to use it is to specify at runtime the value of the parameter “begin delimiter” of a DF data source. Instead, enable the option Start delimiter from variable of the data source.
Starting with Denodo 7.0, the Aracne module has been deprecated so the administration tool no longer supports creating new Aracne data sources. However, if they have been imported from a previous version, they can be opened.
CREATETYPEFROMXML is deprecated and may be removed in future versions of the Denodo Platform. Instead, create an XML data source with a route of type from variable and pass the XML document to this data source.
The following stored procedures included out-of-the box in Virtual DataPort are deprecated:
- CATALOG_ELEMENTS replaced with GET_ELEMENTS.
- CATALOG_VIEWS replaced with GET_VIEWS.
- CATALOG_PKS replaced with GET_PRIMARY_KEYS.
- CATALOG_FKS replaced with GET_FOREIGN_KEYS.
These procedures have been replaced with new ones because the old ones only return information about the database you are currently connected to. The new ones (“GET_…”) can obtain the same information from any database.
Starting with Denodo 6.0, the method
getNumOfAffectedRows() of the stored procedures API has
been deprecated. Do not override this method in new stored procedures.
Although it is deprecated, the method will probably not be removed from future versions of the API in order to maintain binary compatibility with old stored procedures.
Starting with Denodo 6.0, the following methods of API for Denodo custom wrappers have been deprecated:
Starting with Denodo 7.0, the parameter
wanOptimizedCalls of the JDBC driver has been deprecated.
This parameter is deprecated because in Denodo 7.0 its default value is true and there is no reason to set it to false. In previous versions, the default value of this parameter is false. If true the driver reduces the number of remote calls it sends to the Server. In addition, when the application closes a result set, the driver only sends a cancel request to the Server if there are still pending results. If false, the driver always sends the cancel request.
The Denodo Web Services created with Virtual DataPort 4.7 or earlier versions are deprecated. These web services provide SOAP and REST capabilities. They still work, its VQL statements can be loaded into Virtual DataPort 7.0 and can be edited from the administration tool. However, no new web services of this type can be created.
Starting with Denodo 5.0, SOAP web services and REST web services are different elements. The reason is that SOAP web services are operation-oriented and REST web services are resource-oriented.