Question

急！！mybatis 参数解析不了 ERROR: LIMIT #,# syntax is not supported

org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: LIMIT #,# syntax is not supported
### The error may exist in usertracker/introns/persistence/data/CurrentUserMapper.xml
### The error may involve usertracker.introns.persistence.data.CurrentUserMapper.selectPartFieldAndLimit-Inline
### The error occurred while setting parameters
### SQL: select siteid, year, day, sessionid, referce, searcher, keywords, referceurl, ismobile, os, browser, java, cookie, ip, country, province, city, net, pv, pages, visits, isnew_visitors, lasttime, starttime, starturl, endtime, endurl, nodeid from ut_current_user Limit ?,?
### Cause: org.postgresql.util.PSQLException: ERROR: LIMIT #,# syntax is not supported
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: LIMIT #,# syntax is not supported

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)
at com.sun.proxy.$Proxy6.selectList(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:194)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:114)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)

Answer 1

limit #，#是mysql支持的语法，看提示mybatis并不支持，但估计有类似的语法，你可以查下，想不抱错的话，直接用limit #应该是可以的，如果要设置偏移量可以试试：limit 5 offset 0（参考postgres语法）。

Answer 2

那两个#换成数字，如 0,10