Mapping of SQL and JDBC data types to XML data types

The data type of a parameter or column of a result set in a message is specified using XML data types.

The following table shows the default mappings from SQL and JDBC data types to XML data types.

Table 1.

DB2® SQL type	Informix® SQL type	JDBC type	XML type
BIGINT	INT8	java.sql.Types.BIGINT	xsd:long
CHAR FOR BIT DATA, BINARY	BYTE	java.sql.Types.BINARY	xsd:base64Binary
		java.sql.Types.BIT	xsd:short
BLOB		java.sql.Types.BLOB	xsd:base64Binary
	BOOLEAN	java.sql.Types.BOOLEAN	xsd:boolean
CHAR, GRAPHIC	CHAR	java.sql.Types.CHAR	xsd:string
CLOB, DBCLOB		java.sql.Types.CLOB	xsd:string
DATALINK		java.sql.Types.DATALINK	xsd:anyURI
DATE	DATE	java.sql.Types.DATE	xsd:date
DECIMAL, DECFLOAT	DECIMAL	java.sql.Types.DECIMAL	xsd:decimal
DOUBLE		java.sql.Types.DOUBLE	xsd:double
REAL	FLOAT	java.sql.Types.FLOAT	xsd:float
INTEGER	INTEGER	java.sql.Types.INTEGER	xsd:int
	BLOB	java.sql.Types.LONGVARBINARY	xsd:base64Binary
	CLOB, TEXT	java.sql.Types.LONGVARCHAR	xsd:string
	MONEY	java.sql.Types.NUMERIC	xsd:decimal
	SMALLFLOAT	java.sql.Types.REAL	xsd:float
SMALLINT	SMALLINT	java.sql.Types.SMALLINT	xsd:short
TIME	DATETIME HOUR TO SECOND	java.sql.Types.TIMESTAMP	xsd:time
TIMESTAMP	DATETIME YEAR TO FRACTION	java.sql.Types.TIMESTAMP	xsd:dateTime
		java.sql.Types.TINYINT	xsd:short
VARCHAR FOR BIT DATA, VARBINARY		java.sql.Types.VARBINARY	xsd:base64Binary
VARCHAR, VARGRAPHIC	VARCHAR	java.sql.Types.VARCHAR	xsd:string
		java.sql.Types.ARRAY	xsd:string
		java.sql.Types.DISTINCT	xsd:string
		java.sql.Types.JAVA_OBJECT	xsd:string
		java.sql.Types.NULL	xsd:string
		java.sql.Types.OTHER	xsd:string
		java.sql.Types.REF	xsd:string
		java.sql.Types.STRUCT	xsd:string
ROWID		100	xsd:base64Binary
XML		2009	xsd:anyType
		Any other type that is not listed	xsd:string

 

Related concepts

Support for the DB2 native XML data type in Web service operations

 

Related tasks

Developing Web services with the workbench

Deploying, undeploying, and testing Web services

Migrating Web applications that were developed for the Web Object Runtime Framework (WORF)

 

Related reference

Supported Web servers, SOAP engines, and databases

Supported message protocols

---