E1: BSSV: Cannot Test BSSV with Oracle 11g RDBMS. Unable to Get Initialize UserSession com.jdedwards.database.base.JDBException

(Doc ID 859688.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.97 and Prior and later
Information in this document applies to any platform.
Checked for relevance on 15-Nov-2012

Symptoms

Debugging and Testing of BSSVs in JDeveloper that are deployed either to the embedded OC4J or the Local EnterpriseOne OC4J fail if the RDBMS is Oracle 11g.

Error message in the bssv.log

23 Jun 2009 07:44:15,917 [Line ?] [main] [SEVERE] - [INTEROP] Unable to get initialize UserSession com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - ET812.)
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.searchOCM(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCMObjectLookupService.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.base.JDBServiceAugmentedKeyFactory.newAugmentedKey(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.lookupUser(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntriesWithVersion(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntries(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntry(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getExclusiveRowSecurityEntry(Unknown Source)
at com.jdedwards.database.impl.security.JDBSecurityAccess.<init>(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBSystem.connect(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.initialize(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.<init>(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.E1Principal.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.PrincipalCache.getIniPrincipal(Unknown Source)
at oracle.e1.bssvfoundation.impl.base.Context.<init>(Unknown Source)
at oracle.e1.bssvfoundation.impl.base.Context.<init>(Unknown Source)
at oracle.e1.bssvfoundation.impl.base.Context.<init>(Unknown Source)
at oracle.e1.bssvfoundation.base.PublishedBusinessService.startPublishedMethodInternal(Unknown Source)
at oracle.e1.bssvfoundation.base.PublishedBusinessService.startPublishedMethod(Unknown Source)
at oracle.e1.bssv.JPR01000.RI_AddressBookManager.getAddressBook(RI_AddressBookManager.java:129)
at oracle.e1.bssv.JPR01000.RI_AddressBookManager.getAddressBook(RI_AddressBookManager.java:107)
at oracle.e1.bssv.JPR01000.AddressBookManagerTest2.testGetAddressBookWithEntity(AddressBookManagerTest2.java:18)
at oracle.e1.bssv.JPR01000.AddressBookManagerTest2.main(AddressBookManagerTest2.java:35)
com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - ET812.
Note:
1. This issue affects BSSVs that are deployed to the JDeveloper embedded OC4J or the Local OC4J on the
EnterpriseOne Web Development Client.
2. This issues does not affect BSSVs that are deployed to either OAS or WAS.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms