Requirements
J2RE 1.5 or later.
FrontBase JDBC driver 2.5.7 or later (included).
On OSX the manager is available as a standard application
bundle and can be double-clicked to start. The JDBC driver is already installed
as part of the application bundle.
The manager requires version 2.5.7 of the JDBC driver or
later. If you are using an earlier version of the JDBC driver then please
update it with the version that ships with this release of FrontBaseJManager.
The frontbasejdbc.jar must be placed in the same directory as the
FrontBaseJManager.jar file or copied to the Java extensions folder.
The FrontBaseJManager.jar file can be double clicked to
start the application. You can also start the application from the command line
by using,
java -jar FrontBaseJManager.jar
Currently there is no documentation but the most of the
functionality follows from that provided in FrontBaseManager.
You must be running a 4.2.4 or later version of the
FBExec for this to work.
From this pane you can only list backups contained in the
default location, i.e. the Backups folder of the FrontBase installation. Only
backups created with the default filename in the form B_YYYY_MM_DD-HH_MM_SS
will be listed. When a database is selected then it's backups are displayed in
order of the most recent. You can create, restore and delete backups from this
panel. Also the list will mark backups which have expired either because they are
older than the backup expiry limit or older than a specified date. You can then
delete all expired backups. These expiry settings are configurable from the
preferences panel. By default no backups expire.
Please report any new bugs or comments to
support@frontbase.com.
OSX 10.5.1.
J2RE 1.5.0_13
OSX 10.4.11. J2RE
1.5.0_13
Win2000.
J2RE 1.6.0_03
WinXP.
J2RE 1.6.0_03
RedHat 9 (GNOME). J2RE 1.6.0_03
á
Enter autostart management for the first time.
Sometimes asks to save changes, even when none occur.
á
Moving
columns on edit and new table panels causes the SQL statement generated to be
wrong.
á
Uploading
CLOBs is restricted by available memory.
á
The
connection and table pane headers are not shown on Leopard 10.5.1.
á
Cluster management (needs to be added to JDBC).
á
Delete and Rename objects from Edit menu.
á
View menu items.
á
Add Open Content/Definition to database menu.
á
Documentation into Help menu.
á
Add timeout to monitored hosts.
á
Store User
names for unmonitored host and database combinations.
á
Cancel edit mode for text fields when return pressed.
á
Support multiple result sets from SQL pane.
á
Add transaction state messages to connection frame.
á
Support prompting for FBExec passwords when required.
á
Expired column should be first by default on Backup
Management pane.
á
Import a local file to a remote server.
á Support for "Force Quit Agent" and "Interrupt Operation" on Usage pane.
á License pane now works with embedded FrontBase.
á
Improved the look and feel on Leopard.
á
Imports were failing to import UTF-8 characters
correctly.
á
Schema objects containing UTF-8 characters were not
displayed correctly.
á
Table columns were initially being resized to fit view
window on SQL result, table contents, etc.
á
Delete was removing text from the wrong side of the
cursor and acting like BackSpace.
á
Table rendering has problems with last column not being
expandable.
á
New Schema pane; components are misaligned (Windows).
á
Result set binary/LOB values are not dereferenced as in
the content pane.
á
Start database/advanced/stop should be disabled for an
unknown database.
á
New database should display any errors.
á
Preference Panel is sometimes not added and removed
from windows menu.
á
Open, New and Restore database are only active from
main monitor window.
á
On non-mac platforms Null and CLOB values should be
highlighted in white when a row is selected.
á
The viewport containing the privilege table for views,
procedures and functions should match the tables background (Windows).
á
New view, procedure and function panel should be
larger, resizable and omit horizontal scrollbar.
á
Add SQL highlighting to new view, procedure and
function.
á
Table columns can be resized correctly and moved.
á
Database is identified as database name in frame titles
and not catalog name
á
TINYINT and LONGINT keywords are not being highlighted
in SQL pane.
á
Reselecting current history line on doesn't copy to SQL
pane.
á
Edit table and new table panel. Putting an invalid
numeric value into precision, scale, etc causes exception and panel to display
N/A which is not editable.
á
Don't allow already monitored databases to be added or
available to monitor.
á
Fixed Execute SQL not working from Database menu.
á
Basic edit menu items and undo/redo for all text
components.
á
Commands show execution time.
á
Correct focus handling, e.g. list lines are grayed out
when not focused.
á
Close Window on File menu.
á
SQL Interpreter pane now supports double click/enter on
history line and a shortcut key to execute a statement.
á
Set OK as default button on simple login and Open
Database panels. (Cancel edit mode for text fields when return pressed).
á
Added cancel on escape to some simple dialogs.
á
Monitor panel. Can select multiple databases to
demonitor on monitor panel.
á
A host can be removed via the add monitored database
dialog.
á SQL
history now correctly displays statements with multiple lines on Windows.
á Dropping
a check, foreign key, index, full text index and unique constraint was dropping
the wrong constraint when there were more than one available to drop.
á Execute
From File and ÔscriptÕ command.
á The
SQL history can now display the first line only (the default) or all lines in a
multiple line statement. This can be changed via the Preferences panel.
á
Now formats hours, minutes, seconds on usage pane
times.
á Now
formats byte size on BLOB/CLOB and backups.
á Transaction
duration is always NONE on usage pane.
á A
re-fetch on a result set was not clearing previous result.
á Adjusting
columns when table column count has changed was raising exception.
á Backup
management was not drawing connection errors with correct background colour for
non-mac.
á Adding
a replication client now works.
á
Improved performance when loading Table Pane.
á
Removed escape characters from error and log.
á
SQL history retained once session is closed.
á
Add keyword highlighting to SQL pane.
á
Restore database.
á
Import. Current limitation is that it is not possible
to import a local file to a remote server.
á Auto
refresh in extract usage doesn't terminate when
á connection
frame is closed.
á Single
quotes in table content update and insert row are not escaped.
á Added
support for extract/describe commands.
á Double
click on table column definition will open edit pane.
á Finished
menu shortcuts.
á Added
printing support.
á Added
menu bars to all frames on non-Mac platforms.
á Added
fetch limiting and batching to result and content panel.
á Added
Backup Management panel and expiry options to Preferences.
á There
is a pending transaction which needs removing before a table is first edited.
á
Create Full Text Index should only list char columns.
á
Create Full Text Index misaligns with long column
names.
á
Insert Table Row should place edit focus on first
value.
á
Create Check constraint. Remove scrollpane on text
area.
á
Double click Upload CLOB after already selected value
will toggle entry to NULL. (Windows)
á
Collation pane does not hide/close when collation
created.
á
Creating a procedure relists functions in objects pane
not procedures.
á
Procedures listed on schema object pane does not
disabled Open Content button.
á
Create view panel should only enable CREATE button once
VIEW is specified.
á
Can't clear invalid options from Start Database
Advanced.
á
Usage Pane. Refresh clears refresh box.
á
Drop table is not prompting to alter transaction mode.
á
Null binary columns are returned as <null>.
á
Connecting on port should display database/catalog name
in connection pane title.
á
Procedure panel does not resize when containing window
is resized.
á
Scroll bar on error dialog is not drawing when line
count is 10.
á
Enter
on running database now acts as double click and prompts for connect.
á
View
definition columns are not displayed in order of definition but alphabetically.
á
Improved look and feel support on Linux.
á
Can't
connect direct to port.
á
Can't
open database unless database name selected.
á
Connecting
to an unmonitored database caused dummy entries in monitored databases.
á
License
pane in connection frame will not redisplay.
á
Usage
pane does not list null connections.
á
Usage
entries are in the wrong order.
á
Create Full Text Index display problems on XP.
Colin Richardson.
26th March 2008.