Configuring validations data source files in Jboss

Certified Associate Developer

Hi,

 

We are migrating Appian from 7.6 to 17.2. We are using Jboss as the application server and database is SQL server. As per Jboss documentation its a good practice to have validation check in the data source file. Below is the snippet of the tag used.

<validation>
      <check-valid-connection-sql>Select 1</check-valid-connection-sql>
      <validate-on-match>true</validate-on-match>
      <background-validation>false</background-validation>
</validation>

When we start Jboss it starts but has below warning due to the validations.


19:49:46,195 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (JCA PoolFiller) IJ000610: Unable to fill pool: javax.resource.ResourceException: No matching credentials in Subject!
 at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getConnectionProperties(BaseWrapperManagedConnectionFactory.java:965)
 at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:498)
 at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1.run(XAManagedConnectionFactory.java:414)
 at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1.run(XAManagedConnectionFactory.java:411)
 at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0_144]
 at javax.security.auth.Subject.doAs(Subject.java:422) [rt.jar:1.8.0_144]
 at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:410)
 at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:858) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
 at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.fillToMin(SemaphoreArrayListManagedConnectionPool.java:801) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
 at org.jboss.jca.core.connectionmanager.pool.mcp.PoolFiller.run(PoolFiller.java:97) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
 at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_144]

Can you please suggest how validation should be defined in ds file?

Thanks in Advance.

  Discussion posts and replies are publicly visible