Topic
  • 3 replies
  • Latest Post - ‏2012-02-17T13:41:18Z by WPSStudent
WPSStudent
WPSStudent
4 Posts

Pinned topic WPS database table Apache Derby view

‏2012-02-11T12:52:24Z |
Hi All,

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.
  • SMAR-t
    SMAR-t
    1 Post

    Re: WPS database table Apache Derby view

    ‏2012-02-15T22:47:41Z  
    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.
  • WPSStudent
    WPSStudent
    4 Posts

    Re: WPS database table Apache Derby view

    ‏2012-02-17T13:39:31Z  
    Hi SMAR-t
    Thanks Buddy...
    I got it...
  • WPSStudent
    WPSStudent
    4 Posts

    Re: WPS database table Apache Derby view

    ‏2012-02-17T13:41:18Z  
    Related Post :
    https://www.ibm.com/developerworks/forums/thread.jspa?messageID=14528555