rt,
我的sqlmap:
<select id="procGetUser" statementType="CALLABLE"
resultType="evcs.model.User">
{ call getUserProc ()}
</select>
我的java调用:
User us= new User();
SqlSession session= getSqlSession();
us = (User)session.selectOne("UserMapper.procGetUser");
我的存储过程
[code=sql][/
CREATE procedure [dbo].[getUserProc]
AS
select
* FROM
evcsdb.dbo.[User]
WHERE username ='wzl' collate Chinese_PRC_CS_AI
and password='wzl' collate Chinese_PRC_CS_AI;
GO
code]
但是一直调用不成功提示如下错误信息:
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
### The error may exist in evcs/data/UserSqlMap.xml
### The error may involve UserMapper.procGetUser-Inline
### The error occurred while setting parameters
### SQL: call getUserProc (?,?)
这是什么问题?