Skip to main content
Kofax

RPA version 11 Kapplets application not working with SQL server

3022477

Question / Problem: 

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. 

Answer / Solution: 

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 -->
 <WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/kapow/kapplets" auth="Container" type="javax.sql.DataSource"
 maxActive="100" maxIdle="30" maxWait="-1" 
 testOnBorrow="true"
 username="<DB username>" 
 password="<DB password>"   
 driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
 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.MySQL8Dialect" type="java.lang.String" override="false"/>
 <Environment name="kapplets.services.mc.connection.url" value="http://<IP address>:8080/ManagementConsole/" type="java.lang.String" override="false"/>
 <Environment name="kapplets.services.mc.connection.username" value="<MC username>" type="java.lang.String" override="false"/>
 <Environment name="kapplets.services.mc.connection.password" value="<MC password>" type="java.lang.String" override="false"/>
</Context>
 

Applies to:  

Product Version
RPA 11