Create Data Source lswdbDfdDS

Create data source lswdbDfdDS as described. (For more information, see Oracle® E-Business Suite Software Development Kit for Java.)

To create data source lswdbDfdDS:

In Step 5, enter values exactly as follows:

• Name for the datasource: lswdbDfdDS
• JNDI Name: jdbc/lswdbDfdDS
• Database Driver: Oracle's Driver (Thin) for Instance connections.

  (Note that this driver is a non-XA driver.)

• Driver ClassName: oracle.apps.fnd.ext.jdbc.datasource.AppsDataSource

In Step 8, enter values for your environment:

• Database name: dmwebspr (example name)
• Hostname: your_hostname
• Port: database_port_number
• DB User Name: Enter the username [e-mail], with the assigned role UMX|APPS_SCHEMA_CONNECT, that your would have already created by following instructions in Section 2.1.3, "Set Up Necessary Oracle E-Business Suite Users" in Oracle® E-Business Suite Software Development Kit for Java. This is a proxy user required to pass the authentication messages.
• Password: Enter the password created for that user.

In Step 10, enter values exactly as follows:

• Driver Class Name:

  oracle.apps.fnd.ext.jdbc.datasource.AppsDataSource

In Step 11, enter the full path of the desktop dbc file in the Properties field. For example:

• user=[e-mail]
• dbcFile=<Full path to DBC file>/<DBC File Name>.dbc

Select the target server. If you have created the new server, target the datasource to the new server. Else, target the datasource to the existing server.