Skip to main content

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.

Jump to: navigation, search

Scout/Tutorial/4.0/Minicrm/Set up SQL Service

< Scout‎ | Tutorial‎ | 4.0‎ | Minicrm

The Scout documentation has been moved to https://eclipsescout.github.io/.

Note.png
Scout Tutorial
This page belongs to the Minicrm Step-by-Step Tutorial. Previous step: Get example database.


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 which provides the desired data. That service in turn has to get the data from somewhere. In this case, it sends a SQL statement to 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 out of the box. Support for PostgreSQL and Oracle is trivial to add (For more information, see: The Scout documentation has been moved to https://eclipsescout.github.io/.). Switching to other solutions like Hibernate is possible, but beyond the scope of the tutorial.

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 on it in order to open the wizard to create a new SQL service.

Scout.3.9.minicrm.new sql service.explorer.png

Name your new service DerbySqlService and choose AbstractDerbySqlService from the combobox Super Type then click Finish.

Scout.3.9.minicrm.new sql service.wizard.png


Change default configuration settings

Adjust the settings in your DerbySqlService by editing the Jdbc Mapping Name. It should point to the folder where you unzipped the DerbyDb to. That's the example database you downloaded at the beginning of this tutorial.

Also make sure you have the right Jdbc Driver Name set by org.apache.derby.jdbc.EmbeddedDriver.

Use minicrm for both username and password.

Scout.3.9.minicrm.new sql service.properties.png

Note.png
Escape Backslashes
Make sure you escape backslashes if you're working on Windows.

Back to the top