Revisit DatabaseMetadata#getProcedures to only apply fallback if original search yield more than one result

[audunmeltzer]

Affects: \spring-jdbc 6.1.2

---

Upgrade from spring-jdbc 6.1.1 to 6.1.2 does not support schema name with underscore, ie 'schema_name'. When execute procedure call.

SimpleJdbcCall(dataSource) .withSchemaName("schema_name") .withFunctionName("updateName") .declareParameters( SqlParameter("id", Types.VARCHAR), SqlParameter("name", Types.VARCHAR)) .execute(MapSqlParameterSource(mapOf("id" to id, "name" to newName)))
Exception thrown
org.springframework.dao.InvalidDataAccessApiUsageException: Required input parameter 'RETURN_VALUE' is missing

[jhoeller]

@snicoll is this possibly a regression caused by #22725?

[snicoll]

Thanks for reporting this and sorry the upgrade broke your use case.

Upgrade from spring-jdbc 6.1.1 to 6.1.2 does not support schema name with underscore, ie 'schema_name'. When execute procedure call.

_ is a special character that means "any character". The related issue that Juergen shared made sure that those special characters are escaped so that the search is against _ and not any character.

It looks like that doesn't work for you but we can't really know why. What database is this? Can you share a small sample we can run ourselves to reproduce the problem as it may be specific to your environment. You can attach a zip here or push the code to a GitHub repository.

[audunmeltzer]

I will create a simple project to illustrate the problem

We are using image mcr.microsoft.com/mssql/server:2017

[snicoll]

Thanks very much. Since you mention an image, adding a Docker compose or similar to setup the database in the sample will be very much appreciated as I suspect this might be key to the issue here.

[audunmeltzer]

I have created a simple repo that hopefully illustrates our issue, and might help find a soultion
https://github.com/ks-no/spring-jdbc-demo

As described in readme file, I have created different branches witch combines test with different spring-boot versions and schema name with and without underscore '_'. There is one test that calls a procedure that will run or fail on different branches