Azure SQL Database Adapter Limitations

Supported Types
Common to All Operations
Read Table
Execute Select SQL
Write Table
Execute Update SQL
Execute Stored Procedure
Major Exceptions

Supported Types

The types supported in this adapter are the following.

Type name	Support	Remarks
BIGINT	Yes
INT	Yes
SMALLINT	Yes
TINYINT	Yes
BIT	Yes
NUMERIC	Yes
DECIMAL	Yes
MONEY	Yes
SMALLMONEY	Yes
FLOAT	Yes
REAL	Yes
TIME	No
DATE	No
SMALLDATETIME	Yes
DATETIME	Limited
DATETIME2	No
DATETIMEOFFSET	No
CHAR	Limited
VARCHAR	Limited
NCHAR	Yes
NVARCHAR	Yes
TEXT	Limited
NTEXT	Yes
BINARY	Yes
VARBINARY	Yes
IMAGE	Yes
VARCHAR(MAX)	Limited
NVARCHAR(MAX)	Yes
VARBINARY(MAX)	Yes
XML	Limited
SQL_VARIANT	No
UNIQUEIDENTIFIER	No

Yes: Supported.
Limited: Supported with limitations.
No: Not supported.

Common to All Operations

Specification Limits

Databases with names that include the following characters cannot be specified.
For more details, inquire the database vendor.
- “{“
- “;”
When executing multiple operations of this adapter in the same transaction, the connection may timeout after 5 minutes due to the specification limits of Azure SQL Database.

Notes

SSL is used in communication between Azure SQL Database and this adapter.
The establishment of connection may fail because of the reconfiguration of servers of Azure SQL Database.
In this case, repeats to reconnect for a certain period of time.

Read Table

Specification Limits

Displaying table list
- Tables that exist in schemas other than dbo will be displayed as "<schema name>.<table name>".
The table name is case-insensitive even if it is enclosed with quotation marks.

Execute Select SQL

Specification Limits

None.

Write Table

Specification Limits

Displaying table list
- Tables that exist in schemas other than dbo will be displayed as "<schema name>.<table name>".

DATETIME

When data is input in milliseconds, the values will be rounded. The values will be rounded to the nearest among 0 milliseconds, 3 milliseconds and 7 milliseconds.

Example	Rounded result
01/01/98 23:59:59.999	1998-01-02 00:00:00.000
01/01/98 23:59:59.995, 01/01/98 23:59:59.996, 01/01/98 23:59:59.997 or 01/01/98 23:59:59.998	1/1/1998 11:59:59 PM.997
01/01/98 23:59:59.992, 01/01/98 23:59:59.993, 01/01/98 23:59:59.994	1998-01-01-23:59:59.993
01/01/98 23:59:59.990 or 01/01/98 23:59:59.991	1/1/1998 11:59:59 PM.990

CHAR, VARCHAR, TEXT, VARCHAR(MAX)
- When the data includes multi-byte characters, character corruption will occur.
The table name is case-insensitive even if it is enclosed with quotation marks.

Execute Update SQL

DATETIME

When data is input in milliseconds, the values will be rounded. The values will be rounded to the nearest among 0 milliseconds, 3 milliseconds and 7 milliseconds.

Example	Rounded result
01/01/98 23:59:59.999	1998-01-02 00:00:00.000
01/01/98 23:59:59.995, 01/01/98 23:59:59.996, 01/01/98 23:59:59.997 or 01/01/98 23:59:59.998	1/1/1998 11:59:59 PM.997
01/01/98 23:59:59.992, 01/01/98 23:59:59.993, 01/01/98 23:59:59.994	1998-01-01-23:59:59.993
01/01/98 23:59:59.990 or 01/01/98 23:59:59.991	1/1/1998 11:59:59 PM.990

CHAR, VARCHAR, TEXT, VARCHAR(MAX)
- When the data includes multi-byte characters, character corruption will occur.

Execute Stored Procedure

Specification Limits

DATETIME

When data is input in milliseconds, the values will be rounded. The values will be rounded to the nearest among 0 milliseconds, 3 milliseconds and 7 milliseconds.

Example	Rounded result
01/01/98 23:59:59.999	1998-01-02 00:00:00.000
01/01/98 23:59:59.995, 01/01/98 23:59:59.996, 01/01/98 23:59:59.997 or 01/01/98 23:59:59.998	1/1/1998 11:59:59 PM.997
01/01/98 23:59:59.992, 01/01/98 23:59:59.993, 01/01/98 23:59:59.994	1998-01-01-23:59:59.993
01/01/98 23:59:59.990 or 01/01/98 23:59:59.991	1/1/1998 11:59:59 PM.990

CHAR, VARCHAR, TEXT, VARCHAR(MAX)
- When the data includes multi-byte characters, character corruption will occur.
XML
- Cannot execute when XML type is included in procedure arguments.
SQL_VARIANT
- Cannot execute when SQL_VARIANT type is included in procedure arguments.
UNIQUEIDENTIFIER
- Cannot execute when UNIQUEIDENTIFIER type is included in procedure arguments.
There are cases that a procedure with a name that has to be enclosed with quotation marks cannot be used.

When procedure to use output parameters is specified, the same as the output parameters will be displayed in the input parameter settings, and input data will be required.

Major Exceptions

Exception name		Cause	Solution
com.microsoft.sqlserver.jdbc.SQLServerException	Login failed for user '<user name>'	The user name or the password is incorrect.	Check [User name] or [Password] of the global resource. Also, check whether the user name is in the format of "<user name>@<server name>".
	TCP/IP connection to host <server name>.database.windows.net, port 1433 failed. Error: “connect timed out. Open the connection properties and check that a SQL Server instance is running in the host, that TCP/IP connection to the port is permitted, and that the TCP connection to the port is not blocked by firewall.	The database name or the user name is invalid.	Check [Database name] or [User name] of the global resource. Also, check whether the user name is in the format of "<user name>@<server name>".
	Connection reset	The user name is invalid.	Check whether [User name] of the global resource is in the format of “<user name>@<server name>”.
	Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.	The user name is invalid.	Check whether [User name] of the global resource is in the format of “<user name>@<server name>”. Also, check whether the correct value is set in <server name>.
	TCP/IP connection to the host <host name>, port 1433 failed. Error: "null. Open the connection properties and check that a SQL Server instance is running in the host, that TCP/IP connection to the port is permitted, and that the TCP connection to the port is not blocked by firewall.	Unable to connect to the database.	Check [Host name] of the global resource, or the network.
	Cannot open database "<database name>" requested by the login. The login failed.	The database is invalid.	Check [Database name] of the global resource.
	Invalid object name '<table name>'	The table name is invalid.	Check [Table name].
	Incorrect syntax near '<table name>'	The table name may not be in accordance with the rules of Transact-SQL standard identifier.	Enclose the table specified in [Table name] with quotation marks.