"The multi-part identifier "sys.schemas.name" could not be bound.

Susan 0

Driver version

12.4.0.jre8

SQL Server version

Problem description

When we use jdbc to connect to the Azure sqlserver, if we invoke the mssql jdbc api SQLServerDatabaseMetaData.getSchemas(), we receive the error The multi-part identifier "sys.schemas.name" could not be bound. I found actually the error is throw when executing the sql packaged in mssql jdbc:

select sys.schemas.name 'TABLE_SCHEM', CASE WHEN sys.schemas.name IN ('dbo', 'guest','INFORMATION_SCHEMA','sys','db_owner', 'db_accessadmin', 'db_securityadmin', 'db_ddladmin' ,'db_backupoperator','db_datareader', 'db_datawriter','db_denydatareader','db_denydatawriter') THEN null ELSE DB_NAME() END 'TABLE_CATALOG' from sys.schemas order by 2, 1

The sql also failed in ssms. I wonder if there is any compatibility issue between mssql jdbc and Azure sql engine?

Erland Sommarskog 102.5K Reputation points

2024-05-15T11:21:05.25+00:00

The query in your post runs successfully when I try it from SSMS, both against SQL 2022 and Azure SQL Database. Can you check that you have the exact query that is failing?
Oury Ba-MSFT 16,901 Reputation points Microsoft Employee

2024-05-17T18:14:07.9266667+00:00

@Susan Thank you for reaching out.

Could you please go through the below doc

https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-java?view=azuresql

Regards,

Oury

Share via

"The multi-part identifier "sys.schemas.name" could not be bound.