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"
Line 14: | Line 14: | ||
'''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/org.eclipse.scout.tutorial.jaxws.database/database/org.eclipse.scout.tutorial.jaxws.database.zip here] and copy it to a location of your choice. | 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/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: | + | 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 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 2.png|thumb|Create Derby SQL Service]] | ||
[[Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService 3.png|thumb|Set properties to connect to database]] | [[Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService 3.png|thumb|Set properties to connect to database]] |
Revision as of 11:46, 23 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