Skip to content Skip to navigation

jOdra2-IDE Release 2006.12.02-01


Rozmiar pliku: 2,95 MB

jOdra2-IDE Release 2006.12.02-01

(C)2006 Mariusz Trzaska

This is a prototype version of IDE (Integrated Development Environment) for jOdra2.


1. The IDE is build around jEdit – programmer’s text editor. The most important features:
• Unlimited undo/redo,
• "Markers" for remembering positions in files to return to later,
• Any number of editor windows may be open, each window may be split into several areas, each area can view a different file. Alternatively, different locations in one file can be viewed in more than one area
• Syntax Highlighting
• Intelligent bracket matching skips quoted literals and comments
• Auto indent
• Commands for shifting the indent left and right
• Commands for commenting out code
• Soft tabs option
• Abbreviations
• Folding, with two fold modes: indent-based, and explicit (where the buffer is parsed for "{{{" and "}}}")
• Advanced Search and Replace
• File Management
• Customization
• Extensibility
2. Current version works with SBQL/XML/TXT files, which are correctly processed. Highlighting schema has been defined following SBQL sample files. Thus it could be changed in the future (especially when SBQL strict syntax will be defined).
3. Extending of the jEdit is done by utilizing plugins and changes to the source code.

Installing and running

1. Install Java JRE or JDK. You can download it from: “”
2. Extract the downloaded archive.
3. Run “jOdra2-IDE.jar”. If “.jar” is not properly associated try this: \javaw.exe -jar \jOdra2-IDE.jar.
4. The IDE is shipped with the most current version of jOdra2. However you can update the jOdra2 library manually by replacing appropriate jars in “IDE-libs” directory.

General information

1. The left panel contains “Project Explorer”, which allows viewing and manipulating workspace/projects files/structure. Each item has its own context menu (right click). Some options could be called from a few places, i.e. context menu and main menu.
2. The bottom panel contains “Messages” showing i.e. compilation errors.
3. Main part occupies text editor allowing writing source code of your SBQL programs.
4. Every window can be minimized (just click on its name), undocked/docked (see menu “under” the small triangle).
5. The last two icons on the right part of the toolbar allow building default project or executing query (running it).

Sample use case scenarios

1. Creating a project
Select menu Project/New Project or appropriate context menu of Workspace. Then give a name and select a project’s directory. The structure is as follows: first is a workspace which can contains unlimited number of projects. A project contains a jOdra2 server and files (SBQL, XML, TXT).
2. Creating a new file
Select “Create a new file” from project’s context menu. Then enter a file’s name. A new file will be created and placed in the project’s directory.
3. Adding an existing file
Select “Add an existing file” from project’s context menu. Then select a file. Selected file will be added to the project’s structure, but will not be copied to the project’s directory. Try two sample files located in “_SampleFiles” directory.
4. Starting a server.
Every project requires SBQL server to work. You can start a default one or connected to the existing one.
5. Building a project
Select “Build” from project’s context menu. If project’s server is not running, the default one will be started. After the compilation, there will be some messages in the “Messages” panel (bottom of the screen). If there will be errors/warnings, you can open appropriate file by clicking error description. Note then a line with the error is highlighted. Try to compile sample files and introduce some errors to see what will happen.
6. Debugging/Running a project
Select “Debug” from project’s context menu. This functionality allows executing a query (or running a method from a module). First enter (or select from the combo box) the module name and then a query code (method name). In case of sample files you can enter: “admin.procedures” as a module name and “proc();” as a procedure name (without quotation marks). A result of the query will be shown in a tree-like control. It is possible to open/close particular nodes containing detailed information. Notice that it is also possible to copy selected node to system clipboard as a text (using context menu).
7. Saving/Loading workspace
Select “Save/Load Workspace” from workspace’s context menu. Currently workspace remembers projects and its files as absolute paths. This approach will be probably changed in the future (because of problems with moving projects).
8. Viewing database server content
Select “DEBUG: Dump store” from server’s context menu. A simple window with textual version of server content will be shown. Next versions of jOdra2-IDE should use more user-friendly tree-like view.
9. Showing modules content.
Select “Reload” from modules’ context menu. All modules and sub-modules (with their content) are shown in the tree.
10. Connecting to existing server
Create or load a project. Then, using server's node context menu, select "Connect to existing". Enter necessary information and press Connect button.
11. Import data from an XML file using a plugin
Create a new project and run a server. Then select “Import data using plugin” from server’s context menu. Choose a plugin (i.e. “XMLImporter”), a file (i.e. “_SampleFiles\XML\bookstore.xml”), a module (i.e. “admin”) and enter necessary parameters. After a while you should see a message telling that there were no errors. Note that, in case of the sample file, a new Data section (“bookstore”) has been created under module admin. It is also possible to execute a query running on imported data i.e.: “bookstore;”.


jOdra2 files (including the IDE): “”
jOdra2 SVN repository: svn://
More information about SBA/SBQL:
ODRA project forum (mainly in polish):
More information about jEdit itself:

Feel free to send me comments/remarks.


jOdra2-IDE Release 2006.12.02-01
1. Query window is integrated with the rest of the windows (no longer modal).

jOdra2-IDE Release 2006.12.01-01
1. Some minor language fixes.
2. File chooser remembers the last selected path.
3. Added an option for copying query result to clipboard as an XML.

jOdra2-IDE Release 2006.11.23-01
1. Chnges to processing query results.
2. Some minor refactorings.

jOdra2-IDE Release 2006.11.21-01
1. Fixed problem with executing queries (caused by changes in DBRequest.EXECUTE_SBQL_RQST).
2. Changed the loction of a default server file (now it is the same folder where jOdra2-IDE.jar is located).
3. Added a new mode for showing query results ("XML mode" which is more user friendly - hides internal structure of the query result).

jOdra2-IDE Release 2006.11.08-01
1. Default Look&Feel has been changed to "MetalLookAndFeel" (important in case non Windows OS). It is always possible to change current L&F using editor's options: Utilities/Global options/Appearance --> Swing L&F.
2. XML test files has been added (included XQuery use cases) - see "_SampleFiles\XML" directory.
3. Added a new functionality allowing copy query results to system clipboard using context menu.

jOdra2-IDE Release 2006.10.27-01
1. Added functionality allowing importing data using plugins. Currently only the XML plugin is shipped.

jOdra2-IDE Release 2006.09.28-01
1. Added "Connect to existing server" functionality.
2. Some minor improvements.

jOdra2-IDE Release 2006.09.26-01
1. Build status information has been moved to the main status area (from messages window).
2. A context menu has been introduced in the messages window (and "remove all messages" button has been replaced by the appropriate menu).
3. A new "Execute query" functionality has been added. It allows to see query results using tree structure.

jOdra2-IDE Release 2006.09.01-01
1. Changed jar-libs names.
2. Shows modules (and their content) on the server.
3. Adding multiple files to the project in one step.

jOdra2-IDE Release 2006.08.24-01
1. Initial release