@gstojsic thank you very much for your contribution. As a design decision, we decided to support TVP with setStructured() method only. So, TVP does not work with setObject()

The fix that you provided is a real fix for the case with stored procedure. We can get the TVP schema from stored procedure. However, TVP should work with Prepared Statement (without stored procedure) as well. With Prepared Statement, setObject() does not work with ResultSet.

I did not really understand the point of your comment. The fix is really for the case with the stored procedure which now does not work properly because it takes only the type name into account without the schema. The fix does not affect the Prepared statement case. Did you want me to provide the fix for the Prepared statement also?

Also I did not understand the first part. TVP's are handled in setObject methods as I can see from the source code. For example:
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement#setObject(int, java.lang.Object)
which is an implementation of java.sql.PreparedStatement#setObject(int, java.lang.Object) calls:
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement#setObjectNoType
which has a line:
if (JavaType.TVP == javaType)
that is obviously meant to handle TVP's. Did you mean you will be removing TVP handling from setObject() methods?

@gstojsic I have talked with our team here, we all think the fix that you provided is great and we really appreciate it. After testing is done on our side, we will accept your PR and make TVP support setObject() with stored procedure. Also, thanks for pointing out we have implemented setObject() to handle TVP in the source code, we will make some changes there, to throw exception explicitly when setObject() is used with ResultSet.

hello @gstojsic we very appreciate your idea on how to fix this issue, it is awesome. however, the fix is causing regression failures on our test lab. We will look into those regression failures and provide another fix based on your idea. For now, we are going to close this PR. Thank you again.