Jaybird 4.0.7 released

Jaybird 4.0.7 has been released

The following has been changed or fixed since Jaybird 4.0.6:

  • Improvement: (VAR)CHAR is now sent to the server with blr_varying2 or blr_text2 which includes the character set information (jaybird#692)
  • Changed: Usages of String.toUpperCase and String.toLowerCase now use Locale.ROOT to prevent locale-sensitivity issues (jaybird#697)
  • New feature: Support for NBackup “clean history” option (jaybird#706)
    The org.firebirdsql.management.NBackupManager interface has three new methods: setCleanHistory(boolean) to enable (or disable) cleaning of history during backup, and setKeepDays(int) and setKeepRows(int) to specify the number of days or rows to keep history. These options require Firebird 4.0.3 or higher.
    This feature was backported from Jaybird 5.
  • Fixed: Calling PreparedStatement.setClob or PreparedStatement.setBlob with a null Clob, Reader, Blob, or InputStream would result in a NullPointerException (jaybird#712)
    As part of this change the behaviour of setClob methods accepting a Reader was changed to be identical to setCharacterStream, and setBlob accepting an InputStream to setBinaryStream. The end result before and after this change is identical, but it can result in different memory and performance characteristics, as the stream is now consumed on execute, and not on set.

Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11, 17 and 19 (support for Java 17 and using the Java 11 version of the driver).

See also

IBProvider News

Hello Everyone!

We came back with new releases 🙂

We have just finished the large revision of our components and we are really glad to announce the following new versions:

  • LCPI EF Core Provider for OLE DB v6.0.8
  • LCPI IBProvider v5.26
  • LCPI OLE DB Services v1.21

You can read about changes in these components at our website – https://www.ibprovider.com/eng/news/n_221110.html

Only for visitors of this resource. We restored our store at PayProGlobal and we would like to test it 🙂

Everyone who will buy or renew a license for IBProvider 32/64bit till the end of this month will get two years of free updates.

With Best Regards, IBProvider Team.

Database Workbench 6.1.2 available now!

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 6.1.2″

This release brings support for the latest MariaDB and Oracle versions, as well as additional
features for other database systems.

The initial version 6 release includes many improvements to the user interface and existing tools,
it also brought full Firebird 4 support, PostgreSQL table inheritance and Oracle multi-segmented
expression indices support and the Enterprise edition.

Database Workbench 6 comes in 3 different editions with different pricing models, there’s always a version that suits you!

Stored routine debugger Hopper, v2.2 released

Upscene Productions is proud to announce version 2.2.0 of “Hopper”, a stored routine debugger for InterBase, Firebird or MySQL.

This release brings support for Firebird 4 data types and MariaDB 10.3 and up PSQL features.

For more information, check the Hopper page at our website.

About Hopper
Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase. If you use
stored procedures on these database systems, Hopper will be a great tool for debugging
these routines.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been providing
database developers with useful tools for over 20 years. Slowly expanding the product portfolio
and gaining recognition amongst InterBase and Firebird database developers, they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL Server.

New version of RedExpert 2022.05 is available

Added:

  1. Support for Firebird/RedDatabase 4 type
  2. Tablespaces support
  3. Explained plan support for Firebird/RedDatabase 3.0 and higher
  4. Table related triggers tab and navigation
  5. Editing objects in the database browser
  6. Execution of procedures and functions when viewing and editing them
  7. Ability to place the editor vertically or horizontally
  8. Search by text in any SQL-field

Fixed:

  1. Calculating trigger type using bitwise operations
  2. Reloading of system objects after creating a table via GUI
  3. Continue data generation when data mismatch error occurs
  4. Generating SQL for a procedure without parameters
  5. Reloading the object tree during CREATE OR ALTER and RECREATE operations
  6. Autocomplete freeze
  7. Commenting/uncommenting using “CTRL + /”
  8. Generate name for new connection
  9. Display in the center of the primary monitor when there are two monitors in Linux systems
  10. Show connection page without scrollbar
  11. Generate INSERT queries for DEFAULT fields

Download and install the new version

Jaybird 4.0.6 released

Jaybird 4.0.6 has been released

The following has been changed or fixed since Jaybird 4.0.5:

  • Improvement: Connection.isValid(int) now uses the timeout as a network timeout, if possible (jaybird#685)
    This is only supported for pure Java connections. For native connections, the timeout is ignored (and a SQLWarning is registered).
  • NativeResourceUnloadWebListener would fail in Servlet containers with a NoClassDefFoundError if JNA wasn’t on the classpath (jaybird#686)
  • Fixed: Calling isBeforeFirst(), isAfterLast(), isFirst(), or isLast() on a closed result set resulted in a NullPointerException instead of a SQLException (jaybird#689)

Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11 and 17 (support for Java 17 using the Java 11 version of the driver).

See also

Database .NET v34 released

Database .NET v34 is an innovative, powerful and intuitive multiple database management tool.
With it you can easily and intuitive manage all database versions of Firebird (1.5~4.0)
(Free for non-commercial and a single executable file without installation)
Major New features and improvements from 33.5 to 34.0:

https://fishcodelib.com/Database.htm

New version of RedExpert 2022.02 is available

Added:

  1. Edit object button
  2. Password request dialog if password is empty
  3. Ability to work with cursors in a procedure
  4. Downloading updates in the background

Fixed:

  1. Request for saving data when closing a dialog box
  2. Displaying tables on Firebird with version less than 2.5
  3. Generating a function creation request with EXTERNAL NAME
  4. Inability to set the order of the index fields
  5. Incorrect display of dependencies
  6. Wrong generated column edit query when using a domain
  7. Syntax highlighting in views
  8. Recognition of object names in queries if they are at the beginning of a string
  9. Error adding a record with IDENTITY field
  10. Autocomplete errors in queries with aliases
  11. Tab-indexing order on connection page
  12. Wrong error “TABLE is in use” on attempt to remove table
  13. Error opening browser in Linux
  14. Index is active by default when created
  15. Modified the update dialogs
  16. High CPU load after connect
  17. DDL command generation error due to case-sensitive identifiers
  18. Connecting to a database immediately after it is created
  19. Commit transactions after they have been used
  20. Re-executing an SQL script without mandatory commit/rollback after a previous run
  21. Option to set null for string parameters in the parameter dialogue

Download and install the new version.

1 2 3 4 5 6 145