IBM Support

Connect to Oracle 9i and 11g using the ojdbc6.jar driver

Troubleshooting


Problem

There is a business need to connect Sterling B2B Integrator to several different Oracle instances, some in Oracle 11g and others running Oracle 9i.

Symptom

When testing the connection to the Oracle 9i database the following error is thrown in the logs.

[2016-06-30 14:34:14.031] ERROR [JDBCService] Could not create the initial objects for the 'ORA9i_DATA' pool: The driver manager could not obtain a database connection.
[2016-06-30 14:34:14.086] ERROR 000310100002 UTIL.FRAME_JDBC.ERR_ConnectionFactory_create [ConnectionFactory].create()
[2016-06-30 14:34:14.086] ERROR [1467297254086] ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF014","label":"iOS"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"All","Edition":"All Editions","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
04 March 2019

UID

swg21986825

Page Feedback