Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Scout/Tutorial/3.8/webservices/Create Derby SQL Service"
(29 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | On the server node, go to 'Common Services' | 'Sql Services'. Right click on the node to create a new 'SQL Service' [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_1.png]. For class name, enter <code>DerbySqlService</code> and choose <code>AbstractDerbySqlService</code> as supertype [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_2.png]. Click finish to create the SQL service. | + | {{ScoutPage|cat=Tutorial 3.8}} |
− | This creates | + | On the server node, go to 'Common Services' | 'Sql Services'. Right click on the node to create a new 'SQL Service' [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_1.png]. For class name, enter <code>DerbySqlService</code> and choose <code>AbstractDerbySqlService</code> as supertype [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_2.png]. 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 <code>DerbySqlService</code>. In the Scout Property View, change the properties | + | Finally you have to configure the path to your Derby database and specify username and password. Thereto, click on the created <code>DerbySqlService</code>. In the Scout Property View, please change the following properties [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_3.png]: |
+ | '''Username''' | ||
+ | The username to access the database. | ||
+ | Value: ''tutorial'' | ||
+ | '''Password''' | ||
+ | The password to access the database | ||
+ | Value: ''scout'' | ||
− | '''Jdbc Mapping Name | + | '''Jdbc Mapping Name''' |
+ | The JDBC connect string to access your Derby database. If you have not downloaded the database yet, download it from [https://dev.eclipse.org/svnroot/technology/org.eclipse.scout/scout.example/trunk/jaxws/org.eclipse.scout.tutorial.jaxws.database/database/org.eclipse.scout.tutorial.jaxws.database.zip here] and copy it to a location of your choice. | ||
+ | Value: ''jdbc:derby:C:\eclipse\scout\tutorial\org.eclipse.scout.tutorial.jaxws.database'' | ||
− | + | [[Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService 1.png|thumb|Create Derby SQL Service]] | |
− | + | [[Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService 2.png|thumb|Create Derby SQL Service]] | |
− | + | [[Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService 3.png|thumb|Set properties to connect to database]] | |
− | + | ||
− | [[Image: | + | |
− | [[Image: | + | |
− | [[Image: | + |
Latest revision as of 18:29, 27 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 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