Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

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

< Scout‎ | Tutorial‎ | 3.8
 
(17 intermediate revisions by 4 users 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. 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.  
+
{{ScoutPage|cat=Tutorial 3.8}}
 +
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, please change the following properties [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_3.png]:
 
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]:
 
'''Jdbc Mapping Name'''
 
The JDBC connect string to access your Derby database.
 
Enter: ''C:\\eclipse\\scout\\tutorial\\org.eclipse.scout.tutorial.jaxws.database''
 
  
 
  '''Username'''
 
  '''Username'''
 
  The username to access the database.
 
  The username to access the database.
  Enter ''tutorial''
+
  Value: ''tutorial''
  
 
  '''Password'''
 
  '''Password'''
 
  The password to access the database
 
  The password to access the database
  Enter: ''scout''
+
  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 [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 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]]

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
Create Derby SQL Service
Create Derby SQL Service
Set properties to connect to database

Back to the top