org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能对 nvarchar 调用方法。
### The error may exist in zzu/qg/mybatis/mapper/UserMapper.xml
### The error may involve zzu.qg.mybatis.mapper.UserMapper.findUserByInfo-Inline
### The error occurred while setting parameters
### SQL: select * from [user] WHERE user.sex = ?
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能对 nvarchar 调用方法。
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
.....
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 不能对 nvarchar 调用方法。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
......
报的sql语句出错，
我就进到数据库里面 ### SQL: select * from [user] WHERE user.sex = ? 测试sql语句
需要将 user.sex改为[user].sex
org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能对 nvarchar 调用方法。### The error may exist in zzu/qg/mybatis/m...
DECLARE @tableHTML N
VARCHAR
(MAX) ;
-- 获取当前系统时间,和数据统计的时间
set @d_nowdate = convert(datetime,convert(
varchar
(10),dateadd(day,-1,getdate()),120),120);
-- 如果有数据则发送
if exists (select top 1 * from t_table1(nolock) where d_rq=@d_nowdate)
begin
set @str_
Create PROCEDURE [dbo].[ENC_GetRangeTotalEnergy]
-- Add the parameters for the stored procedure here
@StartTime
sqlserver
char（1）类型字段查询出现‘‘报错 解决办法An error occurred while converting the char value to JDBC data typ
select g.id,number,g.name,c_Id,u_Id,c.name as category.u.name as
users from Goods as g,Category as c,Users as u where
c.id=c_Id and u.id=u_Id
提示错误：消息 258，级别 15，状态 1，第 1 行
不能
对
varchar
调用
方法
。
