This Web log describes how to Activate JDBC Connector service to perform database lookups (without JDBC adapter) in XI.
The standard How To guide covers almost all steps but falls short in describing some configuration steps.
This web log outlines the steps that are required to configure the JDBC Connector service for Oracle database
The following reference documents were used, this web log explains the steps that were missed in those documents
Steps to configure JDBC connector service
1.Download the oracle JDBC driver ojdbc14.jar from the website
2.Use Visual administrator to upload the ojdbc14.jar
against JDBC connector service.
3.Select the Service node from the list of nodes shown below
4.Select the JDBC Connector from the list of services
5.Place the cursor in the Drivers node in the Runtime tab, Click the create button to add the drivers.
6.Place the cursor in the DataSources to create a new data source.
Enter the following parameters
Data source Name
Add alias name ( Do not add jdbc/Name)
since what ever the name you add will be registered in the JNDI Registry under jdbc context, while writing the java code access the alias by (jdbc/aliasname)
Subsequently, to check if the alias is registered with JNDI, you can browse to the JNDI Registry node in Visual administrator and locate the alias
Select the appropriate driver from the list of drivers (from step 5)
Select JDBC Version
If the version is JDBC 2.0 compliant (Oracle 10.x drivers are compliant) then enter
Object factory – oracle.jdbc.pool.OracleDataSourceFactory
DataSource type – XADataSource
XADS Class name – oracle.jdbc.xa.client.OracleXADataSource
8.How to test the data source to working fine ?
In the DB initialization tab, enter a SQL statement to query the table, & press execute button, it should return the results.
Do not forget to remove the statement after the test.
9.Develop java code that performs DBLookup, the sample code for the performing the DBLook up is given in the How to Guide Appendix.
10.Follow the procedure as given in the how to guide to Create UDF’s