When connecting to Azure SQL databases, the recommended default loginTimeout is 30 seconds. Refer to the discussion of permissions in sys.databases (Transact-SQL) to understand SQLServerDatabaseMetaData.getCatalogs behavior on an Azure SQL Database.
SQLServerDatabaseMetaData.getCatalogs use the sys.databases view to get the catalogs. To connect to an Azure SQL Database, you should connect to the master database to call SQLServerDatabaseMetaData.getCatalogs.Īzure SQL Database doesn't support returning the entire set of catalogs from a user database. For more information to connect to an Azure SQL Database, see:Ĭonnect using Azure Active Directory Authentication This article discusses issues when you use the Microsoft JDBC Driver for SQL Server to connect to an Azure SQL Database.
0 kommentar(er)
