My Oracle Support Banner

Derby Database Errors While Configuring JDBC DataSources During WebLogic Portal (WLP) Domain Creation Using the Configuration Wizard (Doc ID 1448218.1)

Last updated on DECEMBER 23, 2022

Applies to:

Oracle WebLogic Portal - Version 10.3.4 and later
Information in this document applies to any platform.

Symptoms

When creating a WebLogic Portal (WLP) Domain using the Configuration Wizard, if using the default Derby Database there are several errors/messages with the JDBC DataSource testing, Database Load Scripts and the SQLAthenticator.sql.  The following screenshots show the sequence of steps.  Note that some irrelevant steps have been intentionally left out.

Run the Configuration Wizard and get to the following step...

 

1. Configure JDBC Data Sources

 

Note: Derby is only a default Database that comes with the WLP Product.  It is not supported in production and should only be used in rare development instances.  If you can avoid using Derby you will avoid the issue described in this document.  It is recommended to use the type of Database you will be using in production.

 

2. Test JDBC Data Sources

This warning message is displayed because the Derby Database is not up and running.  This warning can be ignored.

 

3. Run Database Scripts

The Database Load will always fail because the Derby Database is not up and running.  Don't run the scripts at this time because they won't work anyway.  If you do happen to run the scripts the Database Load Failed! message can be ignored.

 

4. Select Optional Configuration

Check RDBMS Security Store to configure it.

 

5. Configure RDBMS Security Store Database

Configure the RDBMS Security Store.

 

6. Creating Domain (SQLAuthenticator.sql Info Message)

Ignore the Info message about running the SQLAuthenticator.sql script (the SQLAuthenticator.sql script will be run as part of the create_db script mentioned in the Solution section).  At this point just click OK and then Done and the new Domain will be created without the Database at this time.

NOTE: In the above screenshots the username 'weblogic' used is the default user in WebLogic Portal (WLP) and the 'weblogic_eval' is a default out of the box database provided by WebLogic Portal (WLP) . Reference : WebLogic Portal Database properties

NOTE: The port 1527 used in the above screenshots is the default port in Derby. Reference : Using Derby

 

Changes

 

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
Changes
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.