public class

Config

extends Object
implements MuleContextAware
java.lang.Object
   ↳ org.mule.modules.oracle.Config

Summary

Constants
String CUSTOM_PLSQL_GROUP Group box containing the list of custom PL/SQL web services.
String DB_CONNECTION_GROUP Group box with the server and login information for EBS' database.
String HEADER_GROUP Group box containing properties for calling web services.
String MINIMUM_EBS_VERSION_PREFIX Oracle EBS version must start with this prefix.
String ORACLE_EBS_VERSION_QUERY Query used to find out the version number of the Oracle EBS instance.
String UNSUPPORTED_EBS_VERSION_MESSAGE_PATTERN String pattern for the error message to be shown when attempting to communicate with an unsupported version of Oracle EBS.
String WS_CONNECTION_GROUP Group box with the server and login information for EBS' SOA Gateway (web services).
String basePath Endpoint of default WSDL
String basePathPlSql Endpoint of default PL/SQL WSDL
Fields
private AQClient aqClient Client that manages Oracle AQ connections for Business Events and XML Gateway Outbound subscriptions.
public List<String> customPlSqlNameList List of custom PL/SQL names for web services that will be gathered for Data Sense.
private OracleEBSFinancialServices cxfClient
private String dbHost Oracle EBS Database Hostname.
private String dbPassword Oracle EBS Database Password.
private String dbPort Oracle EBS Database Port.
private String dbSid Oracle EBS Database SID.
private String dbUser Oracle EBS Database Username.
private boolean disableCNCheck Whether to disable or not the checking of the Common Name in the certificate.
private String host Oracle EBS Web Services Hostname.
private static final Logger logger
protected MuleContext muleContext
private String nlsLanguage NLS Language.
private String orgId Org Id.
private String password Oracle EBS Web Services Password.
private String port Oracle EBS Web Services Port.
private String responsibilityApplName Responsibility Application Name.
private String responsibilityName Responsibility Name
private String securityGroupName Security Group Name.
private SOAHeader soaheader The header used to make web service calls.
private boolean sslEnabled Use SSL to communicate with Oracle EBS Web Services.
private String trustStorePassword Password for the TrustStore.
private String trustStorePath Path where the TrustStore is located.
private String username Oracle EBS Web Services Username.
Public Constructors
Config()
Public Methods
String basePath()
Retrieves endpoint
String basePathPlSql()
Retrieves endpoint for PL/SQL
AQClient getAQClient(boolean loop)
Returns the instance of AQClient.
OracleEBSFinancialServices getClient()
List<String> getCustomPlSqlNameList()
Returns the list of custom PL/SQL names for web services defined.
String getDbHost()
String getDbPassword()
String getDbPort()
String getDbSid()
String getDbUser()
boolean getDisableCNCheck()
String getHost()
Retrieves host
String getNlsLanguage()
String getOrgId()
String getPassword()
String getPort()
Retrieves port
String getResponsibilityApplName()
String getResponsibilityName()
String getSecurityGroupName()
String getTrustStorePassword()
String getTrustStorePath()
String getUsername()
boolean isSslEnabled()
void setCustomPlSqlNameList(List<String> customPlSqlNameList)
Sets the custom PL/SQL names for web services list to be used for metadata extraction.
void setDbHost(String dbHost)
void setDbPassword(String dbPassword)
void setDbPort(String dbPort)
void setDbSid(String dbSid)
void setDbUser(String dbUser)
void setDisableCNCheck(boolean disableCNCheck)
void setHost(String host)
Sets host
void setMuleContext(MuleContext muleContext)
void setNlsLanguage(String nlsLanguage)
void setOrgId(String orgId)
void setPassword(String password)
void setPort(String port)
Sets port
void setResponsibilityApplName(String responsibilityApplName)
void setResponsibilityName(String responsibilityName)
void setSecurityGroupName(String securityGroupName)
void setSslEnabled(boolean sslEnabled)
void setTrustStorePassword(String trustStorePassword)
void setTrustStorePath(String trustStorePath)
void setUsername(String username)
void testConnection()
Checks if the credentials are valid and if the Oracle EBS version is supported by the connector.
void validateOracleEBSVersion(String version)
Validates if the given Oracle EBS version is supported.
[Expand]
Inherited Methods
From class java.lang.Object
From interface org.mule.api.context.MuleContextAware

Constants

private static final String CUSTOM_PLSQL_GROUP

Group box containing the list of custom PL/SQL web services.

Constant Value: "Custom PL/SQL web services"

private static final String DB_CONNECTION_GROUP

Group box with the server and login information for EBS' database. Required to access XML Gateway Outbound and Business Events queues.

Constant Value: "XML Gateway Outbound / Business Events Configuration"

private static final String HEADER_GROUP

Group box containing properties for calling web services.

Constant Value: "Service Bean Header"

private static final String MINIMUM_EBS_VERSION_PREFIX

Oracle EBS version must start with this prefix. It is the supported version.

Constant Value: "12.1."

private static final String ORACLE_EBS_VERSION_QUERY

Query used to find out the version number of the Oracle EBS instance.

Constant Value: "select release_name from apps.fnd_product_groups"

private static final String UNSUPPORTED_EBS_VERSION_MESSAGE_PATTERN

String pattern for the error message to be shown when attempting to communicate with an unsupported version of Oracle EBS.

Constant Value: "You are using an unsupported version of Oracle EBS (%s). The connector supports version %sx only."

private static final String WS_CONNECTION_GROUP

Group box with the server and login information for EBS' SOA Gateway (web services).

