Create JNDI for a new DB in IBPM
In this post, I would put steps on how to create a JNDI for a new DB to be connected from IBPM (aka lombardi). Below are the steps to create a new JNDI:
- In a web browser, bring up the WebSphere Administrative Console. For example, https://localhost:9043/admin. The port number may be different in your environment. You can look in the <WLE_HOME>/AppServer/profiles/Lombardi/logs/ProcessCenter01 Service.log file to determine the port number.
- Log in as
tw_user
. The password istw_user. Alternatively, if you don’t see admin privilege once you logged in try login as admin (password: admin) as shown in Figure-1.
-
Figure-1 In the navigation pane go to Resources > JDBC > Data sources. - In All scopes, you see five data sources that were created during product installation. One is the default "Datasource" and the other four are related to Lombardi Teamworks.
- You will create a new data source that points to the sample database:
![]() |
Figure-2 |
a.
Change the Scope to Cell=LombardiCell01.
b. Click New.
c. Enter a data source name. Let it be KYC Data
Base Data Source.
d. Enter a JNDI name, for example, jdbc/sampleKYC
(Figure 2) and click Next.
7. Click Select an existing JDBC Provider. From the drop down list, select TeamWorks Process Server DB2 JDBC Driver as shown in Figure 3 and click Next
![]() |
Figure-3 |
1 8.
Perform below steps in the next screeen.
- For the driver type, choose 4.
- Enter the database name as KYCDB. (name of the database that you have created.)
- Enter the database server name as VALUED-625CDF07. (Name of the host where DB is installed)
- If the port number is not filled in, enter the database port number as shown in Figure 4. The default port number for DB2 is 50000.
- Click Next.
![]() | ||
Figure-4 |
1 9. Choose the processdblogon
alias (Figure 5) for all, except the mapping-configuration alias. And Click Next.
![]() |
Figure-5 |
Note: Typically, you create a J2C authentication alias. Since
you are simply using a different database table in the same DB2 instance, you can
use the existing J2C aliases.
1 10. On the Summary
screen, double-check the values and click Finish, as shown in below
Figure.
![]() | |||
Figure-6. |
11.
Save to the master
configuration and restart the server.
12.
Select the newly created data
source and click the Test connection button.
a.
Make sure the connection is
successful. If there are errors, fix them before proceeding.
b. You may now exit from
the WebSphere Administrative Console.
Once the the JNDI (jdbc/sampleKYC) is created, you can use this datasource in your sql connectors.
No comments:
Post a Comment