Native-type Conversions of a Wrapper to Java Types

Each wrapper type has its own associations between native types of the sources modeled and java types. The following sections show the conversions applied to the different wrapper types supported by Virtual DataPort.

In general, for those wrappers that access sources that may return objects or arrays of objects the wrapper is responsible for representing these structures using Virtual DataPort registers and arrays respectively.

Type Conversion Tables for JDBC Wrappers

Type Conversion Tables for JDBC Wrappers
JDBC types Java types
ARRAY java.lang.String
BIGINT java.lang.Long
BINARY java.lang.String
BIT java.lang.Boolean
BLOB byte[]
BOOLEAN java.lang.Boolean
CHAR java.lang.String
CLOB java.lang.String
DATALINK java.lang.String
DATE java.sql.Date
DECIMAL java.lang.Double
DISTINCT java.lang.String
DOUBLE java.lang.Double
FLOAT java.lang.Float
INTEGER java.lang.Integer
Java_OBJECT java.lang.String
LONGVARBINARY java.lang.String
LONGVARCHAR java.lang.String
NULL java.lang.String
NUMERIC java.lang.Double
OTHER java.lang.String
REAL java.lang.Float
REF java.lang.String
SMALLINT java.lang.Short
STRUCT java.lang.String
TIME java.sql.Time
TIMESTAMP java.sql.Timestamp
TINYINT java.lang.Byte
VARBINARY java.lang.String
VARCHAR java.lang.String

Other types are converted to java.lang.String.

Note

The table shows the generic conversions associated to JDBC sources. Depending on the vendor and the version of the database which is being accessed, these conversions may vary slightly.

Type Conversion Table for ODBC Wrappers

For ODBC wrappers the same conversions are applied as for the JDBC wrappers.

Type Conversion Table for Web Source Wrappers

Web wrappers use the following type conversion table:

ITPilot-type conversions
ITPilot Types Java Types
boolean boolean
date java.util.Calendar
double double
float float
int int
string java.lang.String
url java.lang.String

Type Conversion Table for Web Services Wrappers

Type Conversion Table for Web Services Wrappers
SOAP Types Java Types
xsd:base64Binary byte[]
xsd:boolean boolean
xsd:byte byte
xsd:dateTime java.util.Calendar
xsd:decimal java.math.BigDecimal
xsd:double double
xsd:float float
xsd:hexBinary byte[]
xsd:int int
xsd:integer java.math.BigInteger
xsd:long long
xsd:QName java.lang.String with format “{namespace}localPart”
xsd:short short
xsd:string java.lang.String

Compound elements are converted to Java objects by following the standard mapping defined by the JAX-RPC standard.

Type Conversion Table for XML Wrappers

Type Conversion Table for XML Wrappers
XML/Schema Types Java Types

positiveinteger

negativeinteger

nonpositiveinteger

nonnegativeinteger

int

unsignedint

gYear

gMonth

gDay

java.lang.Integer

long

unsignedlong

java.lang.Long

byte

unsignedbyte

java.lang.Byte
double java.lang.Double
float java.lang.Float

short

unsignedshort

java.lang.Short
boolean java.lang.Boolean

string

normalizedString

token

base64Binary

hexBinary

duration

dateTime

date

time

gYearMonth

gMonthDay

java.lang.String

Type Conversion Table for Delimited File Wrappers

DF wrappers always consider the extracted data as java.lang.String.

Type Conversion Table for CUSTOM Wrappers

A CUSTOM wrapper indicates the types of its fields with Java classes and, therefore, requires no conversion.

Type Conversion Table for Aracne Wrappers

Important

Aracne wrappers are deprecated and will be removed in a later version of the Denodo Platform. No new Aracne wrappers can be created in version 7.0, but you could edit and use the existing ones. You can see the documentation from previous version.

Type Conversion Table for Google Search Wrappers

All the fields in Google Search indexes are translated to attributes of type text in Virtual DataPort, except for the field RATING which is of int type.

Wrappers created from Google Search indexes include some additional attributes besides the ones contained in the original index. These fields may be of other types. See section Google Search Data Sources.