Bug 1467697 - Unable to deploy xa-datasource (postgres driver) over ssl
Summary: Unable to deploy xa-datasource (postgres driver) over ssl
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: jbossas
Version: unspecified
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: jboss-set
QA Contact: Peter Mackay
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-07-04 16:18 UTC by Abhi
Modified: 2019-08-19 12:48 UTC (History)
2 users (show)

Fixed In Version:
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
Embargoed:


Attachments (Terms of Use)

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"}
}


Note You need to log in before you can comment on or make changes to this bug.