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 1: | Line 1: | ||
− | On the server node, go to 'Common Services' | 'Sql Services'. Right click on the node to create a new 'SQL Service'. For class name, enter <code>DerbySqlService</code> and choose <code>AbstractDerbySqlService</code> as supertype. Click finish. | + | 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. | + | 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 <code>DerbySqlService</code>. In the Scout Property View, change the properties <code>Jdbc Mapping Name</code>, <code>Username</code> and <code>Passord<code> accordingly. | ||
+ | |||
+ | * Jdbc Mapping Name: The JDBC connect string to access your Derby database: Enter <code>C:\\eclipse\\scout\\tutorial\\org.eclipse.scout.tutorial.jaxws.database</code>. | ||
+ | * Username: The username to access the database: Enter <code>tutorial</code> | ||
+ | * Password: The password to access the database: Enter <code>scout</code> | ||
[[Image:org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_1.png|thumb|]] | [[Image:org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_1.png|thumb|]] | ||
[[Image:org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_2.png|thumb|]] | [[Image:org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_2.png|thumb|]] | ||
[[Image:org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_3.png|thumb|]] | [[Image:org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_3.png|thumb|]] |
Revision as of 12:23, 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, change the properties Jdbc Mapping Name
, Username
and Passord<code> accordingly.
- Jdbc Mapping Name: The JDBC connect string to access your Derby database: Enter <code>C:\\eclipse\\scout\\tutorial\\org.eclipse.scout.tutorial.jaxws.database.
- Username: The username to access the database: Enter
tutorial
- Password: The password to access the database: Enter
scout