search

microsoft / mssql-jdbc

The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity with SQL Server through the standard JDBC application program interfaces (APIs).
MIT License
1.05k stars 425 forks source link

getWarnings() method does not pass sysout messages to output stream for resultsets. #2168

Open ramanathnayak opened 1 year ago

ramanathnayak commented 1 year ago

Currently getWarnings method is not supported for resultsets. We would like to see if this feature can be added for upcoming releases.

We are using JDBC to call a Java Stored procedure(SP) in Sql Server. We are logging a few events inside the SP. The SP is returning a result set. However we are unable to retrive the logs as getWarnings method is currently not supported for resultsets.

Describe the preferred solution

getWarnings method to return the streaming information in case of an resultset return.

Describe alternatives you've considered

Alternatives would be to use a messaging queue to log the messages,however it is cumbersome.

tkyc commented 1 year ago

Marking this as an enhancement/feature. Our team will triage this in our next semester planning.