Scout/Tutorial/3.8/webservices/Create Derby SQL Service

Scout

Wiki Home

Website

Download • Git

Community

Forums • Blog • Twitter • G+

Bugzilla

Bugzilla

On the server node, go to 'Common Services' | 'Sql Services'. Right click on the node to create a new 'SQL Service' [1]. For class name, enter DerbySqlService and choose AbstractDerbySqlService as supertype [2]. Click finish to create the SQL service. This creates the SQL service to access your Derby database. Also, the service registration in plugin.xml of the server Plug-In is done by Scout SDK automatically.

Finally you have to configure the path to your Derby database and specify username and password. Thereto, click on the created DerbySqlService. In the Scout Property View, please change the following properties [3]:

Username
The username to access the database.
Value: tutorial

Password
The password to access the database
Value: scout

Jdbc Mapping Name
The JDBC connect string to access your Derby database. If you have not downloaded the database yet, download it from here and copy it to a location of your choice.
Value: jdbc:derby:C:\eclipse\scout\tutorial\org.eclipse.scout.tutorial.jaxws.database

Create Derby SQL Service

Create Derby SQL Service

Set properties to connect to database