. Except for several geometry types,
UNKNOWN
, FEATURE
, FEATURES
and FEATURECOLLECTION
that are not
known by java.sql.Types
.
NOTE: Generally, it would be feasible to extend java.sql.Types
, but unfortunately, this is not possible,
as it's default constructor is not visible.
- Version:
- $Revision: 26926 $, $Date: 2010-09-22 17:23:56 +0200 (Mi, 22 Sep 2010) $
- Author:
- Andreas Poth , last edited by: $Author: aschmitz $
- See Also:
Types
Field Summary |
static int |
ANYTYPE
redefinition of java.sql.Types.VARCHAR |
static int |
ARRAY
maps to java.sql.Types.ARRAY (why not use directly?) |
static int |
BIGINT
maps to java.sql.Types.BIGINT (why not use directly?) |
static int |
BINARY
maps to java.sql.Types.BINARY (why not use directly?) |
static int |
BIT
maps to java.sql.Types.BIT (why not use directly?) |
static int |
BLOB
maps to java.sql.Types.BLOB (why not use directly?) |
static int |
BOOLEAN
maps to java.sql.Types.BOOLEAN (why not use directly?) |
static int |
CHAR
maps to java.sql.Types.CHAR (why not use directly?) |
static int |
CLOB
maps to java.sql.Types.CLOB (why not use directly?) |
static int |
CURVE
redefinition of java.sql.Types.VARCHAR |
static int |
DATALINK
maps to java.sql.Types.DATALINK (why not use directly?) |
static int |
DATE
maps to java.sql.Types.DATE (why not use directly?) |
static int |
DECIMAL
maps to java.sql.Types.DECIMAL (why not use directly?) |
static int |
DISTINCT
maps to java.sql.Types.DISTINCT (why not use directly?) |
static int |
DOUBLE
maps to java.sql.Types.DOUBLE (why not use directly?) |
static int |
ENVELOPE
redefinition of java.sql.Types.VARCHAR |
static int |
FEATURE
redefinition of java.sql.Types.VARCHAR |
static QualifiedName |
FEATURE_ARRAY_PROPERTY_NAME
TODO check if this is really needed {http://www.opengis.net/gml}:FeatureArrayPropertyType |
static QualifiedName |
FEATURE_PROPERTY_NAME
{http://www.opengis.net/gml}:FeaturePropertyType |
static int |
FEATURECOLLECTION
redefinition of java.sql.Types.VARCHAR |
static int |
FLOAT
maps to java.sql.Types.FLOAT (why not use directly?) |
static int |
GEOMETRY
redefinition of java.sql.Types.VARCHAR |
static QualifiedName |
GEOMETRY_PROPERTY_NAME
{http://www.opengis.net/gml}:GeGeometryPropertyType |
static int |
INTEGER
maps to java.sql.Types.INTEGER (why not use directly?) |
static int |
JAVA_OBJECT
maps to java.sql.Types.JAVA_OBJECT (why not use directly?) |
static int |
LONGVARBINARY
maps to java.sql.Types.LONGVARBINARY (why not use directly?) |
static int |
LONGVARCHAR
maps to java.sql.Types.LONGVARCHAR (why not use directly?) |
static QualifiedName |
MULTI_GEOMETRY_PROPERTY_NAME
{http://www.opengis.net/gml}:MultiGeometryPropertyType |
static int |
MULTICURVE
redefinition of java.sql.Types.VARCHAR |
static int |
MULTIGEOMETRY
redefinition of java.sql.Types.VARCHAR |
static int |
MULTIPOINT
redefinition of java.sql.Types.VARCHAR |
static int |
MULTISURFACE
redefinition of java.sql.Types.VARCHAR |
static int |
NULL
maps to java.sql.Types.NULL (why not use directly?) |
static int |
NUMERIC
maps to java.sql.Types.NUMERIC (why not use directly?) |
static int |
OTHER
maps to java.sql.Types.OTHER (why not use directly?) |
static int |
POINT
redefinition of java.sql.Types.VARCHAR |
static int |
REAL
maps to java.sql.Types.REAL (why not use directly?) |
static int |
REF
maps to java.sql.Types.REF (why not use directly?) |
static int |
SMALLINT
maps to java.sql.Types.SMALLINT (why not use directly?) |
static int |
STRUCT
maps to java.sql.Types.STRUCT (why not use directly?) |
static int |
SURFACE
redefinition of java.sql.Types.VARCHAR |
static int |
TIME
maps to java.sql.Types.TIME (why not use directly?) |
static int |
TIMESTAMP
maps to java.sql.Types.TIMESTAMP (why not use directly?) |
static int |
TINYINT
maps to java.sql.Types.TINYINT (why not use directly?) |
static int |
VARBINARY
maps to java.sql.Types.VARBINARY (why not use directly?) |
static int |
VARCHAR
maps to java.sql.Types.VARCHAR (why not use directly?) |
Constructor Summary |
Types()
|
Method Summary |
static int |
getJavaTypeForGMLType(java.lang.String gmlTypeName)
mapping between GML-typenames and java-classnames for GML-geometry types |
static int |
getJavaTypeForXSDType(java.lang.String schemaTypeName)
mapping between xml-typenames and java-classnames for XMLSCHEMA-simple types |
static int |
getTypeCodeForSQLType(java.lang.String typeName)
Returns the generic sql type code for the given type name. |
static java.lang.String |
getTypeNameForSQLTypeCode(int typeCode)
Returns the generic sql type name for the given type code. |
static java.lang.String |
getXSDTypeForSQLType(int type,
int precision)
Scale is set to 0. |
static java.lang.String |
getXSDTypeForSQLType(int type,
int precision,
int scale)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
ARRAY
public static final int ARRAY
- maps to java.sql.Types.ARRAY (why not use directly?)
- See Also:
- Constant Field Values
BIGINT
public static final int BIGINT
- maps to java.sql.Types.BIGINT (why not use directly?)
- See Also:
- Constant Field Values
BINARY
public static final int BINARY
- maps to java.sql.Types.BINARY (why not use directly?)
- See Also:
- Constant Field Values
BIT
public static final int BIT
- maps to java.sql.Types.BIT (why not use directly?)
- See Also:
- Constant Field Values
BLOB
public static final int BLOB
- maps to java.sql.Types.BLOB (why not use directly?)
- See Also:
- Constant Field Values
BOOLEAN
public static final int BOOLEAN
- maps to java.sql.Types.BOOLEAN (why not use directly?)
- See Also:
- Constant Field Values
CHAR
public static final int CHAR
- maps to java.sql.Types.CHAR (why not use directly?)
- See Also:
- Constant Field Values
CLOB
public static final int CLOB
- maps to java.sql.Types.CLOB (why not use directly?)
- See Also:
- Constant Field Values
DATALINK
public static final int DATALINK
- maps to java.sql.Types.DATALINK (why not use directly?)
- See Also:
- Constant Field Values
DATE
public static final int DATE
- maps to java.sql.Types.DATE (why not use directly?)
- See Also:
- Constant Field Values
DECIMAL
public static final int DECIMAL
- maps to java.sql.Types.DECIMAL (why not use directly?)
- See Also:
- Constant Field Values
DISTINCT
public static final int DISTINCT
- maps to java.sql.Types.DISTINCT (why not use directly?)
- See Also:
- Constant Field Values
DOUBLE
public static final int DOUBLE
- maps to java.sql.Types.DOUBLE (why not use directly?)
- See Also:
- Constant Field Values
FLOAT
public static final int FLOAT
- maps to java.sql.Types.FLOAT (why not use directly?)
- See Also:
- Constant Field Values
INTEGER
public static final int INTEGER
- maps to java.sql.Types.INTEGER (why not use directly?)
- See Also:
- Constant Field Values
JAVA_OBJECT
public static final int JAVA_OBJECT
- maps to java.sql.Types.JAVA_OBJECT (why not use directly?)
- See Also:
- Constant Field Values
LONGVARBINARY
public static final int LONGVARBINARY
- maps to java.sql.Types.LONGVARBINARY (why not use directly?)
- See Also:
- Constant Field Values
LONGVARCHAR
public static final int LONGVARCHAR
- maps to java.sql.Types.LONGVARCHAR (why not use directly?)
- See Also:
- Constant Field Values
NULL
public static final int NULL
- maps to java.sql.Types.NULL (why not use directly?)
- See Also:
- Constant Field Values
NUMERIC
public static final int NUMERIC
- maps to java.sql.Types.NUMERIC (why not use directly?)
- See Also:
- Constant Field Values
OTHER
public static final int OTHER
- maps to java.sql.Types.OTHER (why not use directly?)
- See Also:
- Constant Field Values
REAL
public static final int REAL
- maps to java.sql.Types.REAL (why not use directly?)
- See Also:
- Constant Field Values
REF
public static final int REF
- maps to java.sql.Types.REF (why not use directly?)
- See Also:
- Constant Field Values
SMALLINT
public static final int SMALLINT
- maps to java.sql.Types.SMALLINT (why not use directly?)
- See Also:
- Constant Field Values
STRUCT
public static final int STRUCT
- maps to java.sql.Types.STRUCT (why not use directly?)
- See Also:
- Constant Field Values
TIME
public static final int TIME
- maps to java.sql.Types.TIME (why not use directly?)
- See Also:
- Constant Field Values
TIMESTAMP
public static final int TIMESTAMP
- maps to java.sql.Types.TIMESTAMP (why not use directly?)
- See Also:
- Constant Field Values
TINYINT
public static final int TINYINT
- maps to java.sql.Types.TINYINT (why not use directly?)
- See Also:
- Constant Field Values
VARBINARY
public static final int VARBINARY
- maps to java.sql.Types.VARBINARY (why not use directly?)
- See Also:
- Constant Field Values
VARCHAR
public static final int VARCHAR
- maps to java.sql.Types.VARCHAR (why not use directly?)
- See Also:
- Constant Field Values
GEOMETRY
public static final int GEOMETRY
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
MULTIGEOMETRY
public static final int MULTIGEOMETRY
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
FEATURE
public static final int FEATURE
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
FEATURECOLLECTION
public static final int FEATURECOLLECTION
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
POINT
public static final int POINT
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
CURVE
public static final int CURVE
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
SURFACE
public static final int SURFACE
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
MULTIPOINT
public static final int MULTIPOINT
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
MULTICURVE
public static final int MULTICURVE
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
MULTISURFACE
public static final int MULTISURFACE
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
ENVELOPE
public static final int ENVELOPE
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
ANYTYPE
public static final int ANYTYPE
- redefinition of java.sql.Types.VARCHAR
- See Also:
- Constant Field Values
GEOMETRY_PROPERTY_NAME
public static final QualifiedName GEOMETRY_PROPERTY_NAME
- {http://www.opengis.net/gml}:GeGeometryPropertyType
MULTI_GEOMETRY_PROPERTY_NAME
public static final QualifiedName MULTI_GEOMETRY_PROPERTY_NAME
- {http://www.opengis.net/gml}:MultiGeometryPropertyType
FEATURE_PROPERTY_NAME
public static final QualifiedName FEATURE_PROPERTY_NAME
- {http://www.opengis.net/gml}:FeaturePropertyType
FEATURE_ARRAY_PROPERTY_NAME
public static final QualifiedName FEATURE_ARRAY_PROPERTY_NAME
- TODO check if this is really needed {http://www.opengis.net/gml}:FeatureArrayPropertyType
Types
public Types()
getTypeCodeForSQLType
public static int getTypeCodeForSQLType(java.lang.String typeName)
throws UnknownTypeException
- Returns the generic sql type code for the given type name.
- Parameters:
typeName
-
- Returns:
- the generic sql type code for the given type name.
- Throws:
UnknownTypeException
- if the type name is not an sql type name- See Also:
Types
getTypeNameForSQLTypeCode
public static java.lang.String getTypeNameForSQLTypeCode(int typeCode)
throws UnknownTypeException
- Returns the generic sql type name for the given type code.
- Parameters:
typeCode
-
- Returns:
- the generic sql type name for the given type code.
- Throws:
UnknownTypeException
- if the type code is not an sql type code- See Also:
Types
getJavaTypeForGMLType
public static int getJavaTypeForGMLType(java.lang.String gmlTypeName)
throws UnknownTypeException
- mapping between GML-typenames and java-classnames for GML-geometry types
- Parameters:
gmlTypeName
- the name of the GML type name
- Returns:
- the internal type
- Throws:
UnknownTypeException
- if the given name cannot be mapped to a known type.
getJavaTypeForXSDType
public static int getJavaTypeForXSDType(java.lang.String schemaTypeName)
throws UnknownTypeException
- mapping between xml-typenames and java-classnames for XMLSCHEMA-simple types
- Parameters:
schemaTypeName
- of the XML schema type
- Returns:
- the internal type
- Throws:
UnknownTypeException
- if the given name cannot be mapped to a known type.- To do:
- TODO map them all over registry
getXSDTypeForSQLType
public static java.lang.String getXSDTypeForSQLType(int type,
int precision)
- Scale is set to 0.
- Parameters:
type
- SQL datatype codeprecision
- precision (just used for type NUMERIC)
- Returns:
- typename
getXSDTypeForSQLType
public static java.lang.String getXSDTypeForSQLType(int type,
int precision,
int scale)
- Parameters:
type
- SQL datatype codeprecision
- precision (just used for type NUMERIC)scale
- scale (just used for type NUMERIC)
- Returns:
- typename
an open source project founded by lat/lon, Bonn, Germany.
For more information visit: http://www.deegree.org