WAS v8.5 > Administer applications and their environment > Administer the Liberty profile > Administer the Liberty profile using WebSphere Studio

Add a data source using WebSphere Studio

We can add a data source to the application using the developer tools.

1. In the Project Explorer view, expand liberty_profile_name > servers > worklightServer > server.xml, and select Open With > XML Editor.
2. In the design view, select Server Configuration, and click Add.

3. On the Select item to add to Server Configuration: page, select Data Source.

4. On the Data Source Details panel, beside JDBC Driver, click Create.

5. On the Configure a JDBC driver page,
   • In the Id field, type an ID for the JDBC driver, for example derbyEmbedded.
   • In the Library ref: field, select an option from the drop-down list, or click Create to create a new one.

     • On the Configure a shared library page, in the Id field, type the ID for the JDBC driver created, for example derbyEmbedded.
     • Iin the Fileset ref: field, select an option from the drop-down list, or click Create to create a new one.

       • On the Configure a fileset page, in the Id field, type an ID for the JDBC driver, for example derbyEmbedded.
       • In the Base directory field, type a path for the base directory or click Browse to locate a library location path.
       • In the Includes field, type the name of your data source, for example derby.jar, or click Browse to locate the data source archive file to include.
       • In the Excludes field, type the archives to exclude, or click Browse to locate the data source archive file to exclude. Click Okay

     • Click Okay

   • Click Okay

6. Your JDBC data source has been added to the application.

Parent topic: Administer the Liberty profile using WebSphere Studio

|