SQL/MX Programming Manual for Java

SQLJ Programming
HP NonStop SQL/MX Programming Manual for Java—523726-003
3-35
Output Assignability
Output Assignability
The output assignability table shows the Java data types of output host variables and
expressions that accept data from SQL column types.
Note. For better performance in OLTP environments, use the data type mappings shown in
Optimal Data Type Mappings
on page 3-37.
Table 3-2. Output Assignability of Data Types (page 1 of 2)
SQL Data Type Maps to Java Wrapper Class or Primitive Data Type
*
...
CHAR[ACTER]
CHAR[ACTER] VARYING
VARCHAR
PIC[TURE] X
NATIONAL CHAR[ACTER]
NATIONAL CHAR[ACTER]
VARYING
NCHAR
NCHAR VARYING
java.lang.Byte (or byte), java.lang.String
java.lang.Boolean (or boolean)
java.sql.Date, java.sql.Time,
java.sql.Timestamp
java.lang.Short (or short),
java.lang.Integer (or int),
java.lang.Long (or long),
java.math.BigDecimal,
java.lang.Float (or float),
java.lang.Double (or double)
sqlj.runtime.AsciiStream,
sqlj.runtime.CharacterStream
**
,
sqlj.runtime.BinaryStream
DATE java.sql.Date, java.sql.Timestamp
java.lang.String
sqlj.runtime.AsciiStream,
sqlj.runtime.CharacterStream
**
,
sqlj.runtime.BinaryStream
TIME java.sql.Time
java.lang.String
sqlj.runtime.AsciiStream,
sqlj.runtime.CharacterStream
**
,
sqlj.runtime.BinaryStream
TIMESTAMP java.sql.Date, java.sql.Time,
java.sql.Timestamp
java.lang.String
sqlj.runtime.AsciiStream,
sqlj.runtime.CharacterStream
**
,
sqlj.runtime.BinaryStream
*
The Java primitive data types, such as boolean, byte, and int, have corresponding Java wrapper classes,
which are part of the java.lang package. Java primitive data types do not support null values. For more
information, see Null Values
on page 3-29.
**
The UnicodeStream type is deprecated in SQL/MX Release 2.x. Use CharacterStream instead.