MSSQL 2005 와 JDBC 타입 매칭.

2008. 12. 26. 16:13Database

Microsoft][SQL Server 2000 Driver for JDBC][SQL Server] Invalid Object Name. 
 
Use the native error code to look up details about the possible cause of the error. 
For these details, refer to your database documentation.
 
Data Types 

 


SQL Server Data Type
JDBC Data Type
bigint
BIGINT
bigint identity
BIGINT
binary
BINARY
bit
BIT
char
CHAR
datetime
TIMESTAMP
decimal
DECIMAL
decimal() identity
DECIMAL
float
FLOAT
image
LONGVARBINARY
int
INTEGER
int identity
INTEGER
money
DECIMAL
nchar
CHAR
ntext
LONGVARCHAR
numeric
NUMERIC
numeric() identity
NUMERIC
nvarchar
VARCHAR
real
REAL
smalldatetime
TIMESTAMP
smallint
SMALLINT
smallint identity
SMALLINT
smallmoney
DECIMAL
sql_variant
VARCHAR
sysname
VARCHAR
text
LONGVARCHAR
timestamp
BINARY
tinyint
TINYINT
tinyint identity
TINYINT
uniqueidentifier
CHAR
varbinary
VARBINARY
varchar
VARCHAR
 
 
SQL Server 2000 Driver for JDBC Service Pack 3