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/Database Development Perspective"

< Scout‎ | Tutorial‎ | 3.7
(Replaced content with "The Scout documentation has been moved to https://eclipsescout.github.io/.")
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{ScoutPage|cat=Tutorial}}
+
The Scout documentation has been moved to https://eclipsescout.github.io/.
 
+
=Configure the Database Development View =
+
==Add new Derby Connection==
+
Open the ''Database Development'' perspective, right click on ''Database Connections'' and call the wizard for adding a new database connection by clicking on the context menu ''New...''.<br/>[[Image:Db_1.png|left]]<br clear="all" />
+
From the list of available connection profiles, choose ''Derby''.
+
<br/>[[Image:Db_2.png|left]]<br clear="all" />
+
 
+
==Specify Driver Details==
+
Open the driver deteail editor by clicking on  the round icon to the right of the ''Drivers'' combobox.
+
<br/>[[Image:Db_3.png|left]]<br clear="all" />
+
Choose the embedded derby driver for version 10.2.
+
<br/>[[Image:Db_4.png|left]]<br clear="all" />
+
 
+
Go to the tab ''Jar List'' and there specify the location of the ''derby.jar''. If you don't have any, download it (from the official derby website: http://db.apache.org/derby/, it's inside the zip file) or download the [[Media:TutorialMiniCrmWorkspaceDerbyDB.zip|TutorialMiniCrmWorkspaceDerbyDB]] and click on ok to leave this page.
+
<br/>[[Image:Db_5.png|left]]<br clear="all" />
+
<br/>[[Image:Db_6.png|left]]<br clear="all" />
+
<br/>[[Image:Db_7.png|left]]<br clear="all" />
+
 
+
Add the path to your ''DerbyDb'' along with the login data (for the minicrm: minicrm/minicrm).
+
<br/>[[Image:Db_8.png|left]]<br clear="all" />
+
 
+
When you have entered all the required data, click on ''Test connection'' in order to test the connection details you just entered. If everything is fine there will be a message box ''Ping succeeded''.
+
<br/>[[Image:Db_9.png|left]]<br clear="all" />
+
 
+
Now you can browse through the DerbyDB, modify tables, data, run statements and much more. Please be aware that '''you cannot have more than one connection to your DerbyDb''', therefore either you browse through it in the database development view or you access it using the minicrm, therefore you need to manually '''disconnect''' from the database before you can run your application.
+
<br/>[[Image:Db_10.png|left]]<br clear="all" />
+
<br/>[[Image:Db_11.png|left]]<br clear="all" />
+

Latest revision as of 07:24, 18 March 2024

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

Back to the top