java 调用sqlserver函数调用_从JDBC,Java调用Sqlserver存储过程

我可以从toad sql server运行此查询.

exec msp_FormBsBa_yeni 0,'20150101','20150131',5000,0,2,0,null,1,null,0

从我在java中的应用程序,它生成错误,因为该语句没有返回结果集.我尝试了很多东西,但我无法解决它.谢谢您的帮助.

// Connection,Resultset ve PrepStatement Declaration

Connection connection = null;

PreparedStatement pstmt = null;

ResultSet rsa = null;

List listrows = new ArrayList();

try {

connection = ConnectionFactory.getConnection();

CallableStatement callableStatement = connection

.prepareCall("{call msp_FormBsBa_yeni(0,N'20150101',N'20150131',5000,0,2,0,null,1,null,0)}");

rsa = callableStatement.executeQuery();

// 2:resultset check

if (!rsa.next()) {

System.out.println("no data");

} else {

do {

// System.out.println("data exists");</