I highly recommend Tyler Muth's logger.
Home
Welcome to OraLog Home Page
OraLog is a logging framework for Oracle database developers. It was designed having in mind some log4j principles but tailored to the Oracle platform.
The main features of OraLog framework are:
- Custom log levels.
- Extensibility through custom appenders.
- Logs management using a publish-subscriber approach.
In addition, a graphical user interface is provided which may be used to configure various logging profiles and to receive log entries according to the selected log appender (see some screenshots).
IMPORTANT NOTE:
Don't forget to copy the %ORACLE_HOME/jdbc/lib/ojdbc14.jar file to [OraLog Installation Directory]/plugins/ro.fits.joralog.drivers_X.X.X/lib/ directory. If lib subdirectory is not there please create it. If you cannot find the ojdbc14.jar file within your oracle installation than please install JDBC interfaces/Java Client from within Oracle Universal Installer.
Latest News
November 02, 2007
The OraLog 1.2.0 is released. You can download it here. This release contains:
- Bug Fixes:
- When closing and reopening an appender view an error was raised.
- Installation scripts were not properly included.
- If the user profile directory was not previously created then no settings could be stored.
Latest News
September 27, 2007
The OraLog 1.1.0 is released.
- General Improvements:
- A new pipe appender.
- CTRL+A to select all content of the install/upgrade/uninstall script or log.
- Change the container for "If OraLog user was not created yet, expand this to see how to create it." to Text just to have the possibility to copy&paste from there.
- Bug Fixes:
- When using logs with {n} placeholders, the actual values for them could not exceed 4000 characters (thanks to BUA).
- When the table appender is receiving logs and the application is closed then a SWTException is thrown.
- Stopping the table appender may freeze the whole application with 100% CPU load (thanks to VEG).
The OraLog 1.0.9 is released. This release contains:
- General Improvements:
- A new operation which allows installing OraLog server side objects.
- Bug Fixes:
- Closing a socket appender view will stop monitoring threads on other views (thanks to VEG).
- Closing the "Subscription Management" view without disconnecting doesn't close the old database connection (thanks BUA).
- Every message box had the "Message from SWT" caption which was not appropriate.
- If "Disable on first error" is false and an error is raised this error is not written into log alert or into the "last error" field of the log subscriptions table.
- Opening a new "Table Appender" view doesn't show log profiles.
September 14, 2007
The OraLog 1.0.8 is released. This release contains:
- General Improvements:
- A brand new "Automatic Updates" feature.
- Added an "About" dialog.
- Bug Fixes:
- Replace all "JOraLog" references with "OraLog".
Note: Please uninstall the old version and manually delete the remaining files under the OraLog installation location (the default path is "Program Files\OraLog").
September 12, 2007
The OraLog 1.0.7 is released. You can download it here. This release contains:
- General Improvements:
- A new "Options" command which allows configuring: fonts, colors etc.
- Split OraLog commands in two menus: "Management" and "Appenders".
- Menu on tray icon (just the Exit command for the moment). Thanks to VEG.
- The possibility to configure if, by default, the control panel for Table/Socket appenders to be shown when the view is opened.
- The possibility to configure how often the Table appender should check the log table for new entries (interval in milliseconds).
- When starting socket/table appender the "Start" button becomes "Stop" and vice-vers. Thanks to Altblue.
- When an appender is de-activated as a consequence of an error, that error is now also written into the log alert table. This make it easy, for example, to copy/paste the error message from "Log Alert" pane.
- Bug Fixes:
- Fix the view secondary name which caused the table/socket appender views not to open from the first time if there were previously saved instances of the same views.
- The images from Table/Socket appender views were not properly disposed.
- In "Subscriptions Log Management" if you try to connect to a database and encounter an error the subsequent logins to other databases will fail. (Thanks to BUA).
- The log pane doesn't show a horizontal scroll bar which is required especially if the "word wrap" option is disabled. (Thanks to BUA).
- Closing a SOCKET appender view does not stop the monitor thread causing "***** Address already in use: Cannot bind". (Thanks to BUA)
- Even if the "Disable on first error" option was unchecked the corresponding log profile still get disabled. (Thanks to BUA)
September 04, 2007
The OraLog 1.0.6 is released. You can download it here. This release contains:
- General Improvements:
- Redesign of the "Log Subscriptions Management".
- Within a log profile you can now choose either to disable the subscription if an error is raised by the corresponding appender or to force the profile to remain enabled.
- The version of the application is now displayed into the window caption.
- Remove deprecated methods from code.
- Add the intro page.
- Add supplemental instrumentation to Oralog classes.
- Add link to "silk" icons into the "license" directory.
- Bug Fixes:
- Key binding was not working;
- After start, stop and once again start listening in "Table Appender" view, no more log entries were written;
- The correct version was not shown in the installer;
- The installer incorrectly advice to copy "ojdbc.jar" file instead of "ojdbc14.jar" file.
- In case of errors the appender was not deactivated.
29 August 2007
The OraLog 1.0.5 is finally released. This release contains:
- The OraLog Monitor which may be used to monitor logs and manage logging profile through a friendly GUI.
- A new socket appender for non-persistent logs.
- Various bug fixes into OraLog CORE.