Difference between revisions of "Scout/Tutorial/3.8/webservices/Create Derby SQL Service"

Revision as of 08:42, 12 April 2012

The Scout documentation has been moved to https://eclipsescout.github.io/. 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 you 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]:

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 your location.
Value: C:\\eclipse\\scout\\tutorial\\org.eclipse.scout.tutorial.jaxws.database

Username
The username to access the database.
Value: tutorial

Password
The password to access the database
Value: scout

Create Derby SQL Service

Create Derby SQL Service

Set properties to connect to database