1.1

Then retrieve the XML value by using the ResultSet.getXXX method that corresponds to the target serialization
type (e.g. getClob in above example using CLOB data types). To store an XML value into a SQLFire database
using JDBC, use the XMLPARSE operator in the SQL statement. For example:
INSERT INTO t1(doc) VALUES XMLPARSE( DOCUMENT CAST (? AS CLOB) PRESERVE
WHITESPACE)
Then use any of the PreparedStatement.setXXX methods that are compatible with String types (e.g. in the above
example use PreparedStatement.setString or PreparedStatement.setCharacterStream).
java.lang.String; use explicit XML functions for inserts/queries as
explained above
Equivalent Java type
java.lang.Integer.MAX_VALUE (2147483647)Maximum length
noneJDBC metadata type
as per the target serialization typeJDBC methods
System.String; use explicit XML functions for inserts/queries as
explained above
Equivalent .NET type
noneADO.NET metadata type
noneADO.NET mapped System.Data.Dbtype
DbDataReader.GetStringADO.NET getter
SQL Standards Conformance
Understand how SQLFire conforms to SQL standards.
The feature is supported in SQLFire.Yes
The feature is supported (for example, through JDBC) but not according to the SQL standard. See explanatory
comment.
Yes*
The feature is partially supported. See comment.Partial
The feature is not supported.No
Does not apply.N/A
Map
SQL-99 Core / SQL-2003 Mandatory
NoteSQL-2003
Mandatory
SQL-99
Core
Feature nameFeature ID
YesYesNumeric data typesE011
YesYesINTEGER and SMALLINT data types
(including all spellings)
E011-01
YesYesREAL, DOUBLE PRECISON, and
FLOAT data types
E011-02
YesYesDECIMAL and NUMERIC data typesE011-03
YesYesArithmetic operatorsE011-04
615
SQL Language Reference