nutzdao mysql_NutzDao用在MSSQL 分页查询的问题

2015 11 25 15:12:53,618 WARN org.nutz.dao.jdbc.Jdbcs:159 - Can not support database 'Microsoft SQL Server 12.00.2269', fallback to MySql 5

org.nutz.dao.DaoException: org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM Ifw_Order WHERE OrderID LIKE ? OR OrderUID LIKE ? OR ClientID LIKE ? OR ClientName LIKE ? ORDER BY OrderDate DESC LIMIT 0, 8

| 1 | 2 | 3 | 4 |

|--------|--------|--------|--------|

| %7111% | %7111% | %7111% | %7111% |

For example:> "SELECT * FROM Ifw_Order WHERE OrderID LIKE '%7111%' OR OrderUID LIKE '%7111%' OR ClientID LIKE '%7111%' OR ClientName LIKE '%7111%' ORDER BY OrderDate DESC LIMIT 0, 8 "'

PreparedStatement:

'SELECT * FROM Ifw_Order WHERE OrderID LIKE ? OR OrderUID LIKE ? OR ClientID LIKE ? OR ClientName LIKE ? ORDER BY OrderDate DESC LIMIT 0, 8 '

at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:76)

at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:204)

at org.nutz.dao.impl.NutDao.query(NutDao.java:419)

at com.gisuni.client.dao.Ifw_OrderDao.queryIfw_OrderByWhere(Ifw_OrderDao.java:158)

at com.gisuni.client.service.Ifw_OrderService.queryIfw_OrderByWhere(Ifw_OrderService.java:52)

at com.gisuni.client.controller.Ifw_OrderController.queryIfw_OrderByWhere(Ifw_OrderController.java:64)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)