While working on our local systems we will have some scenario in which we want to connect to SOAINFRA database of IntegratedWeblogicServer.
In this post I will explain you how to login to SOAINFRA database of default domain coming with Integrated weblogic server in JDeveloper 12c. SOAINFRA database of IntegratedWeblogicServer runs on Derby server.
Prerequisite : IntegratedWeblogicServer must be up and running before proceeding further.
Follow the below steps to connect to SOAINFRA database:
1. To connect to weblogic server connection details are required. These connection details can be found from the SOADataSource. For this login to weblogic admin console using url http://localhost:7101/console.
2. After login, click on Data Sources.
3. Open SOADataSource and click on Connection Pool. Copy the connection URL. URL will be like
jdbc:derby://localhost:1527/soainfra;ServerName=localhost;databaseName=soainfra
Description of URL :
4. Now open JDeveloper or any other tool to acess the SOAINFRA database.
5. Create a new database connection and and fill details as mentioned in the step 3. Select Connection Type as "Java DB (Derby)".
6. Click on Test Connection. You may get error "Test failed: Driver class not found.
Verify the Driver location".
7. To resolve this issue derbyclient.jar needs to be added in JDeveloper class path. To add it go to Tools -> Manage Libraries -> New -> AddEntry. A popup window will appear. From here go to java home and go to the path /jdk1.7.0_79/db/lib. Select derbyclient.jar.
8. Go back to step 6 and choose the derbyclient.jar class path under library section and click on Test Connection.
In this post I will explain you how to login to SOAINFRA database of default domain coming with Integrated weblogic server in JDeveloper 12c. SOAINFRA database of IntegratedWeblogicServer runs on Derby server.
Prerequisite : IntegratedWeblogicServer must be up and running before proceeding further.
Follow the below steps to connect to SOAINFRA database:
1. To connect to weblogic server connection details are required. These connection details can be found from the SOADataSource. For this login to weblogic admin console using url http://localhost:7101/console.
2. After login, click on Data Sources.
3. Open SOADataSource and click on Connection Pool. Copy the connection URL. URL will be like
jdbc:derby://localhost:1527/soainfra;ServerName=localhost;databaseName=soainfra
Description of URL :
- HostName : localhost
- Port Number : 1527
- UserName : soainfra
- Database Name : soainfra
4. Now open JDeveloper or any other tool to acess the SOAINFRA database.
5. Create a new database connection and and fill details as mentioned in the step 3. Select Connection Type as "Java DB (Derby)".
6. Click on Test Connection. You may get error "Test failed: Driver class not found.
Verify the Driver location".
7. To resolve this issue derbyclient.jar needs to be added in JDeveloper class path. To add it go to Tools -> Manage Libraries -> New -> AddEntry. A popup window will appear. From here go to java home and go to the path /jdk1.7.0_79/db/lib. Select derbyclient.jar.
8. Go back to step 6 and choose the derbyclient.jar class path under library section and click on Test Connection.
Great., It worked...Thx.
ReplyDelete