我在sql server中有以下存储过程:
create procedure [dbo].[prSum]
AS
create table @SUM (
ClientName Varchar(40),
SearchDoc Varchar(20),
SearchName Varchar(20),
)
--each one of this procedures returns a query with the same colunms size of @SUM
insert into @SUM exec pr1
insert into @SUM exec pr2
insert into @SUM exec pr3
insert into @SUM exec pr4
insert into @SUM exec pr5
RETURN Select * from @SUM
GO
在SSMS中,我可以运行:
exec prSum
并显示Select * from @SUM。
但是我尝试用jdbc在我的java类上获得以下代码:
package calc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnectURL {
public static void main(String[] args) {
String connectionUrl = "jdbc:sqlserver://######;databaseName=####;user=#####;password=###;
try (Connection con = DriverManager.getConnection(connectionUrl); Statement stmt = con.createStatement();) {
String SQL = "{ call dbo.prSum}";
ResultSet rs = stmt.executeQuery(SQL);
while (rs.next()) {
System.out.println(rs.getString("ClientName"));
}
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
获取并获取以下内容:
com.microsoft.sqlserver.jdbc.SQLServerException:该语句未返回结果集。
https://stackoverflow.com/questions/51993128
复制相似问题