Hi,
i am using JBOSS EAP 6.2. i am trying to configure XA-Datasource with encrypt datasource using security-domain. Please provide the sample CLI command for create command of XA-Datasource and security-domain. below are the command i have tried.not able to make successful while "test-connection-in-pool" it gives error message as "connection not valid"
/profile=full/subsystem=security/security-domain=TEST_ENCRYPT_CREDENTIAL:add(cache-type=default)
/profile=full/subsystem=security/security-domain=TEST_ENCRYPT_CREDENTIAL/authentication=classic:add()
/profile=full/subsystem=security/security-domain=TEST_ENCRYPT_CREDENTIAL/authentication=classic/login-module=encrypt_ds:add(flag=required, code=org.picketbox.datasource.security.SecureIdentityLoginModule, module-options=[{(name => username),(value => test)},{(name => password),(value => -2fe44a65ds6efc763)},{(name => managedConnectionFactoryName),(value => jboss.jca:service=XATxCM,name=test)}])
below are the XA Data source CLI commands for POSTGRES DB
/profile=full/subsystem=datasources/xa-data-source=test_ds:add(driver-name=dsDriver, jndi-name=java:jboss/jdbc/test_ds,security-domain=TEST_ENCRYPT_CREDENTIAL no-tx-separate-pool=true)
/profile=full/subsystem=datasources/xa-data-source=test_dsxa-datasource-properties=ServerName:add(value=localhost)
/profile=full/subsystem=datasources/xa-data-source=test_ds/xa-datasource-properties=PortNumber:add(value=1122)
/profile=full/subsystem=datasources/xa-data-source=test_ds/xa-datasource-properties=DatabaseName:add(value=test_db)
xa-data-source enable --name=test_ds --profile=full
Please help me on this.