Open
Description
Driver version or jar name
mssql-jdbc-6.2.1.jre8
SQL Server version
Azure Sql 13
Client operating system
windows
Java/JVM version
Example: java version "1.8.0_65
Table schema
Problem description
Procedure schema name contain delimitter like ;1 with procedure name
This is giving issue while fetching param using procedure name.
Following error is coming with jar
org.springframework.dao.InvalidDataAccessApiUsageException: Unable to determine the correct call signature - no procedure/function/signature for 'uspGetAllVideosByUsername;1'
Expected behavior and actual behavior
We should be able to fetch procedurename without any delimited
Repro code
connection = datasource.getConnection();
long currTs = System.currentTimeMillis();
DatabaseMetaData metaData = connection.getMetaData();
log.debug("Metadata call in " + (System.currentTimeMillis() - currTs) + " ms");
currTs = System.currentTimeMillis();
ResultSet tables = metaData.getProcedures(connection.getCatalog(), getSchemaString(), null);
log.debug("GetProcedures call in " + (System.currentTimeMillis() - currTs) + " ms");
String procedureName=tables.getString(3));
Metadata
Metadata
Assignees
Type
Projects
Status
Backlog