Package com.inductiveautomation.ignition.gateway.datasource.query

Enum Class SQLType

java.lang.Object

java.lang.Enum<SQLType>

com.inductiveautomation.ignition.gateway.datasource.query.SQLType

All Implemented Interfaces:

Serializable, Comparable<SQLType>, Constable

public enum SQLType
extends Enum<SQLType>

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
ARRAY
BIGINT
BINARY
BIT
BLOB
BOOLEAN
CHAR
CLOB
DATALINK
DATE
DECIMAL
DOUBLE
FLOAT
INTEGER
JAVA_OBJECT
LONGNVARCHAR
LONGVARBINARY
LONGVARCHAR
NCHAR
NCLOB
NULL
NUMERIC
NVARCHAR
OTHER
REAL
ROWID
SMALLINT
SQLXML
TIME
TIMESTAMP
TINYINT
VARBINARY
VARCHAR

Method Summary

Modifier and Type	Method	Description
static SQLType	findType(int typeCode)	Find the SQLType for the given type code from java.sql.Types
Class<?>	getJavaClass()
int	getType()	The corresponding code from java.sql.Types
Object	read(int columnIndex, ResultSet rs)
void	setParam(CallableStatement stmt, String paramName, Object value)
void	setParam(PreparedStatement stmt, int index, Object value)
static SQLType	valueOf(String name)	Returns the enum constant of this class with the specified name.
static SQLType[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

BIT

public static final SQLType BIT

TINYINT

public static final SQLType TINYINT

SMALLINT

public static final SQLType SMALLINT

INTEGER

public static final SQLType INTEGER

BIGINT

public static final SQLType BIGINT

FLOAT

public static final SQLType FLOAT

REAL

public static final SQLType REAL

DOUBLE

public static final SQLType DOUBLE

NUMERIC

public static final SQLType NUMERIC

DECIMAL

public static final SQLType DECIMAL

CHAR

public static final SQLType CHAR

VARCHAR

public static final SQLType VARCHAR

LONGVARCHAR

public static final SQLType LONGVARCHAR

DATE

public static final SQLType DATE

TIME

public static final SQLType TIME

TIMESTAMP

public static final SQLType TIMESTAMP

BINARY

public static final SQLType BINARY

VARBINARY

public static final SQLType VARBINARY

LONGVARBINARY

public static final SQLType LONGVARBINARY

NULL

public static final SQLType NULL

OTHER

public static final SQLType OTHER

JAVA_OBJECT

public static final SQLType JAVA_OBJECT

BLOB

public static final SQLType BLOB

CLOB

public static final SQLType CLOB

BOOLEAN

public static final SQLType BOOLEAN

NVARCHAR

public static final SQLType NVARCHAR

NCHAR

public static final SQLType NCHAR

LONGNVARCHAR

public static final SQLType LONGNVARCHAR

NCLOB

public static final SQLType NCLOB

ARRAY

public static final SQLType ARRAY

SQLXML

public static final SQLType SQLXML

DATALINK

public static final SQLType DATALINK

ROWID

public static final SQLType ROWID

Method Details

values

public static SQLType[] values()

Returns an array containing the constants of this enum class, in the order they are declared.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static SQLType valueOf(String name)

Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum class has no constant with the specified name

NullPointerException - if the argument is null

findType

public static SQLType findType(int typeCode)

Find the SQLType for the given type code from java.sql.Types

Throws:

IllegalArgumentException - if the typecode is unknown.

getType

public int getType()

The corresponding code from java.sql.Types

getJavaClass

public Class<?> getJavaClass()

read

public Object read(int columnIndex,
 ResultSet rs)
            throws SQLException

Throws:

SQLException

setParam

public void setParam(PreparedStatement stmt,
 int index,
 Object value)
              throws SQLException

Throws:

SQLException

setParam

public void setParam(CallableStatement stmt,
 String paramName,
 Object value)
              throws SQLException

Throws:

SQLException