Skip to main content

RPA version 11 Kapplets application not working with SQL server

Article # 3035388 - Page views: 162


I am trying to setup Kofax RPA version 11 on SQL server. The Management Console on Tomcat is working. But it cannot start the Kapplets service. 

The following error message is written to the log file:

org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [See nested exception: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]


In case of SQL server, please add the SelectMethod=cursor parameter in your kapplets.xml

Example of kapplets.xml:

<Context useHttpOnly="true">
 <!-- Default set of monitored resources -->
<Resource name="jdbc/kapow/kapplets" auth="Container" type="javax.sql.DataSource"
 maxActive="100" maxIdle="30" maxWait="-1" 
 username="<DB username>" 
 password="<DB password>"   
 validationQuery="SELECT 1" url="jdbc:sqlserver://<IP address>:1433;DatabaseName=KAPOW_KAPPLETS;SelectMethod=cursor"/> 
 <Environment name="spring.datasource.jndi-name" value="jdbc/kapow/kapplets" type="java.lang.String" override="false"/>
 <Environment name="spring.jpa.database-platform" value="org.hibernate.dialect.SQLServer2012Dialect" type="java.lang.String" override="false"/>
 <Environment name="" value="http://<IP address>:8080/ManagementConsole/" type="java.lang.String" override="false"/>
 <Environment name="" value="<MC username>" type="java.lang.String" override="false"/>
 <Environment name="" value="<MC password>" type="java.lang.String" override="false"/>


Level of Complexity 



Applies to  

Product Version Build Environment Hardware
Kofax RPA 11      


Add any references to other internal or external articles


Article # 3035388
  • Was this article helpful?