SQLType

java.lang.Object
- java.lang.Enum<SQLType>
- - com.inductiveautomation.ignition.gateway.datasource.query.SQLType

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<SQLType>
```
public enum SQLType
extends java.lang.Enum<SQLType>
```

Enum Constant Summary

Enum Constants
Enum Constant and 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

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

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

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 Detail
- values
```
public static SQLType[] values()
```
  Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (SQLType c : SQLType.values())
    System.out.println(c);
```
  Returns:
  
  an array containing the constants of this enum type, in the order they are declared
- valueOf
```
public static SQLType valueOf(java.lang.String name)
```
  Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (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:
  
  java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
  
  java.lang.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:
  
  java.lang.IllegalArgumentException - if the typecode is unknown.
- getType
```
public int getType()
```
  The corresponding code from java.sql.Types
- getJavaClass
```
public java.lang.Class<?> getJavaClass()
```
- read
```
public java.lang.Object read(int columnIndex,
                             java.sql.ResultSet rs)
                      throws java.sql.SQLException
```
  Throws:
  
  java.sql.SQLException
- setParam
```
public void setParam(java.sql.PreparedStatement stmt,
                     int index,
                     java.lang.Object value)
              throws java.sql.SQLException
```
  Throws:
  
  java.sql.SQLException
- setParam
```
public void setParam(java.sql.CallableStatement stmt,
                     java.lang.String paramName,
                     java.lang.Object value)
              throws java.sql.SQLException
```
  Throws:
  
  java.sql.SQLException

Enum SQLType

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

BIT

TINYINT

SMALLINT

INTEGER

BIGINT

FLOAT

REAL

DOUBLE

NUMERIC

DECIMAL

CHAR

VARCHAR

LONGVARCHAR

DATE

TIME

TIMESTAMP

BINARY

VARBINARY

LONGVARBINARY

NULL

OTHER

JAVA_OBJECT

BLOB

CLOB

BOOLEAN

NVARCHAR

NCHAR

LONGNVARCHAR

NCLOB

ARRAY

SQLXML

DATALINK

ROWID

Method Detail

values

valueOf

findType

getType

getJavaClass

read

setParam

setParam