存储过程 急啊!!!
调用查询的存储过程:
cstmt = conn.prepareCall(sql, ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
存储过程:
CREATE PROCEDURE departmentList AS
begin
select * from Department
select * from Position
end
GO
不加:ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY这个就会出错
这是怎么回事,大侠帮忙!!!
还有一个存储过程能返回多个记录集怎么弄,请指教!!
错误:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC](Internal Error) Message not found.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.getCachedRow(Unknown Source)
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.positionCursor(Unknown Source)
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.postSetupInitialize(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonGetNextResultSet(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at com.lycSoft.wlms.dataHandle.LoginHandle.departementList(LoginHandle.java:40)
at com.lycSoft.wlms.dataHandle.LoginHandle.main(LoginHandle.java:63)