我在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:该语句未返回结果集。
发布于 2018-08-24 03:56:31
您的存储过程有许多问题。但实际上并不返回任何数据。在将结果发送到客户端之前,您是RETURNing。
应该是这样的:
create procedure [dbo].[prSum]
AS
begin
set nocount on;
declare @SUM table (
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;
Select * from @SUM;
return;
end
GO
https://stackoverflow.com/questions/51993128
复制相似问题