Mapping relationships between Sqlserver,mysql and Java types

The following are the corresponding relationships for SQL Server, JDBC type, and Java types:

S SQL Server Type ype	JDBC Type JDBC Type	Java Type Java Type	Mock Default Value	Description Description
bigint	BIGINT	Long	0
Timestamp	BINARY	Byte[]	Null	Use INSERT with a column list to exclude the timestamp column, Or insert a DEFAULT into the timestamp column.
Binary
Bit	BIT	Boolean	False
Char	CHAR	String	X
Decimal	DECIMAL	Java.math.BigDecimal	Bigdecimal.zero (0)
Money
SmallMoney
Float	DOUBLE	Double	0.0
Int	INTEGER	Int	0
Image	LongVarBinary	Byte[]	Null
varbinary (max)
varchar (max)	LongVarChar	String	"Test"
Text
NChar	CHAR	String	0
	NCHAR (Java SE 6.0)
nvarchar	VARCHAR	String	"TT"
	NVARCHAR (Java SE 6.0)
nvarchar (max)	LongVarChar	String	"TT"
ntext
Numeric	NUMERIC	Java.math.BigDecimal	Bigdecimal.zero (0)
Real	REAL	Float	0.0
smallint	SMALLINT	Short	0
Datetime	TIMESTAMP	Java.sql.Timestamp	"2012-01-01 10:00:00"
smalldatetime
varbinary	VARBINARY	Byte[]	Null
varchar	VARCHAR	String	"TT"
tinyint	SMALLINT	Short	0
Guid	NVARCHAR	String	"TT"	Length limit
Xml	LongVarChar	String	"TT"
Time	Time	Java.sql.Time	"10:00:00"
Date	DATE	Java.sql.Date	"2012-01-01"
DateTime2	TIMESTAMP	Java.sql.Timestamp	"2012-01-01 10:00:00"
DateTimeOffset	Microsoft.sql.Types. DATETIMEOFFSET	Microsoft.sql.DateTimeOffset	"2012-01-01 10:00:00"

Mapping relationships between Sqlserver,mysql and Java types