Skip to content

Procedure name is appended with delimitter ;1  #448

Open
@vishal98

Description

@vishal98

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

No one assigned

    Labels

    EnhancementAn enhancement to the driver. Lower priority than bugs.

    Type

    No type

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions