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