Problem: JDBC'S Stored Procedure Empty ResultSet When Creating Tables

Prerequisites: this is a quick issue/solution blog and not an introduction to JDBC or Java. The Issue Whilst working on calling a Stored Procedure from our SQLServer, the stored procedure refused to return any data. When called from a database viewer (we use DBVisualizer) the SP works fine. The…