On my current project I must deal with another darkside of proprietary software. In this project I use Microsoft SQL Server 2000 – 8.00.760 (Intel X86) with Microsoft SQL Server 2005 JDBC Driver 1.2 and ended up with this stacktrace:

com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)


OTOH, when I use JTDS Driver I didn’t get any error at all. The problem is that MS SQL JDBC driver can not get a result set from a stored procedures. How come others made a MS SQL JDBC driver better than Microsoft themselves? *sigh*