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 5: | Line 5: | ||
'''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 your location. | 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 your location. | ||
− | + | Value: ''C:\\eclipse\\scout\\tutorial\\org.eclipse.scout.tutorial.jaxws.database'' | |
'''Username''' | '''Username''' | ||
The username to access the database. | The username to access the database. | ||
− | + | Value: ''tutorial'' | |
'''Password''' | '''Password''' | ||
The password to access the database | The password to access the database | ||
− | + | Value: ''scout'' | |
[[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 12:43, 8 November 2011
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