Need to execute stored procedure on a specific shard

[ekansh]

Hi
I am in the process of vetting Sharding Sphere in my company and during the POC I have stuck at the following situation :

Problem: Sharding Sphere executes Stored Procedure on a randomly chosen shard.
Question: So I would like to ask Sharding Sphere:

1. Given a shard key and its value, return the shard where a query should execute.
2. Now execute the Stored Procedure on the shard evaluated in step 1.
   How can I do that?

I checked HintManager but that didn't work for stored process. If HintManager is the solution, would you have a code snippet on how to configure HintManager without the YAML file ?

My project configuration :
Sharding Sphere JDBC 5.4.1
JDK 11 ( no spring/ hibernate, just plain JDBC)
DB : SQL Server 2022