Bug 1467697

Summary: Unable to deploy xa-datasource (postgres driver) over ssl
Product: [JBoss] JBoss Enterprise Application Platform 6 Reporter: Abhi <soniabhi665>
Component: jbossasAssignee: jboss-set
Status: CLOSED EOL QA Contact: Peter Mackay <pmackay>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: fnasser, jason.greene
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Instance Name: Not Defined Build: CSProcessor Builder Version 1.8 Build Name: 8740, Administration and Configuration Guide-6-3 Build Date: 05-04-2013 09:18:51
Last Closed: 2019-08-19 12:48:59 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Abhi 2017-07-04 16:18:27 UTC 
Title: SSL on PostgreSQL XA Datasource

Describe the issue:

Following configuration was used:

 <xa-datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="JBPMDS" enabled="true" use-ccm="false">
                    <xa-datasource-property name="databaseName">
                        DB
                    </xa-datasource-property>
                    <xa-datasource-property name="serverName">
                        127.0.0.1
                    </xa-datasource-property>
                    <xa-datasource-property name="portNumber">
                        5432
                    </xa-datasource-property>
                    <xa-datasource-property name="Ssl">
                        true
                    </xa-datasource-property>
                    <xa-datasource-property name="trustServerCertificate">
                        true
                    </xa-datasource-property>
                    <xa-datasource-property name="trustStore">
                        keystore
                    </xa-datasource-property>
                    <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
                    <driver>postgresql</driver>
                    <xa-pool>
                        <allow-multiple-users>true</allow-multiple-users>
                        <is-same-rm-override>false</is-same-rm-override>
                        <interleaving>false</interleaving>
                        <pad-xid>false</pad-xid>
                        <wrap-xa-resource>false</wrap-xa-resource>
                    </xa-pool>
                    <security>
                        <user-name>postgres</user-name>
                        <password>postgres</password>
                    </security>
                    <validation>
                        <check-valid-connection-sql>select 1</check-valid-connection-sql>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>true</background-validation>
                        <background-validation-millis>10000</background-validation-millis>
                    </validation>
                    <statement>
                        <share-prepared-statements>false</share-prepared-statements>
                    </statement>
                </xa-datasource>

Suggestions for improvement:


Additional information:
Please advise.
Setup not working.

Following is the error:
Response

Internal Server Error
{
    "outcome" => "failed",
    "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0042: failed to match pool. Check JndiName: java:jboss/datasources/jbpmDS",
    "rolled-back" => true,
    "response-headers" => {"process-state" => "reload-required"}
}