Skip to main content

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.

Jump to: navigation, search

Difference between revisions of "Scout/Tutorial/3.7/Minicrm/Set up SQL Service"

< Scout‎ | Tutorial‎ | 3.7
(Change default configuration settings: backslashes)
m (Link to the next section)
Line 6: Line 6:
  
 
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.
 
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.
 +
 +
Once you have your SQL Service you're ready to {{ScoutLink|Tutorial|Write The First Page|write the first page}} of your application
  
 
== Create a new AbstractDerbySqlService ==
 
== Create a new AbstractDerbySqlService ==

Revision as of 08:12, 8 October 2010

Note.png
Scout Tutorial
This page belongs to the 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 The Scout documentation has been moved to https://eclipsescout.github.io/. 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.

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.

Once you have your SQL Service you're ready to The Scout documentation has been moved to https://eclipsescout.github.io/. of your application

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.

SqlServiceWizard.jpg

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

Newsqlservice.jpg

Warning2.png
Missing Derby Support
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, go to the Dependencies tab and add the plug-in org.eclipse.scout.rt.jdbc.derby to the Required Plug-Ins. 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.


Serverplugin.jpg

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 The Scout documentation has been moved to https://eclipsescout.github.io/..

Use minicrm for both username and password.

Derbydb.jpg

Warning2.png
Escape Backslashes
Make sure you escape those pesky backslashes if you're on Windows.

Back to the top