Connecting to default portal database

Recently i had a requirement for which i wanted to connect to default Apache Derby database that WebSphere Portal uses for storing configuration. So i followed these steps to connect using Eclipse, but they can be applied anywhere else

  • If you dont connect to any other Apache Derby database on regular basis then first you will have to configure DB driver for Derby in Eclipse. For that click on Windows - Preferences, it will open a dialog box in that select Data Management - Connectivity - Driver definition and specify location of derby driver. If your using portal you can find the db driver in WebSphere/Appserver/Derby directory

  • Next step would be to define connection for connecting to portal database, that you can do by switching to Database development perspective and selecting new connection like this

    By default portal derby database is stored in the portalbase/wp_profile/PortalServer/derby/wpsdb directory so select that as database location and dont enter any userid password
    Important Note You could connect to portal db from either JDBC client or portal server at one time so before connecting to portal database shutdown your portal server. And don't forget to disconnect from the database before you restart portal or you will get some wired error

  • Once the connection is defined you can connect to database and you will see that the tables are divided into different schema, RELEASE schema holds all the portal level configuration such portlet, page definitions


srjwebsolutions said...

We are leading responsive website designing and development company in Noida.
We are offering mobile friendly responsive website designing, website development, e-commerce website, seo service and sem services in Noida.

Responsive Website Designing Company in Noida
Website Designing Company in Noida
SEO Services in Noida
SMO Services in Noida

Vikas Chaudhary said...

Battery Mantra is Authorized exide car battery dealer in Noida and Greater Noida. We are providing our service in Indirapuram, Delhi, Ashok Nagar.

Exide Battery Dealer in Noida
Battery Dealer in Noida
Authorized Battery Dealer in Noida
Car Battery Dealer in Noida
Car Battery Dealer
Exide Battery Dealer

EG MEDI said... is online medical store pharmacy in laxmi nagar Delhi. You can Order prescription/OTC medicines online.
Cash on Delivery available. Free Home Delivery

Online Pharmacy in Delhi
Buy Online medicine in Delhi
Online Pharmacy in laxmi nagar
Buy Online medicine in laxmi nagar
Onine Medical Store in Delhi
Online Medical store in laxmi nagar
Online medicine store in delhi
online medicine store in laxmi nagar
Purchase Medicine Online
Online Pharmacy India
Online Medical Store