|
|
Line 1: |
Line 1: |
− | {{ScoutPage|cat=Tutorial 3.7}}
| + | The Scout documentation has been moved to https://eclipsescout.github.io/. |
− | {{note|Scout Tutorial|This page belongs to the [[{{BASEPAGENAME}}_Step-by-Step|Minicrm Step-by-Step Tutorial]]. Previous step: [[{{BASEPAGENAME}}/Get example database|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 [http://db.apache.org/derby/ Apache Derby] out of the box.
| + | |
− | Support for [http://www.postgresql.org/ PostgreSQL] and [http://www.oracle.com/de/products/database/index.html Oracle] is trivial to add
| + | |
− | (''For more information, see: {{ScoutLink|HowTo|Write_a_jdbc_connection_bundle|How To write a JDBC connection bundle}}'').
| + | |
− | Switching to other solutions like [http://www.hibernate.org/ 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.
| + | |
− | | + | |
− | [[Image:SqlServiceWizard.jpg|SqlServiceWizard.jpg]]
| + | |
− | | + | |
− | Name your new service ''DerbySqlService'' and choose ''AbstractDerbySqlService'' from the combobox ''Super Type'' then click ''Finish''.
| + | |
− | | + | |
− | [[Image:Newsqlservice.png|Newsqlservice.png]]
| + | |
− | | + | |
− | {{warning|Missing Derby Support|If the Super Type ''AbstractDerbySqlService'' doesn't appear within the combobox, you need to organize your server project's ''plugin.xml''. Switch to the Java Perspective, double-click on the server project, open the plugin.xml file, 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 [http://db.apache.org/derby/ Apache Derby].}}
| + | |
− | | + | |
− | [[Image:Serverplugin.jpg|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 {{ScoutLink|Tutorial|3.7/Minicrm/Get example database|at the beginning of this tutorial}}.
| + | |
− | | + | |
− | Also make sure you have the right '''Jdbc Driver Name''' set.
| + | |
− | | + | |
− | Use '''minicrm''' for both '''username''' and '''password'''.
| + | |
− | | + | |
− | [[Image:Derbydb.jpg|Derbydb.jpg]]
| + | |
− | | + | |
− | {{warning|Escape Backslashes|Make sure you escape backslashes if you're working on Windows.}}
| + | |