topic Activiti 5.10 and mssql in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92636#M63319 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm using the new version activti 5.10 with mssql and got this error:</SPAN><BR /><BR /><SPAN>EXCEPTION__<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'LIMIT'.</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/ProcessDefinition.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionsByQueryCriteria-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select PD.*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ACT_RE_PROCDEF PD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; PD.VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = PD.KEY_)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LIMIT ? OFFSET ?</SPAN><BR /><SPAN>### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'LIMIT'.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:216)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:195)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.ProcessDefinitionManager.findProcessDefinitionsByQueryCriteria(ProcessDefinitionManager.java:51)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.ProcessDefinitionQueryImpl.executeList(ProcessDefinitionQueryImpl.java:230)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:138)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.list(AbstractQuery.java:112)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.process.activiti.deployment.ProcessRepositoryHandler.getProcessDefinitions(ProcessRepositoryHandler.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor177.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy73.getProcessDefinitions(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.process.activiti.deployment.ProcessDeploymentHandler.getProcessDefinitionListLatestVersions(ProcessDeploymentHandler.java:69)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy74.getProcessDefinitionListLatestVersions(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.process.activiti.deployment.TenantAwareProcessDeploymentHandler.getProcessDefinitionListLatestVersions(TenantAwareProcessDeploymentHandler.java:34)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy74.getProcessDefinitionListLatestVersions(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.process.permissions.ProcessPermissionInfoProvider.getPermissionInfos(ProcessPermissionInfoProvider.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy106.getPermissionInfos(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.kernel.permissions.ChainedPermissionInfoProvider.getPermissionInfos(ChainedPermissionInfoProvider.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy106.getPermissionInfos(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.kernel.authentication.LowLevelUserDriver.findPermissionsToAssign(LowLevelUserDriver.java:90)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.kernel.authentication.LowLevelUserDriver.access$200(LowLevelUserDriver.java:36)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.kernel.authentication.LowLevelUserDriver$1.doInTransactionWithoutResult(LowLevelUserDriver.java:71)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at de.vps.act.kernel.authentication.LowLevelUserDriver.insertUser(LowLevelUserDriver.java:64)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.MethodExecutor.callMethod(MethodExecutor.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.MethodExecutor.invokeMethod(MethodExecutor.java:30)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.MethodExecutor.findAndInvoke(MethodExecutor.java:53)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.LibraryMethodExecutor.execute(LibraryMethodExecutor.java:17)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.StatementExecutor.getMethodExecutionResult(StatementExecutor.java:207)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.StatementExecutor.call(StatementExecutor.java:197)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.Statement.callMethodAtIndex(Statement.java:99)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.Statement.call(Statement.java:92)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.Statement.execute(Statement.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.ListExecutor.execute(ListExecutor.java:36)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.SlimServer.executeInstructions(SlimServer.java:93)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.SlimServer.processTheInstructions(SlimServer.java:78)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.SlimServer.processOneSetOfInstructions(SlimServer.java:69)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.SlimServer.tryProcessInstructions(SlimServer.java:55)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.slim.SlimServer.serve(SlimServer.java:30)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at fitnesse.socketservice.SocketService$ServerRunner.run(SocketService.java:95)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:662)</SPAN><BR /><SPAN>Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'LIMIT'.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:320)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 107 more</SPAN><BR /><BR /><SPAN>Is this maybe a bug ?</SPAN><BR /><BR /><SPAN>Greets and regards</SPAN></BODY></HTML> Wed, 15 Aug 2012 15:18:32 GMT teldec 2012-08-15T15:18:32Z Activiti 5.10 and mssql https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92636#M63319 Hi,I'm using the new version activti 5.10 with mssql and got this error:EXCEPTION__<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.apache.ibatis.exceptions.PersistenceException: ### Error querying database.&nbsp; Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'LIMIT'.### The error may exist in org/activiti/db/mappin Wed, 15 Aug 2012 15:18:32 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92636#M63319 teldec 2012-08-15T15:18:32Z Re: Activiti 5.10 and mssql https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92637#M63320 <HTML><HEAD></HEAD><BODY><SPAN>Mysql? In the stacktrace there is something about mssql… Mickeysoft…</SPAN></BODY></HTML> Wed, 15 Aug 2012 15:38:21 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92637#M63320 ronald_van_kuij 2012-08-15T15:38:21Z Re: Activiti 5.10 and mssql https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92638#M63321 <HTML><HEAD></HEAD><BODY><SPAN>Yeah indeed you are right I mixed it up. </SPAN><BR /><SPAN>It must be mssql sorry <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></SPAN></BODY></HTML> Wed, 15 Aug 2012 18:18:39 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92638#M63321 teldec 2012-08-15T18:18:39Z Re: Activiti 5.10 and mssql https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92639#M63322 <HTML><HEAD></HEAD><BODY><SPAN>Now I added an issue at jira </SPAN><A href="http://jira.codehaus.org/browse/ACT-1349" rel="nofollow noopener noreferrer">http://jira.codehaus.org/browse/ACT-1349</A><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Fri, 24 Aug 2012 09:24:05 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-5-10-and-mssql/m-p/92639#M63322 teldec 2012-08-24T09:24:05Z