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.
Scout/Tutorial/3.7/Minicrm/Set up SQL Service
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.
Eclipse Scout comes with support for Apache Derby, PostgreSQL, and Oracle out of the box. Switching to other solutions like Hibernate possible, but is beyond the scope of the tutorial. (Essentially you'll need to use Hibernate beans instead of the FormData objects Eclipse Scout provides for you to communicate between client and server.)
We will use Apache Derby in this tutorial. Derby is an open source relational database implemented entirely in Java and available under the Apache License.
Create a new AbstractDerbySqlService
Go to the server node and open the tree, drill down to 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.
Change default configuration settings
Adjust the default settings in your DerbySqlService by editing the Jdbc Mapping Name, this should point to the folder where you unzipped the DerbyDb to. As username/password use minicrm/minicrm.