I have WPS 7 installed on my machine. I wanted to check the database schema of BPEDB. How can i view the table row entries.
This topic has been locked.
Pinned topic WPS database table Apache Derby view
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
SMAR-t 2700052S4K1 Post
Re: WPS database table Apache Derby view2012-02-15T22:47:41ZThis is the accepted answer. This is the accepted answer.1. Start WID
2. Stop the server you are using so that the databases aren’t locked.
3. Switch to the Data perspective.
4. In the Data Project Explorer view, right-click and select New Project -> Data Development Project.
5. In Data Development Project Wizard click next -> Select New Connection -> Connection Parameters.
Select Derby 10.1 as the database manager.
Select the database you are interested in. For example, I selected <WID_INSTALL_PATH>\pf\esb\databases\MEDB, which is the messaging engine database for my WESB test server.
Select <WID_INSTALL_PATH>\runtimes\bi_v61\derby\lib\derby.jar as the Class location.
Untick Create the database if required.
Set the user ID and password to the appropriate values – if you are using an out-of-the-box WID test server, they will be admin and admin.
Select Test Connection. If it fails, double-check the values you entered.
Now select Finish.
Now there should be a connection in your Database Explorer view. You can expand that to navigate through your database. In particular, you are probably interested in the Schemas section.
Re: WPS database table Apache Derby view2012-02-17T13:39:31ZThis is the accepted answer. This is the accepted answer.Hi SMAR-t
I got it...
Re: WPS database table Apache Derby view2012-02-17T13:41:18ZThis is the accepted answer. This is the accepted answer.Related Post :