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)