topic Query Bug?MySQLSyntaxErrorException in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90359#M61525 <HTML><HEAD></HEAD><BODY><SPAN>Hi,all</SPAN><BR /><SPAN>When I inovk this method</SPAN><BR /><SPAN>repositoryService.createProcessDefinitionQuery().processDefinitionNameLike("%%");</SPAN><BR /><BR /><SPAN>then it throw a MySQLSyntaxErrorException</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR /><BR />org.apache.ibatis.exceptions.PersistenceException: <BR />### Error querying database.&nbsp; Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PD.NAME_ like '%%'' at line 9<BR />### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionCountByQueryCriteria_mysql-Inline<BR />### The error occurred while setting parameters<BR />### Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PD.NAME_ like '%%'' at line 9<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:80)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:72)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:201)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.ProcessDefinitionManager.findProcessDefinitionCountByQueryCriteria(ProcessDefinitionManager.java:52)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.ProcessDefinitionQueryImpl.executeCount(ProcessDefinitionQueryImpl.java:212)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:144)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>Caused by:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PD.NAME_ like '%%'' at line 9<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:867)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:238)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:112)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:78)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>why&nbsp; '%%'' my parameter is "%%"</SPAN><BR /><BR /><SPAN>THX!</SPAN></BODY></HTML> Tue, 19 Jun 2012 01:26:00 GMT croc1 2012-06-19T01:26:00Z Query Bug?MySQLSyntaxErrorException https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90359#M61525 Hi,allWhen I inovk this methodrepositoryService.createProcessDefinitionQuery().processDefinitionNameLike("%%");then it throw a MySQLSyntaxErrorExceptionorg.apache.ibatis.exceptions.PersistenceException: ### Error querying database.&nbsp; Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You hav Tue, 19 Jun 2012 01:26:00 GMT https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90359#M61525 croc1 2012-06-19T01:26:00Z Re: Query Bug?MySQLSyntaxErrorException https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90360#M61526 <HTML><HEAD></HEAD><BODY><SPAN>The additional ' is added in the mysql stack trace message. You can't actually do 'LIKE %%', because that just matches everything… You should have at least ONE non-wildcard character in the parameter…</SPAN></BODY></HTML> Wed, 20 Jun 2012 07:24:57 GMT https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90360#M61526 frederikherema1 2012-06-20T07:24:57Z