Portlet Factory, Version 6.1.2

 

Configuring a sample datasource

We provide a sample datasource and database pre-configured on the IBM® WebSphere® Application Server Community Edition (WAS CE) we distribute. You can configure this database and datasource on your own WebSphere Application Server Community Edition or your IBM WebSphere Application Server server.

Parent topic: Working with a database

 

Configuring a sample datasource onWebSphere Application Server Community Edition (WAS CE)

Follow these steps to configure a sample datasource on WebSphere Application Server Community Edition (WAS CE).

  1. Extract <INSTALLIMAGE>/config/EmployeeSampleDB.zip to <WASCE_ROOT>/var/derby

  2. From a command console, change to the <WASCE_ROOT>/var/derby/sample directory

  3. In command console enter: wasce-deploy-sample --user system --password manager

  4. Check the wasce-datasource-results.txt for confirmation of datasource creation.

  5. Edit your projects WEB-INF\bin\deployment\geronimo-web.xml file. Uncomment the EmployeeDatasource dependency and resource references.

  6. Edit your projects WEB-INF\bin\deployment\wasce.web.xml file. Uncomment the 'MyDatasource' resource-ref.

  7. Re-deploy.

 

Configuring a sample datasource on WebSphere Application Server

Follow these steps to configure a sample datasource on WebSphere Application Server.

  1. Extract <INSTALLIMAGE>/config/EmployeeSampleDB.zip to the AppServer\derby\databases directory.

  2. Edit the was-datasource.bat file, changing the values of SOAP_CONNECTOR_ADDRESS, USERNAME, and PASSWORD to reflect the values for your server.

  3. From a command console change to the AppServer\derby\databases directory.

  4. Execute the was-datasource.bat file.

  5. You do not need to redeploy your application to use the sample datasource on WAS.

Library | Support |