SQL Error: 170, SQLState: HY000

1、环境：数据库  sql  server

                  web服务器 tomcat

                 连接数据库用的是hibernate访问数据库

2、问题描述：

SQL Error: 170, SQLState: HY000
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '-' 附近有语法错
误。
SQL Error: 16945, SQLState: HY000
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]游标未声明。
Hibernate: select tproduct0_.nId as nId, tproduct0_.nMinIndustryId as nMinIndu2_
12_, tproduct0_.vProName as vProName12_, tproduct0_.dUpdateTime as dUpdateT4_12_
, tproduct0_.nProType as nProType12_, tproduct0_.nComUserId as nComUserId12_, tp
roduct0_.nEffectDays as nEffectD7_12_, tproduct0_.vProDesc as vProDesc12_, tprod
uct0_.nProNum as nProNum12_, tproduct0_.nCheckState as nCheckS10_12_, tproduct0_
.nRecommend as nRecommend12_, tproduct0_.vOther as vOther12_, tproduct0_.nTotalI
nduId as nTotalI13_12_, tproduct0_.vProKeyWord as vProKey14_12_, tproduct0_.nPro
KeyWordCoin as nProKey15_12_, tproduct0_.vProduceProAddress as vProduc16_12_, tp
roduct0_.mProPrice as mProPrice12_, tproduct0_.sMoneyType as sMoneyType12_, tpro
duct0_.sPayWay as sPayWay12_, tproduct0_.sTransportWay as sTransp20_12_, tproduc
t0_.sIsBusinessOppor as sIsBusi21_12_, tproduct0_.sIsIssued as sIsIssued12_, tpr
oduct0_.vProSpeci as vProSpeci12_, tproduct0_.vProPackDesc as vProPac24_12_, tpr
oduct0_.vProNature as vProNature12_, tproduct0_.mTotalCapital as mTotalC26_12_,
tproduct0_.nCircleTime as nCircle27_12_, tproduct0_.vTenderTime as vTender28_12_
 from lead21.dbo.tProduct tproduct0_ where tproduct0_.nProType=? and tproduct0_.
nTotalInduId=? order by tproduct0_.dUpdateTime desc
Hibernate: select tproduct0_.nId as nId, tproduct0_.nMinIndustryId as nMinIndu2_
12_, tproduct0_.vProName as vProName12_, tproduct0_.dUpdateTime as dUpdateT4_12_
, tproduct0_.nProType as nProType12_, tproduct0_.nComUserId as nComUserId12_, tp
roduct0_.nEffectDays as nEffectD7_12_, tproduct0_.vProDesc as vProDesc12_, tprod
uct0_.nProNum as nProNum12_, tproduct0_.nCheckState as nCheckS10_12_, tproduct0_
.nRecommend as nRecommend12_, tproduct0_.vOther as vOther12_, tproduct0_.nTotalI
nduId as nTotalI13_12_, tproduct0_.vProKeyWord as vProKey14_12_, tproduct0_.nPro
KeyWordCoin as nProKey15_12_, tproduct0_.vProduceProAddress as vProduc16_12_, tp
roduct0_.mProPrice as mProPrice12_, tproduct0_.sMoneyType as sMoneyType12_, tpro
duct0_.sPayWay as sPayWay12_, tproduct0_.sTransportWay as sTransp20_12_, tproduc
t0_.sIsBusinessOppor as sIsBusi21_12_, tproduct0_.sIsIssued as sIsIssued12_, tpr
oduct0_.vProSpeci as vProSpeci12_, tproduct0_.vProPackDesc as vProPac24_12_, tpr
oduct0_.vProNature as vProNature12_, tproduct0_.mTotalCapital as mTotalC26_12_,
tproduct0_.nCircleTime as nCircle27_12_, tproduct0_.vTenderTime as vTender28_12_
 from lead21.dbo.tProduct tproduct0_ where tproduct0_.nProType=? and tproduct0_.
nTotalInduId=? order by tproduct0_.dUpdateTime desc 

3、估计原因：

用hibernate进行分页时用到

        Query q = session.createQuery(sql);
        q.setFirstResult(startRow);
        q.setMaxResults(pageSize);
        list = q.list();

有可能是maxResult超出了所取的范围