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 APRIL 18, 2025

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.97 and Prior and later
Information in this document applies to any platform.

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

	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

Symptoms

Cause

Solution

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

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

Applies to:

Symptoms

Cause

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

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