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.7/Minicrm/Set up SQL Service"
(a step of the tutorial moved to a separate page.) |
(Write Intro) |
||
Line 1: | Line 1: | ||
− | {{note|Scout Tutorial|This page belongs to the [[Scout/Tutorial/Minicrm Step-by-Step|Minicrm Step-by-Step Tutorial]]. It explains how | + | {{note|Scout Tutorial|This page belongs to the [[Scout/Tutorial/Minicrm Step-by-Step|Minicrm Step-by-Step Tutorial]]. It explains how to use a database from your new Eclipse Scout project. You need to have a bare-bones {{ScoutLink|Tutorial|Setup a New Eclipse Scout Project|Scout Project up and running}} in order to continue.}} |
+ | |||
+ | We want to connect to a database. In Scout terms, the client might want to fill a table with data from the database. It calls a service on the server to provide some table data. That service in turn has to get the data from somewhere. In this case, it sends a SQL statement to a yet another service, the '''SQL service'''. This service will handle connecting to the database and the rest. | ||
=== Create a new AbstractDerbySqlService === | === Create a new AbstractDerbySqlService === |
Revision as of 05:41, 8 October 2010
We want to connect to a database. In Scout terms, the client might want to fill a table with data from the database. It calls a service on the server to provide some table data. That service in turn has to get the data from somewhere. In this case, it sends a SQL statement to a yet another service, the SQL service. This service will handle connecting to the database and the rest.
Create a new AbstractDerbySqlService
Go to the server node and open the tree, drill down until Sql Services below Common Services and right click in order to open the wizard to create a new SQL service.Name your new service DerbySqlService and choose AbstractDerbySqlService from the combobox Super Type then click finish.
If the Super Type AbstractDerbySqlService doesn't appear within the combobox, you need to organize your server project's plugin.xml. Go to the Java Perspective, double click on the server project, open the plugin.xml and in the box Required Plug-Ins add the plug-in org.eclipse.scout.rt.jdbc.derby. If the Super Type still does not appear, make sure that the derby.jar is in the lib folder of the Java installation. You can get this library directly from Apache Derby.