Before you can run this sample on the server, you need
to create the data sources and install the blog sample on the server.
Procedure
- If the server is stopped, start the server by running the
following steps:
- Switch to the Servers view ().
- Right-click WebSphere Application Server and then click Start.
- Open the administrative console. Right-click
the server and select .
- Access the JDBC providers view. In the administrative
console, in the Resources section, expand JDBC and click JDBC providers.
- Click the Derby JDBC Provider link.
- Click Data sources.
- Create the data source. Click New. In the JNDI name field, enter jdbc/blogdb. Click Next.
- In the Database name field, enter
the location of the BLOGDB database. This location must
be on the same machine as the WebSphere® Application Server server. If you are deploying on
a local server, enter the location of the database in your workspace.
To find the location, expand the derby project, right-click the BLOGDB folder, and select Properties. In the Resource section of the properties
view, copy the value that is displayed for Location. If you are using a remote server, copy the BLOGDB folder from
the derby project to a location on the remote server machine. In the Database name field, enter the full path of the location
of the BLOGDB folder.
- Go through the rest of the wizard, accept the defaults,
and click Finish on the last page of the wizard.
- Click the Save link.
- Test the connection to the data source. In the Data sources view, check the box next to the data source
that you created and click Test connection.