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 2: | Line 2: | ||
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. | 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. | + | 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>. | * 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>. | ||
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 accordingly.
- 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
![[1]](http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_1.png){kind=link}
![[2]](http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateDerbySqlService_2.png){kind=link}