Constant Value: "Web Services Connection"

private static final String basePath

Endpoint of default WSDL

Constant Value: "://:/webservices/AppsWSProvider/oracle/apps/ar/hz/service"

private static final String basePathPlSql

Endpoint of default PL/SQL WSDL

Constant Value: "://:/webservices/SOAProvider/plsql/"

Fields

private AQClient aqClient

Client that manages Oracle AQ connections for Business Events and XML Gateway Outbound subscriptions.

public List<String> customPlSqlNameList

List of custom PL/SQL names for web services that will be gathered for Data Sense.

private OracleEBSFinancialServices cxfClient

private String dbHost

Oracle EBS Database Hostname.

private String dbPassword

Oracle EBS Database Password.

private String dbPort

Oracle EBS Database Port. Default value is '1521'.

private String dbSid

Oracle EBS Database SID.

private String dbUser

Oracle EBS Database Username.

private boolean disableCNCheck

Whether to disable or not the checking of the Common Name in the certificate.

private String host

Oracle EBS Web Services Hostname.

private static final Logger logger

protected MuleContext muleContext

private String nlsLanguage

NLS Language. Default value is 'AMERICAN'.

private String orgId

Org Id. Default value is '204'.

private String password

Oracle EBS Web Services Password.

private String port

Oracle EBS Web Services Port. Default value is '8000'.

private String responsibilityApplName

Responsibility Application Name.

private String responsibilityName

Responsibility Name

private String securityGroupName

Security Group Name. Default value is 'STANDARD'.

private SOAHeader soaheader

The header used to make web service calls.

private boolean sslEnabled

Use SSL to communicate with Oracle EBS Web Services.

private String trustStorePassword

Password for the TrustStore.

private String trustStorePath

Path where the TrustStore is located.

private String username

Oracle EBS Web Services Username.

Public Constructors

public Config ()

Public Methods

public String basePath ()

Retrieves endpoint

public String basePathPlSql ()

Retrieves endpoint for PL/SQL

public AQClient getAQClient (boolean loop)

Returns the instance of AQClient. If one does not exists, creates and configures a new one.

Parameters
loop Set to true in production, false when testing. This prevents infinite loops when subscribing to queues/topics.
Returns

public OracleEBSFinancialServices getClient ()

public List<String> getCustomPlSqlNameList ()

Returns the list of custom PL/SQL names for web services defined.

Returns
  • the values.

public String getDbHost ()

Returns
  • the dbHost

public String getDbPassword ()

Returns
  • the dbPassword

public String getDbPort ()

Returns
  • the dbPort

public String getDbSid ()

Returns
  • the dbSid

public String getDbUser ()

Returns
  • the dbUser

public boolean getDisableCNCheck ()

Returns
  • whether Common Name is checked or not when using a custom trust store

public String getHost ()

Retrieves host

public String getNlsLanguage ()

public String getOrgId ()

public String getPassword ()

Returns
  • the password

public String getPort ()

Retrieves port

public String getResponsibilityApplName ()

public String getResponsibilityName ()

public String getSecurityGroupName ()

public String getTrustStorePassword ()

Returns
  • the trustStorePassword

public String getTrustStorePath ()

Returns
  • the trustStorePath

public String getUsername ()

Returns
  • the username

public boolean isSslEnabled ()

Returns
  • the sslEnabled

public void setCustomPlSqlNameList (List<String> customPlSqlNameList)

Sets the custom PL/SQL names for web services list to be used for metadata extraction.

Parameters
customPlSqlNameList The name list of custom PL/SQL.

public void setDbHost (String dbHost)

Parameters
dbHost The dbHost to set

public void setDbPassword (String dbPassword)

Parameters
dbPassword The dbPassword to set

public void setDbPort (String dbPort)

Parameters
dbPort The dbPort to set

public void setDbSid (String dbSid)

Parameters
dbSid The dbSid to set

public void setDbUser (String dbUser)

Parameters
dbUser The dbUser to set

public void setDisableCNCheck (boolean disableCNCheck)

Parameters
disableCNCheck Whether Common Name is checked or not when using a custom trust store

public void setHost (String host)

Sets host

Parameters
host Host to set

public void setMuleContext (MuleContext muleContext)

Parameters
muleContext

public void setNlsLanguage (String nlsLanguage)

Parameters
nlsLanguage

public void setOrgId (String orgId)

Parameters
orgId

public void setPassword (String password)

Parameters
password The password to set

public void setPort (String port)

Sets port

Parameters
port Port to set

public void setResponsibilityApplName (String responsibilityApplName)

Parameters
responsibilityApplName

public void setResponsibilityName (String responsibilityName)

Parameters
responsibilityName

public void setSecurityGroupName (String securityGroupName)

Parameters
securityGroupName

public void setSslEnabled (boolean sslEnabled)

Parameters
sslEnabled The sslEnabled to set

public void setTrustStorePassword (String trustStorePassword)

Parameters
trustStorePassword The trustStorePassword to set

public void setTrustStorePath (String trustStorePath)

Parameters
trustStorePath The trustStorePath to set

public void setUsername (String username)

Parameters
username The wsUsername to set

public void testConnection ()

Checks if the credentials are valid and if the Oracle EBS version is supported by the connector.

Throws
ConnectionException if the credentials are invalid or the Oracle EBS version is not supported.

public void validateOracleEBSVersion (String version)

Validates if the given Oracle EBS version is supported.

Parameters
version The Oracle EBS version.
Throws
ConnectionException if the Oracle EBS version is not supported by the connector.