Hi,
We are using Apache Jackrabbit (org.apache.jackrabbit : jackrabbit-core:2.1.1)
as a content repository, along with Apache Sling (org.apache.sling:
org.apache.sling.launchpad.base:2.3.0).
This is running on Wildfly 20 and uses Oracle 12c as the database.
We are seeing database connection exhaust issue while running this.
Attached is the error.txt file with the exception details.
We tried using connection pooling as suggested in the below links, still the
issue persists.
https://jackrabbit.apache.org/archive/wiki/JCR/ConnectionPooling_115513384.html
https://jackrabbit.apache.org/archive/wiki/JCR/UsingJNDIDataSource_115513523.html
Also attached are the repository XMLs for your reference.
repository-org.xml ---> Existing one
repository-jndi.xml ---> Using JNDI Data Source Configuration
standalone.xml --> Wildfly configuration
repository-datasource.xml --> Using Datasource Configuration.
Let me know if any further details are required.
Thanks & Regards,
Prasad Shembekar
Mobile: +91-9821307006
Majesco and each of its affiliates (the "companies") do not accept any
liability for the content of this e-mail. Any views or opinions expressed in
the e-mail are solely those of the author and/or sender and not those of the
companies unless expressly stated otherwise. This e-mail and any attachments
are confidential and are intended solely for the use of the person and/or
entity to whom they are addressed. Any unauthorized review, use, forwarding,
printing, copying, disclosure or distribution of the information contained in
this e-mail is strictly prohibited unless expressly stated otherwise. If you
have received this e-mail in error, please notify the sender by e-mail and
kindly delete this e-mail from your computer system. Communications sent to and
from any of the companies may be monitored. Internet communications cannot be
guaranteed to be secure or error-free as information could be intercepted,
corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. None
of the companies accept responsibility for any errors or omissions that are
present in this communication, including in any attachment, that have arisen as
a result of e-mail transmission. If verification is required, please contact
the sender and request a hard-copy version. ClaimVantage Corporation Limited, a
subsidiary of Majesco, is registered in Ireland No: 412042; VAT No: IE6432042E;
registered office: Suite 511, Q House, 76 Furze Road, Sandyford, Dublin 18,
Ireland. Majesco UK Limited (a subsidiary of Majesco); is registered in the
United Kingdom No: 9276969; VAT No: 199293056; registered office: 211 New
London House, 6 London Street, London, England EC3R 7LP.
26.10.2022 02:53:33.532Â ERRORÂ [10.184.113.133Â [1666767211999]Â POST
/sling/home/mic/mic%20docs/LX/QUOTE/1/0/1/7/7/6/9/2/Q02CA0101776921/000
HTTP/1.1] org.apache.jackrabbit.core.util.db.DbUtility failed to close Statement
ï¾
Line 241815:
26.10.2022 02:53:35.120Â ERRORÂ [ObservationManager]Â
org.apache.jackrabbit.core.util.db.ConnectionHelper Failed to execute SQL
(stacktrace on DEBUG log level) java.sql.SQLException: Listener refused the
connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol
stack
<?xml version = '1.0' encoding = 'UTF-8'?>
<!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file
distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under
the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may
obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to
in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF
ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under
the License. -->
<Repository>
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="driver" value="oracle.jdbc.OracleDriver" />
<param name="url" value="jdbc:oracle:thin:@{ip iddress}:1521:{SID}" />
<param name="user" value="{schema-name}" />
<param name="password" value="{schema-name}" />
<param name="schemaObjectPrefix" value="" /> <!-- CMS Repository FileSystem -->
</FileSystem>
<DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
<param name="url" value="jdbc:oracle:thin:@{ip iddress}:1521:{SID}" />
<param name="user" value="{schema-name}" />
<param name="password" value="{schema-name}" />
<param name="databaseType" value="oracle" />
<param name="driver" value="oracle.jdbc.OracleDriver" />
<param name="minRecordLength" value="0" />
<param name="maxConnections" value="20" />
<param name="copyWhenReading" value="true" />
<param name="tablePrefix" value="" />
<param name="schemaObjectPrefix" value="" />
</DataStore>
<Cluster id="{ip iddress}" syncDelay="4000">
<Journal class="org.apache.jackrabbit.core.journal.OracleDatabaseJournal">
<param name="revision" value="${rep.home}/revision.log" />
<param name="driver" value="oracle.jdbc.OracleDriver" />
<param name="databaseType" value="oracle" />
<param name="url" value="jdbc:oracle:thin:@{ip iddress}:1521:{SID}" />
<param name="user" value="{schema-name}" />
<param name="password" value="{schema-name}" />
<param name="janitorEnabled" value="true"/>
</Journal>
</Cluster>
<Security appName="Jackrabbit">
<SecurityManager class="org.apache.jackrabbit.core.DefaultSecurityManager" workspaceName="security">
</SecurityManager>
<AccessManager class="org.apache.sling.jcr.jackrabbit.server.impl.security.PluggableDefaultAccessManager">
</AccessManager>
<LoginModule class="org.apache.sling.jcr.jackrabbit.server.impl.security.PluggableDefaultLoginModule">
<param name="anonymousId" value="anonymous" />
<param name="adminId" value="admin" />
</LoginModule>
</Security>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" />
<Workspace name="${wsp.name}">
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}" />
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.DerbyPersistenceManager">
<param name="url" value="jdbc:derby:${wsp.home}/db;create=true" />
<param name="schemaObjectPrefix" value="${wsp.name}_" />
<param name="shutdownOnClose" value="false" />
</PersistenceManager>
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index" />
<param name="supportHighlighting" value="true" />
</SearchIndex>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="driver" value="oracle.jdbc.OracleDriver" />
<param name="url" value="jdbc:oracle:thin:@{ip iddress}:1521:{SID}" />
<param name="schema" value="oracle" />
<param name="user" value="{schema-name}" />
<param name="password" value="{schema-name}" />
<param name="schemaObjectPrefix" value="" />
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.pool.OraclePersistenceManager">
<param name="driver" value="oracle.jdbc.OracleDriver" />
<param name="url" value="jdbc:oracle:thin:@{ip iddress}:1521:{SID}" />
<param name="schema" value="oracle" />
<param name="user" value="{schema-name}" />
<param name="password" value="{schema-name}" />
<param name="schemaObjectPrefix" value="" />
<param name="errorHandling" value="" />
<param name="bundleCacheSize" value="16" />
<!-- param name="consistencyCheck" value="true"/>
<param name="consistencyFix" value="true"/ -->
<param name="minBlobSize" value="0" />
</PersistenceManager>
</Versioning>
<!-- <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${rep.home}/repository/index" />
<param name="supportHighlighting" value="true" />
</SearchIndex> -->
</Repository><?xml version = '1.0' encoding = 'UTF-8'?>
<!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file
distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under
the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may
obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to
in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF
ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under
the License. -->
<Repository>
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:/jdbc/cms_common"/>
<param name="schemaObjectPrefix" value="" /> <!-- CMS Repository FileSystem -->
</FileSystem>
<DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:/jdbc/cms_common"/>
<param name="databaseType" value="oracle" />
<param name="minRecordLength" value="0" />
<param name="maxConnections" value="20" />
<param name="copyWhenReading" value="true" />
<param name="tablePrefix" value="" />
<param name="schemaObjectPrefix" value="" />
</DataStore>
<Cluster id="IND-MHP1V69W802" syncDelay="4000">
<Journal class="org.apache.jackrabbit.core.journal.OracleDatabaseJournal">
<param name="revision" value="${rep.home}/revision.log" />
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:/jdbc/cms_common"/>
<param name="databaseType" value="oracle" />
<param name="janitorEnabled" value="true"/>
</Journal>
</Cluster>
<Security appName="Jackrabbit">
<SecurityManager class="org.apache.jackrabbit.core.DefaultSecurityManager" workspaceName="security">
</SecurityManager>
<AccessManager class="org.apache.sling.jcr.jackrabbit.server.impl.security.PluggableDefaultAccessManager">
</AccessManager>
<LoginModule class="org.apache.sling.jcr.jackrabbit.server.impl.security.PluggableDefaultLoginModule">
<param name="anonymousId" value="anonymous" />
<param name="adminId" value="admin" />
</LoginModule>
</Security>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" />
<Workspace name="${wsp.name}">
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}" />
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.DerbyPersistenceManager">
<param name="url" value="jdbc:derby:${wsp.home}/db;create=true" />
<param name="schemaObjectPrefix" value="${wsp.name}_" />
<param name="shutdownOnClose" value="false" />
</PersistenceManager>
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index" />
<param name="supportHighlighting" value="true" />
</SearchIndex>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:/jdbc/cms_common"/>
<param name="schema" value="oracle" />
<param name="schemaObjectPrefix" value="" />
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.pool.OraclePersistenceManager">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:/jdbc/cms_common"/>
<param name="schema" value="oracle" />
<param name="schemaObjectPrefix" value="" />
<param name="errorHandling" value="" />
<param name="bundleCacheSize" value="16" />
<!-- param name="consistencyCheck" value="true"/>
<param name="consistencyFix" value="true"/ -->
<param name="minBlobSize" value="0" />
</PersistenceManager>
</Versioning>
<!-- <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${rep.home}/repository/index" />
<param name="supportHighlighting" value="true" />
</SearchIndex> -->
</Repository><?xml version="1.0" encoding="UTF-8"?><server xmlns="urn:jboss:domain:13.0">
<extensions>
<extension module="org.jboss.as.clustering.infinispan"/>
<extension module="org.jboss.as.connector"/>
<extension module="org.jboss.as.deployment-scanner"/>
<extension module="org.jboss.as.ee"/>
<extension module="org.jboss.as.ejb3"/>
<extension module="org.jboss.as.jaxrs"/>
<extension module="org.jboss.as.jdr"/>
<extension module="org.jboss.as.jmx"/>
<extension module="org.jboss.as.jpa"/>
<extension module="org.jboss.as.jsf"/>
<extension module="org.jboss.as.logging"/>
<extension module="org.jboss.as.mail"/>
<extension module="org.jboss.as.naming"/>
<extension module="org.jboss.as.pojo"/>
<extension module="org.jboss.as.remoting"/>
<extension module="org.jboss.as.sar"/>
<extension module="org.jboss.as.security"/>
<extension module="org.jboss.as.transactions"/>
<extension module="org.jboss.as.webservices"/>
<extension module="org.jboss.as.weld"/>
<extension module="org.wildfly.extension.batch.jberet"/>
<extension module="org.wildfly.extension.bean-validation"/>
<extension module="org.wildfly.extension.clustering.web"/>
<extension module="org.wildfly.extension.core-management"/>
<extension module="org.wildfly.extension.discovery"/>
<extension module="org.wildfly.extension.ee-security"/>
<extension module="org.wildfly.extension.elytron"/>
<extension module="org.wildfly.extension.io"/>
<extension module="org.wildfly.extension.microprofile.config-smallrye"/>
<extension module="org.wildfly.extension.microprofile.health-smallrye"/>
<extension module="org.wildfly.extension.microprofile.jwt-smallrye"/>
<extension module="org.wildfly.extension.microprofile.metrics-smallrye"/>
<extension module="org.wildfly.extension.microprofile.opentracing-smallrye"/>
<extension module="org.wildfly.extension.request-controller"/>
<extension module="org.wildfly.extension.security.manager"/>
<extension module="org.wildfly.extension.undertow"/>
</extensions>
<system-properties>
<property name="jboss.as.management.blocking.timeout" value="900"/>
</system-properties>
<paths>
<path name="coverall.home" path="E:\cover-all"/>
<path name="coverall.certs.dir" path="certs" relative-to="coverall.home"/>
</paths>
<vault>
<vault-option name="KEYSTORE_URL" value="E:\\Wildfly\\wildfly-20.0.1.Final\MajescoWF.store"/>
<vault-option name="KEYSTORE_PASSWORD" value="MASK-2x2Tjgffrntj0PD0j2VbwK"/>
<vault-option name="KEYSTORE_ALIAS" value="MajescoWF"/>
<vault-option name="SALT" value="ABCD1234"/>
<vault-option name="ITERATION_COUNT" value="95"/>
<vault-option name="ENC_FILE_DIR" value="E:\\Wildfly\\wildfly-20.0.1.Final\MajescoVault"/>
</vault>
<management>
<security-realms>
<security-realm name="ManagementRealm">
<authentication>
<local default-user="$local" skip-group-loading="true"/>
<properties path="mgmt-users.properties" relative-to="jboss.server.config.dir"/>
</authentication>
<authorization map-groups-to-roles="false">
<properties path="mgmt-groups.properties" relative-to="jboss.server.config.dir"/>
</authorization>
</security-realm>
<security-realm name="ApplicationRealm">
<server-identities>
<ssl>
<keystore alias="server" generate-self-signed-certificate-host="localhost" key-password="password" keystore-password="password" path="application.keystore" relative-to="jboss.server.config.dir"/>
</ssl>
</server-identities>
<authentication>
<local allowed-users="*" default-user="$local" skip-group-loading="true"/>
<properties path="application-users.properties" relative-to="jboss.server.config.dir"/>
</authentication>
<authorization>
<properties path="application-roles.properties" relative-to="jboss.server.config.dir"/>
</authorization>
</security-realm>
<security-realm name="SslRealm">
<server-identities>
<ssl>
<keystore alias="cover-all" keystore-password="${VAULT::Majesco::jkspass::1}" path="cover-all.jks" relative-to="coverall.certs.dir"/>
</ssl>
</server-identities>
</security-realm>
</security-realms>
<audit-log>
<formatters>
<json-formatter name="json-formatter"/>
</formatters>
<handlers>
<file-handler formatter="json-formatter" name="file" path="audit-log.log" relative-to="jboss.server.data.dir"/>
</handlers>
<logger enabled="false" log-boot="true" log-read-only="false">
<handlers>
<handler name="file"/>
</handlers>
</logger>
</audit-log>
<management-interfaces>
<http-interface security-realm="ManagementRealm">
<http-upgrade enabled="true"/>
<socket-binding http="management-http"/>
</http-interface>
</management-interfaces>
<access-control provider="simple">
<role-mapping>
<role name="SuperUser">
<include>
<user name="$local"/>
</include>
</role>
</role-mapping>
</access-control>
</management>
<profile>
<subsystem xmlns="urn:jboss:domain:logging:8.0">
<console-handler name="CONSOLE">
<level name="ERROR"/>
<formatter>
<named-formatter name="COLOR-PATTERN"/>
</formatter>
</console-handler>
<periodic-rotating-file-handler autoflush="true" name="FILE">
<formatter>
<named-formatter name="PATTERN"/>
</formatter>
<file path="server.log" relative-to="jboss.server.log.dir"/>
<suffix value=".yyyy-MM-dd"/>
<append value="true"/>
</periodic-rotating-file-handler>
<logger category="com.arjuna">
<level name="ERROR"/>
</logger>
<logger category="io.jaegertracing.Configuration">
<level name="ERROR"/>
</logger>
<logger category="org.jboss.as.config">
<level name="ERROR"/>
</logger>
<logger category="sun.rmi">
<level name="ERROR"/>
</logger>
<root-logger>
<level name="ERROR"/>
<handlers>
<handler name="CONSOLE"/>
<handler name="FILE"/>
</handlers>
</root-logger>
<formatter name="PATTERN">
<pattern-formatter pattern="%d{yyyy-MM-dd HH:mm:ss,SSS} %-5p [%c] (%t) %s%e%n"/>
</formatter>
<formatter name="COLOR-PATTERN">
<pattern-formatter pattern="%K{level}%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%e%n"/>
</formatter>
</subsystem>
<subsystem xmlns="urn:jboss:domain:batch-jberet:2.0">
<default-job-repository name="in-memory"/>
<default-thread-pool name="batch"/>
<job-repository name="in-memory">
<in-memory/>
</job-repository>
<thread-pool name="batch">
<max-threads count="10"/>
<keepalive-time time="30" unit="seconds"/>
</thread-pool>
</subsystem>
<subsystem xmlns="urn:jboss:domain:bean-validation:1.0"/>
<subsystem xmlns="urn:jboss:domain:core-management:1.0"/>
<subsystem xmlns="urn:jboss:domain:datasources:6.0">
<datasources>
<datasource enabled="true" jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" use-java-context="true">
<connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
</datasource>
<datasource jndi-name="java:/jdbc/system" jta="true" pool-name="system">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<initial-pool-size>0</initial-pool-size>
<max-pool-size>300</max-pool-size>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>system</user-name>
<password>${VAULT::Majesco::SYSTEM::1}</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource jndi-name="java:/jdbc/ca_installer" jta="true" pool-name="ca_installer">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<initial-pool-size>0</initial-pool-size>
<max-pool-size>300</max-pool-size>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>ca_installer</user-name>
<password>${VAULT::Majesco::ca_installer::1}</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource enabled="true" jndi-name="java:/jdbc/policy_studio_99" jta="true" pool-name="policy_studio_99" statistics-enabled="true">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<initial-pool-size>0</initial-pool-size>
<max-pool-size>300</max-pool-size>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>policy_studio_99</user-name>
<password>${VAULT::Majesco::policy_studio_99::1}</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource enabled="true" jndi-name="java:/jdbc/UTMDS_99" jta="true" pool-name="UTMDS_99" statistics-enabled="true">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<initial-pool-size>0</initial-pool-size>
<max-pool-size>300</max-pool-size>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>utm_99</user-name>
<password>${VAULT::Majesco::UTMDS_99::1}</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource enabled="true" jndi-name="java:/jdbc/suiteutil" jta="true" pool-name="suiteutil" statistics-enabled="true">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<initial-pool-size>0</initial-pool-size>
<max-pool-size>300</max-pool-size>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>suite_util</user-name>
<password>${VAULT::Majesco::suiteutil::1}</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource jndi-name="java:/jdbc/SYSTEM" jta="true" pool-name="SYSTEM">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<max-pool-size>300</max-pool-size>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>SYSTEM</user-name>
<password>${VAULT::Majesco::SYSTEM::1}</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource jndi-name="java:/jdbc/UES_99" jta="true" pool-name="UES_99">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<initial-pool-size>0</initial-pool-size>
<max-pool-size>300</max-pool-size>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>ues_99</user-name>
<password>${VAULT::Majesco::UES_99::1}</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource jndi-name="java:/jdbc/security/ns_idp" jta="true" pool-name="ns_idp">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<max-pool-size>300</max-pool-size>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>ns_idp</user-name>
<password>ns_idp</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource jndi-name="java:/jdbc/security/ns_99" jta="true" pool-name="ns_99">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<max-pool-size>300</max-pool-size>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>ns_99</user-name>
<password>ns_99</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
</datasource>
<datasource jta="true" jndi-name="java:/jdbc/cms_common" pool-name="cms_common" enabled="true" statistics-enabled="true">
<connection-url>jdbc:oracle:thin:@{ip iddress}:1521/{SID}</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>3</min-pool-size>
<max-pool-size>300</max-pool-size>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>cms_common</user-name>
<password>cms_common</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>true</use-fast-fail>
</validation>
<timeout>
<idle-timeout-minutes>10</idle-timeout-minutes>
</timeout>
</datasource>
<drivers>
<driver module="com.h2database.h2" name="h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver module="com.oracle.ojdbc8" name="oracle">
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>
<driver module="com.microsoft.sqlserver" name="mssql">
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
<subsystem xmlns="urn:jboss:domain:deployment-scanner:2.0">
<deployment-scanner deployment-timeout="900" path="deployments" relative-to="jboss.server.base.dir" runtime-failure-causes-rollback="${jboss.deployment.scanner.rollback.on.failure:false}" scan-interval="5000"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:discovery:1.0"/>
<subsystem xmlns="urn:jboss:domain:distributable-web:2.0" default-session-management="default" default-single-sign-on-management="default">
<infinispan-session-management cache-container="web" granularity="SESSION" name="default">
<primary-owner-affinity/>
</infinispan-session-management>
<infinispan-single-sign-on-management cache="sso" cache-container="web" name="default"/>
<infinispan-routing cache="routing" cache-container="web"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:ee:5.0">
<spec-descriptor-property-replacement>false</spec-descriptor-property-replacement>
<concurrent>
<context-services>
<context-service jndi-name="java:jboss/ee/concurrency/context/default" name="default" use-transaction-setup-provider="true"/>
</context-services>
<managed-thread-factories>
<managed-thread-factory context-service="default" jndi-name="java:jboss/ee/concurrency/factory/default" name="default"/>
</managed-thread-factories>
<managed-executor-services>
<managed-executor-service context-service="default" hung-task-threshold="60000" jndi-name="java:jboss/ee/concurrency/executor/default" keepalive-time="5000" name="default"/>
</managed-executor-services>
<managed-scheduled-executor-services>
<managed-scheduled-executor-service context-service="default" hung-task-threshold="60000" jndi-name="java:jboss/ee/concurrency/scheduler/default" keepalive-time="3000" name="default"/>
</managed-scheduled-executor-services>
</concurrent>
<default-bindings context-service="java:jboss/ee/concurrency/context/default" datasource="java:jboss/datasources/ExampleDS" managed-executor-service="java:jboss/ee/concurrency/executor/default" managed-scheduled-executor-service="java:jboss/ee/concurrency/scheduler/default" managed-thread-factory="java:jboss/ee/concurrency/factory/default"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:ee-security:1.0"/>
<subsystem xmlns="urn:jboss:domain:ejb3:7.0">
<session-bean>
<stateless>
<bean-instance-pool-ref pool-name="slsb-strict-max-pool"/>
</stateless>
<stateful cache-ref="simple" default-access-timeout="5000" passivation-disabled-cache-ref="simple"/>
<singleton default-access-timeout="5000"/>
</session-bean>
<pools>
<bean-instance-pools>
<strict-max-pool derive-size="from-cpu-count" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES" name="mdb-strict-max-pool"/>
<strict-max-pool derive-size="from-worker-pools" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES" name="slsb-strict-max-pool"/>
</bean-instance-pools>
</pools>
<caches>
<cache name="simple"/>
<cache aliases="passivating clustered" name="distributable" passivation-store-ref="infinispan"/>
</caches>
<passivation-stores>
<passivation-store cache-container="ejb" max-size="10000" name="infinispan"/>
</passivation-stores>
<async thread-pool-name="default"/>
<timer-service default-data-store="default-file-store" thread-pool-name="default">
<data-stores>
<file-data-store name="default-file-store" path="timer-service-data" relative-to="jboss.server.data.dir"/>
</data-stores>
</timer-service>
<remote connector-ref="http-remoting-connector" thread-pool-name="default">
<channel-creation-options>
<option name="MAX_OUTBOUND_MESSAGES" type="remoting" value="1234"/>
</channel-creation-options>
</remote>
<thread-pools>
<thread-pool name="default">
<max-threads count="10"/>
<keepalive-time time="60" unit="seconds"/>
</thread-pool>
</thread-pools>
<default-security-domain value="other"/>
<default-missing-method-permissions-deny-access value="true"/>
<statistics enabled="${wildfly.ejb3.statistics-enabled:${wildfly.statistics-enabled:false}}"/>
<log-system-exceptions value="true"/>
</subsystem>
<subsystem xmlns="urn:wildfly:elytron:10.0" disallowed-providers="OracleUcrypto" final-providers="combined-providers">
<providers>
<aggregate-providers name="combined-providers">
<providers name="elytron"/>
<providers name="openssl"/>
</aggregate-providers>
<provider-loader module="org.wildfly.security.elytron" name="elytron"/>
<provider-loader module="org.wildfly.openssl" name="openssl"/>
</providers>
<audit-logging>
<file-audit-log format="JSON" name="local-audit" path="audit.log" relative-to="jboss.server.log.dir"/>
</audit-logging>
<security-domains>
<security-domain default-realm="ApplicationRealm" name="ApplicationDomain" permission-mapper="default-permission-mapper">
<realm name="ApplicationRealm" role-decoder="groups-to-roles"/>
<realm name="local"/>
</security-domain>
<security-domain default-realm="ManagementRealm" name="ManagementDomain" permission-mapper="default-permission-mapper">
<realm name="ManagementRealm" role-decoder="groups-to-roles"/>
<realm name="local" role-mapper="super-user-mapper"/>
</security-domain>
</security-domains>
<security-realms>
<identity-realm identity="$local" name="local"/>
<properties-realm name="ApplicationRealm">
<users-properties digest-realm-name="ApplicationRealm" path="application-users.properties" relative-to="jboss.server.config.dir"/>
<groups-properties path="application-roles.properties" relative-to="jboss.server.config.dir"/>
</properties-realm>
<properties-realm name="ManagementRealm">
<users-properties digest-realm-name="ManagementRealm" path="mgmt-users.properties" relative-to="jboss.server.config.dir"/>
<groups-properties path="mgmt-groups.properties" relative-to="jboss.server.config.dir"/>
</properties-realm>
</security-realms>
<mappers>
<simple-permission-mapper mapping-mode="first" name="default-permission-mapper">
<permission-mapping>
<principal name="anonymous"/>
<permission-set name="default-permissions"/>
</permission-mapping>
<permission-mapping match-all="true">
<permission-set name="login-permission"/>
<permission-set name="default-permissions"/>
</permission-mapping>
</simple-permission-mapper>
<constant-realm-mapper name="local" realm-name="local"/>
<simple-role-decoder attribute="groups" name="groups-to-roles"/>
<constant-role-mapper name="super-user-mapper">
<role name="SuperUser"/>
</constant-role-mapper>
</mappers>
<permission-sets>
<permission-set name="login-permission">
<permission class-name="org.wildfly.security.auth.permission.LoginPermission"/>
</permission-set>
<permission-set name="default-permissions">
<permission class-name="org.wildfly.extension.batch.jberet.deployment.BatchPermission" module="org.wildfly.extension.batch.jberet" target-name="*"/>
<permission class-name="org.wildfly.transaction.client.RemoteTransactionPermission" module="org.wildfly.transaction.client"/>
<permission class-name="org.jboss.ejb.client.RemoteEJBPermission" module="org.jboss.ejb-client"/>
</permission-set>
</permission-sets>
<http>
<http-authentication-factory http-server-mechanism-factory="global" name="management-http-authentication" security-domain="ManagementDomain">
<mechanism-configuration>
<mechanism mechanism-name="DIGEST">
<mechanism-realm realm-name="ManagementRealm"/>
</mechanism>
</mechanism-configuration>
</http-authentication-factory>
<provider-http-server-mechanism-factory name="global"/>
</http>
<sasl>
<sasl-authentication-factory name="application-sasl-authentication" sasl-server-factory="configured" security-domain="ApplicationDomain">
<mechanism-configuration>
<mechanism mechanism-name="JBOSS-LOCAL-USER" realm-mapper="local"/>
<mechanism mechanism-name="DIGEST-MD5">
<mechanism-realm realm-name="ApplicationRealm"/>
</mechanism>
</mechanism-configuration>
</sasl-authentication-factory>
<sasl-authentication-factory name="management-sasl-authentication" sasl-server-factory="configured" security-domain="ManagementDomain">
<mechanism-configuration>
<mechanism mechanism-name="JBOSS-LOCAL-USER" realm-mapper="local"/>
<mechanism mechanism-name="DIGEST-MD5">
<mechanism-realm realm-name="ManagementRealm"/>
</mechanism>
</mechanism-configuration>
</sasl-authentication-factory>
<configurable-sasl-server-factory name="configured" sasl-server-factory="elytron">
<properties>
<property name="wildfly.sasl.local-user.default-user" value="$local"/>
</properties>
</configurable-sasl-server-factory>
<mechanism-provider-filtering-sasl-server-factory name="elytron" sasl-server-factory="global">
<filters>
<filter provider-name="WildFlyElytron"/>
</filters>
</mechanism-provider-filtering-sasl-server-factory>
<provider-sasl-server-factory name="global"/>
</sasl>
</subsystem>
<subsystem xmlns="urn:jboss:domain:infinispan:10.0">
<cache-container default-cache="passivation" module="org.wildfly.clustering.web.infinispan" name="web">
<local-cache name="passivation">
<file-store passivation="true" purge="false"/>
</local-cache>
<local-cache name="sso"/>
<local-cache name="routing"/>
</cache-container>
<cache-container default-cache="default" module="org.wildfly.clustering.server" name="server">
<local-cache name="default"/>
</cache-container>
<cache-container aliases="sfsb" default-cache="passivation" module="org.wildfly.clustering.ejb.infinispan" name="ejb">
<local-cache name="passivation">
<file-store passivation="true" purge="false"/>
</local-cache>
</cache-container>
<cache-container module="org.infinispan.hibernate-cache" name="hibernate">
<local-cache name="entity">
<object-memory size="10000"/>
<expiration max-idle="100000"/>
</local-cache>
<local-cache name="local-query">
<object-memory size="10000"/>
<expiration max-idle="100000"/>
</local-cache>
<local-cache name="timestamps"/>
</cache-container>
</subsystem>
<subsystem xmlns="urn:jboss:domain:io:3.0">
<worker io-threads="100" name="default" task-max-threads="2000"/>
<buffer-pool name="default"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jaxrs:2.0"/>
<subsystem xmlns="urn:jboss:domain:jca:5.0">
<archive-validation enabled="true" fail-on-error="true" fail-on-warn="false"/>
<bean-validation enabled="true"/>
<default-workmanager>
<short-running-threads>
<core-threads count="50"/>
<queue-length count="50"/>
<max-threads count="50"/>
<keepalive-time time="10" unit="seconds"/>
</short-running-threads>
<long-running-threads>
<core-threads count="50"/>
<queue-length count="50"/>
<max-threads count="50"/>
<keepalive-time time="10" unit="seconds"/>
</long-running-threads>
</default-workmanager>
<cached-connection-manager/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jdr:1.0"/>
<subsystem xmlns="urn:jboss:domain:jmx:1.3">
<expose-resolved-model/>
<expose-expression-model/>
<remoting-connector/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jpa:1.1">
<jpa default-datasource="" default-extended-persistence-inheritance="DEEP"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jsf:1.1"/>
<subsystem xmlns="urn:jboss:domain:mail:4.0">
<mail-session jndi-name="java:jboss/mail/Default" name="default">
<smtp-server outbound-socket-binding-ref="mail-smtp"/>
</mail-session>
</subsystem>
<subsystem xmlns="urn:wildfly:microprofile-config-smallrye:1.0"/>
<subsystem xmlns="urn:wildfly:microprofile-health-smallrye:2.0" empty-liveness-checks-status="${env.MP_HEALTH_EMPTY_LIVENESS_CHECKS_STATUS:UP}" empty-readiness-checks-status="${env.MP_HEALTH_EMPTY_READINESS_CHECKS_STATUS:UP}" security-enabled="false"/>
<subsystem xmlns="urn:wildfly:microprofile-jwt-smallrye:1.0"/>
<subsystem xmlns="urn:wildfly:microprofile-metrics-smallrye:2.0" exposed-subsystems="*" prefix="${wildfly.metrics.prefix:wildfly}" security-enabled="false"/>
<subsystem xmlns="urn:wildfly:microprofile-opentracing-smallrye:2.0" default-tracer="jaeger">
<jaeger-tracer name="jaeger">
<sampler-configuration sampler-param="1.0" sampler-type="const"/>
</jaeger-tracer>
</subsystem>
<subsystem xmlns="urn:jboss:domain:naming:2.0">
<remote-naming/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:pojo:1.0"/>
<subsystem xmlns="urn:jboss:domain:remoting:4.0">
<http-connector connector-ref="default" name="http-remoting-connector" security-realm="ApplicationRealm"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:request-controller:1.0"/>
<subsystem xmlns="urn:jboss:domain:resource-adapters:6.0"/>
<subsystem xmlns="urn:jboss:domain:sar:1.0"/>
<subsystem xmlns="urn:jboss:domain:security:2.0">
<security-domains>
<security-domain cache-type="default" name="other">
<authentication>
<login-module code="Remoting" flag="optional">
<module-option name="password-stacking" value="useFirstPass"/>
</login-module>
<login-module code="RealmDirect" flag="required">
<module-option name="password-stacking" value="useFirstPass"/>
</login-module>
</authentication>
</security-domain>
<security-domain cache-type="default" name="jboss-web-policy">
<authorization>
<policy-module code="Delegating" flag="required"/>
</authorization>
</security-domain>
<security-domain cache-type="default" name="jaspitest">
<authentication-jaspi>
<login-module-stack name="dummy">
<login-module code="Dummy" flag="optional"/>
</login-module-stack>
<auth-module code="Dummy"/>
</authentication-jaspi>
</security-domain>
<security-domain cache-type="default" name="jboss-ejb-policy">
<authorization>
<policy-module code="Delegating" flag="required"/>
</authorization>
</security-domain>
<security-domain cache-type="default" name="ns_idp_sd">
<authentication>
<login-module code="Database" flag="required">
<module-option name="dsJndiName" value="java:/jdbc/security/ns_idp"/>
<module-option name="principalsQuery" value="SELECT U_PASSWORD FROM USERS WHERE U_NAME = ?"/>
<module-option name="rolesQuery" value="SELECT G.G_NAME, NULL FROM GROUPMEMBERS GM,GROUPS G WHERE G.G_NAME = GM.G_NAME AND GM.G_MEMBER IN (SELECT U_NAME FROM USERS WHERE U_NAME = ?)"/>
<module-option name="hashAlgorithm" value="SHA-1"/>
<module-option name="hashEncoding" value="base64"/>
</login-module>
<login-module code="org.jboss.security.auth.spi.RoleMappingLoginModule" flag="optional">
<module-option name="rolesProperties" value="${jboss.server.config.dir}/rolesMapping-roles.properties"/>
</login-module>
</authentication>
</security-domain>
</security-domains>
</subsystem>
<subsystem xmlns="urn:jboss:domain:security-manager:1.0">
<deployment-permissions>
<maximum-set>
<permission class="java.security.AllPermission"/>
</maximum-set>
</deployment-permissions>
</subsystem>
<subsystem xmlns="urn:jboss:domain:transactions:5.0">
<core-environment node-identifier="${jboss.tx.node.id:1}">
<process-id>
<uuid/>
</process-id>
</core-environment>
<recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>
<coordinator-environment statistics-enabled="${wildfly.transactions.statistics-enabled:${wildfly.statistics-enabled:false}}"/>
<object-store path="tx-object-store" relative-to="jboss.server.data.dir"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:undertow:11.0" default-security-domain="other" default-server="default-server" default-servlet-container="default" default-virtual-host="default-host" statistics-enabled="${wildfly.undertow.statistics-enabled:${wildfly.statistics-enabled:false}}">
<buffer-cache name="default"/>
<server name="default-server">
<http-listener enable-http2="true" max-header-size="209715200" max-post-size="2097152000" name="default" redirect-socket="https" socket-binding="http"/>
<https-listener enabled-protocols="TLSv1,TLSv1.1,TLSv1.2" max-header-size="209715200" max-parameters="50000" max-post-size="2097152000" name="default-ssl" security-realm="SslRealm" socket-binding="https"/>
<host alias="localhost" name="default-host">
<location handler="welcome-content" name="/"/>
<access-log pattern="%A%t%h%l%u%r%s%b%T%I" prefix="access" suffix=".log"/>
<filter-ref name="server-header"/>
<filter-ref name="x-powered-by-header"/>
<http-invoker security-realm="ApplicationRealm"/>
</host>
</server>
<servlet-container name="default">
<jsp-config/>
<websockets/>
</servlet-container>
<handlers>
<file name="welcome-content" path="${jboss.home.dir}/welcome-content"/>
</handlers>
<filters>
<response-header header-name="Server" header-value="WildFly/10" name="server-header"/>
<response-header header-name="X-Powered-By" header-value="Undertow/1" name="x-powered-by-header"/>
</filters>
</subsystem>
<subsystem xmlns="urn:jboss:domain:webservices:2.0" statistics-enabled="${wildfly.webservices.statistics-enabled:${wildfly.statistics-enabled:false}}">
<wsdl-host>${jboss.bind.address:127.0.0.1}</wsdl-host>
<endpoint-config name="Standard-Endpoint-Config"/>
<endpoint-config name="Recording-Endpoint-Config">
<pre-handler-chain name="recording-handlers" protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM">
<handler class="org.jboss.ws.common.invocation.RecordingServerHandler" name="RecordingHandler"/>
</pre-handler-chain>
</endpoint-config>
<client-config name="Standard-Client-Config"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:weld:4.0"/>
</profile>
<interfaces>
<interface name="management">
<any-address/>
</interface>
<interface name="public">
<any-address/>
</interface>
</interfaces>
<socket-binding-group default-interface="public" name="standard-sockets" port-offset="${jboss.socket.binding.port-offset:0}">
<socket-binding name="ajp" port="${jboss.ajp.port:8009}"/>
<socket-binding name="http" port="${jboss.http.port:80}"/>
<socket-binding name="https" port="${jboss.https.port:443}"/>
<socket-binding interface="management" name="management-http" port="${jboss.management.http.port:9990}"/>
<socket-binding interface="management" name="management-https" port="${jboss.management.https.port:9993}"/>
<socket-binding name="txn-recovery-environment" port="4712"/>
<socket-binding name="txn-status-manager" port="4713"/>
<outbound-socket-binding name="mail-smtp">
<remote-destination host="localhost" port="25"/>
</outbound-socket-binding>
</socket-binding-group>
</server><?xml version = '1.0' encoding = 'UTF-8'?>
<!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file
distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under
the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may
obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to
in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF
ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under
the License. -->
<Repository>
<DataSources>
<DataSource name="cmsds">
<param name="driver" value="oracle.jdbc.OracleDriver" />
<param name="url" value="jdbc:oracle:thin:@{ip iddress}:1521/{SID}" />
<param name="user" value="cms_common" />
<param name="password" value="passord" />
<param name="databaseType" value="oracle" />
<param name="validationQuery" value="select 'validationQuery' from dual"/>
<param name="maxPoolSize" value="300"/>
</DataSource>
</DataSources>
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="dataSourceName" value="cmsds"/>
<param name="schemaObjectPrefix" value="" /> <!-- CMS Repository FileSystem -->
</FileSystem>
<DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
<param name="dataSourceName" value="cmsds"/>
<param name="minRecordLength" value="0" />
<param name="maxConnections" value="20" />
<param name="copyWhenReading" value="true" />
<param name="tablePrefix" value="" />
<param name="schemaObjectPrefix" value="" />
</DataStore>
<Cluster id="suite-poc-aks" syncDelay="4000">
<Journal class="org.apache.jackrabbit.core.journal.OracleDatabaseJournal">
<param name="revision" value="${rep.home}/revision.log" />
<param name="dataSourceName" value="cmsds"/>
<param name="janitorEnabled" value="true"/>
</Journal>
</Cluster>
<Security appName="Jackrabbit">
<SecurityManager class="org.apache.jackrabbit.core.DefaultSecurityManager" workspaceName="security">
</SecurityManager>
<AccessManager class="org.apache.sling.jcr.jackrabbit.server.impl.security.PluggableDefaultAccessManager">
</AccessManager>
<LoginModule class="org.apache.sling.jcr.jackrabbit.server.impl.security.PluggableDefaultLoginModule">
<param name="anonymousId" value="anonymous" />
<param name="adminId" value="admin" />
</LoginModule>
</Security>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" />
<Workspace name="${wsp.name}">
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}" />
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.DerbyPersistenceManager">
<param name="url" value="jdbc:derby:${wsp.home}/db;create=true" />
<param name="schemaObjectPrefix" value="${wsp.name}_" />
<param name="shutdownOnClose" value="false" />
</PersistenceManager>
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index" />
<param name="supportHighlighting" value="true" />
</SearchIndex>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="dataSourceName" value="cmsds"/>
<param name="schemaObjectPrefix" value="" />
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.pool.OraclePersistenceManager">
<param name="dataSourceName" value="cmsds"/>
<param name="schemaObjectPrefix" value="" />
<param name="errorHandling" value="" />
<param name="bundleCacheSize" value="16" />
<!-- param name="consistencyCheck" value="true"/>
<param name="consistencyFix" value="true"/ -->
<param name="minBlobSize" value="0" />
</PersistenceManager>
</Versioning>
<!-- <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${rep.home}/repository/index" />
<param name="supportHighlighting" value="true" />
</SearchIndex> -->
</Repository>
