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 03, 2021
Applies to:Oracle WebLogic Portal - Version 10.3.4 and later
Information in this document applies to any platform.
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
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
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