Skip to content Skip to navigation

jOdra2-IDE Release 2006.09.01-01


Rozmiar pliku: 2,15 MB

jOdra2-IDE Release 2006.09.01-01

This is a prototype version of IDE 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 debugging (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 running a method from a module. First enter the module name and then a 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). As a result a simple window will be shown.
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.


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:


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