skip to main content
OpenAccess SDK SQL Engine core methods for Java : Exchanging data : setTypesInfo method
 

setTypesInfo method

This method is used to set data types supported by a data source.
public void setTypesInfo(String Typename,
int Datatype,
long OaPrecision,
String LiteralPrefix,
String LiteralSuffix,
String CreateParams,
int OaNullable,
int OaCaseSensitive,
int OaSearchable,
int UnsignedAttrib,
int OaMoney,
int AutoIncrement,
int MinimumScale,
int MaximumScale,
String LocaltypeName)
Table 38. Parameters for setTypesInfo when using oa_types_info
Parameter
Type
Description
Typename
String
Data source-dependent data type name
Datatype
int
The ODBC SQL data type
OaPrecision
long
The maximum precision of the data type on the data source. NULL is returned for data types where precision is not applicable.
LiteralPrefix
String
Characters used to prefix a literal.
For data types where a literal is not applicable, use NULL.
LiteralSuffix
String
Characters used to terminate a literal.
For data types where a literal is not applicable, use NULL.
CreateParams
String
Parameters for data type definition.
OaNullable
int
Whether the data type can be null:
XO_NO_NULLS (0) - No nulls allowed
XO_NULLABLE (1) - Can be null
XO_NULLABLE_UNKNOWN (2) - Nullable unknown
OaCaseSensitive
int
Whether the data type is case sensitive in collation and comparison.
TRUE if the data type is a character data type and it is case sensitive.
FALSE if the data type is not a character data type or is not case sensitive.
OaSearchable
int
How the data type is used in a WHERE clause.
UnsignedSttrib
int
Whether the data type is unsigned. OpenAccess SDK does not support unsigned data types.
OaMoney
int
Whether the data type is a money data type.
AutoIncrement
int
Whether the data type is autoincrementing.
MinimumScale
int
Minimum scale of the data type.
maximumScale
int
Maximum scale of the data type.
LocaltypeName
String
Localized version of the database dependent data type name.