FTLDB v1.5.0

Changelog

Version 1.5.0

• Resolved issues #26, #27, #28 (added templates stored as Java resources, unified template names for server/client-side).
• Resolved issue #24 (added new template FTL directive).
• Resolved issue #25 (unified statement separation for server/client-side)
• Resolved issue #19, #31 (reorganized FTL standard macro libs).
• Resolved issue #33 (got rid of implicit grants to PUBLIC in installer).
• Resolved issue #30 (got rid of redundant Dynamic SQL in SOURCE_UTIL package).
• Fixed bug #29 (cannot replace named section with piece longer than 32Kb).
• Fixed bug #35 (user defined include macro doesn't work properly).
• Fixed bug #36 (shell command execution hangs).
• Fixed bug #37 (incorrect loop in function ftldb.Configurator#newConfiguration()).
• Updated README and documentation.
• Incompatible changes:
  • standard FTL macro libs changed their names to std.ftl and orasql.ftl, stored as Java resources in FTLDB schema, local synonyms should be recreated for backward compatibility;
  • some methods in orasql.ftl changed their names and signatures, varargs replaced with sequences of arguments;
  • default template loader class in client-side mode is ftldb.ResourceTemplateLoader.

FTLDB v1.4.1

Changelog

Version 1.4.1

• Fixed bug #21 (unable to init FTLDB on Oracle 12.1).

FTLDB v1.4.0

Changelog

Version 1.4.0

• Fixed bug #10 (unable to install more than one copy of FTLDB to a database).
• Completed issue #11 (migrate to FreeMarker v2.3.23).
• Completed issue #13 (enable template caching in Oracle DB template loader).
• Completed issue #14 (make FreeMarker configuration more flexible).
• Completed issue #15 (create wrappers for SQL types in FTL).
• Completed issue #16 (create a wrapper for ResultSet in FTL). [breaking change]
• Completed issue #18 (create methods for getting FreeMarker version from PL/SQL).
• Updated README and documentation.
• Deprecated methods (may be removed in v1.5.0):
  • iif FTL function in standard.ftl macro library - use the new ?then boolean built-in;
  • decode FTL function in standard.ftl macro library - use the new ?switch built-in;
  • get_column FTL function in sql.ftl macro library - use the new FetchedResultSetModel wrapping model and its methods;
  • set(String, Object) and clear(String) methods of shared_hash variable - use the usual put(String, Object) and remove(String) Map methods correspondingly;
  • hash_rows, seq_rows, col_hash, col_seq methods of ResultSet wrapping model - use the new FetchedResultSetModel wrapping model and its methods.
• Incompatibly changed methods:
  • col_meta_seq, col_meta_hash methods of ResultSet wrapping model - use the new FetchedResultSetModel wrapping model and its methods.

FTLDB v1.3.0

Changelog

Version 1.3.0

• Fixed issue #8 (add methods for calling shell commands from FTL environment).
• Fixed issue #9 (add API methods for getting FTLDB version).
• Added shared_hash collection to FTL configuration instead of confusing global_context variable.
• Updated README and documentation.

FTLDB v1.2.1

Changelog

Version 1.2.1

• Fixed issue #1 for Oracle 11+ (spontaneous invalidation of Java classes loaded into the FTLDB schema).
• Fixed issue #2 (execution privileges for the installation shell scripts).
• Updated README.

FTLDB v1.2.0

Changelog

Version 1.2.0

• Migrated to FreeMarker v2.3.22.
• Fixed a bug in the #include directive processed by DBTemplateLoader (the ignore_missing option doesn't work).
• Fixed a bug in the named section extractor (cannot find a section with the $ symbol in its name).
• Replaced the .template_name built-in variable with the template_name() function due to changes in its behavior in the new FreeMarker version.
• Removed the stringify() function due to its uselessness in the new FreeMarker version.
• Reviewed security: Java permissions are granted only to specified database users. Added a shell-script for granting Java permissions.
• Attached the Java & PL/SQL API documentation to the installation archive.
• Updated README.

FTLDB v1.1.0

Changelog

Version 1.1.0

• Unified work with parameterized templates in server-side and client-side environments using template_args sequence.
• Added different installers and uninstallers for DBAs and ordinary users.
• Added server-side demos.
• Added the ftl directory to the installation archive with standard templates for the client-side work.
• Fixed a lot of bugs everywhere.
• Updated README.

Version 1.0.0

First public release. Removed from public access due to lots of bugs :)