powered by Jive Software

Incompatibility issue with FirebirdSQL

I’‘m creating anew topic for this issue. Hope it’'s ok.

After installing the FirebirdSQL jdbc driver, I couldn’'t log in to the admin console anymore.

After looking at the error.log, I figured it out. In Firebird, some words are reserved and must be referenced with double quotes if used as column names. So everytime JM executes a select with for example “password” in it, it fails due to an exception.

A list of FirebirdSQL reserved names used in the JM database:

password, value, message, domain, time

Is it possible to cater for this? Is it possible to make a plugin for this (in case I have to do it myself)?