SQL Server 2005 JDBC Adapter Limitations

Supported Types

This adapter supports types as follows.

Type nameSupportRemarks
BIGINTYes 
INTYes 
SMALLINTYes 
TINYINTYes 
BITYes 
NUMERICYes 
DECIMALYes 
MONEYYes 
SMALLMONEYYes 
FLOATYes 
REALYes 
DATETIMEYes 
SMALLDATETIMEYes 
CHARLimited 
VARCHARYes 
NCHARYes 
NVARCHARYes 
BINARYLimited 
VARBINARYLimited 
IMAGEYes 
VARCHAR (MAX)Yes 
NVARCHAR (MAX)Yes 
VARBINARY (MAX)Limited 
XMLLimited 
SQL_VARIANTNo 
UNIQUEIDENTIFIERNo 

Common to all processing

Specification Limits

Connection properties setting

Property Name Description Remarks
sendStringParametersAsUnicode
  • [true]:
    Indicates that the data is sent as Unicode.
  • [false]:
    Sent to server by the default collation of the database. When referring to index of string data other than Unicode, converting overhead from Unicode does not occur, thus the performance is improved.
  • The value defaults to true.
  • ODBC connection is invalid for this property.

Read Table

Specification Limits

Execute Select SQL

Specification Limits

None

Write table

Specification Limits

Execute Update SQL

Specification Limits

Execute Stored Procedure

Specification Limits

Write by Loader

Specification Limits

Notes

Main exceptions

Exception name Cause Actions
com.microsoft.sqlserver.jdbc.SQLServerException user '<username>' Login failed. Connected to the database but cannot login. Check [User name]/[Password].
Database requested in login "<database>" cannot be opened.Login failed. The specified database name may be incorrect. Ensure the specified [Database name] is correct.
Connection to host <host>, port <port number> has failed. Connection refused: connect. Make sure the connectivity with the SQL server is not compromised. Cannot connect to the database. Check the network connectivity and ensure the [Hostname] specified is valid.
object name '<table name>' is invalid. "<table name>" does not exist. Make sure the specified table exists.
Incorrect syntax near '<table name>'. The table name may not follow the rules for standard identifiers of Transact-SQL. In that case, enclose the specified table name with quotation marks.
This driver is not configured to be able to perform integrated authentication. Occurs when fails to connect using Windows integrated authentication. Please check the directory where sqljdbc_auth.dll is deployed.