Chapter 8: Reference Topics

Datatype mapping between Java and SQL

Adaptive Server maps SQL datatypes to Java types (SQL-Java datatype mapping) and Java scalar types to SQL datatypes (Java-SQL datatype mapping). Table 8-3 shows SQL-Java datatype mapping.

**Table 8-3: Mapping SQL datatypes to Java types**
SQL type	Java type
char	String
varchar	String
nchar	String
nvarchar	String
unichar	String
univarchar	String
unitext	String
text	String
numeric	java.math.BigDecimal
decimal	java.math.BigDecimal
money	java.math.BigDecimal
smallmoney	Java.math.BigDecimal
bit	boolean
tinyint	byte
smallint	short
integer	int
bigint	java.math.BigInteger
unsigned smallint	int
unsigned int	long
unsigned bigint	java.math.BigInteger
bigint	java.math.BigInteger
real	float
float	double
double precision	double
binary	byte[ ]
varbinary	byte[ ]
image	java.io.InputStream
datetime	java.sql.Timestamp
smalldatetime	java.sql.Timestamp
date	java.sql.Date
time	java.sql.Time

The mapping of unsigned bigint to double is an approximation; it will not provide exact values. For exact values, convert the unsigned bigint value to a string value when passing it to a Java method.

Table 8-4 shows Java-SQL datatype mapping.

**Table 8-4: Mapping Java scalar types to SQL datatypes**
Java scalar type	SQL type
boolean	bit
byte	tinyint
short	smallint
int	integer
long	integer
float	real
double	double

View this book as PDF