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.
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' [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. | 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. | ||
− | 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: | + | 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''' | '''Jdbc Mapping Name''' | ||
Line 15: | Line 15: | ||
Enter: ''scout'' | Enter: ''scout'' | ||
− | [[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 3.png|thumb]] | + | [[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]] |
Revision as of 12:40, 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. Enter: 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