My Oracle Support Banner

Collections Standalone Thread Pool Datasource (Doc ID 2614735.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Banking Platform - Version 2.4 and later
Information in this document applies to any platform.

Goal

Currently Standalone Threadpool for Collections batch is that it creates a connection on startup using jdbc thin client using credentials stored in the hibernate.properties file
How to use Oracle Wallet instead of the above mentioned process.

Following attempt with Oracle Wallet was made by platform team which is not working as expected.

Using Oracle Wallet with JDBC Thin Driver
1. Configure Oracle Wallet as usual (which comes with the Oracle Database Client), creating the appropriate entries in your tnsnames.ora and sqlnet.ora files as well as the credential entry in your wallet
2. Add the following JARs to your Java classpath. You should get these from the Oracle 11g client, and they can be found in the "jdbc" and/or "jlib" directories of where the client install is
o Oracle JDBC Driver - ojdbc6.jar
o Oracle Wallet - oraclepki.jar
o Oracle Security Certs - osdt_cert.jar
o Oracle Security Core - osdt_core.jar
3. Start your Java application with the following system properties, pointing at your respective TNS and wallet directories:
o -Doracle.net.tns_admin=/apps/ignite/runtime/igthost/certs
o -Doracle.net.wallet_location=/apps/ignite/runtime/igthost/certs
4. Then you can use a thin JDBC connection string in your application like so: jdbc:oracle:thin:/@MY_WALLET_DB_ENTRY
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.