Investigate options to package Firebird embedded in a 'self-deploying' jar. [JDBC533]

[firebird-automations]

Submitted by: @mrotteveel

Firebird Embedded is rather complicated to deploy correctly. It would be helpful if it is possible to deploy as a single jar, which is then extracted appropriately on first use (or maybe explicit init). The MongoDB Embedded library does something similar, see https://github.com/flapdoodle-oss/de.flapdoodle.embed.mongo

Also notify https://github.com/dbeaver/dbeaver/issues/3397 when this is available.

Commits: FirebirdSQL/jaybird@fddb4ae716ea3fdd29ddbabcd9a2b517458a70c5 FirebirdSQL/jaybird@9028f2ce8d569201bf3667ec386c52cc2e447af7

[firebird-automations]

Modified by: @mrotteveel

Fix Version: Jaybird 5 [ 10871 ]

Fix Version: Non-version tasks [ 10870 ]

description: Firebird Embedded is rather complicated to deploy correctly. It would be helpful if it is possible to deploy as a single jar, which is then extracted appropriately on first use (or maybe explicit init). The MongoDB Embedded library does something similar, see https://github.com/flapdoodle-oss/de.flapdoodle.embed.mongo => Firebird Embedded is rather complicated to deploy correctly. It would be helpful if it is possible to deploy as a single jar, which is then extracted appropriately on first use (or maybe explicit init). The MongoDB Embedded library does something similar, see https://github.com/flapdoodle-oss/de.flapdoodle.embed.mongo

Also notify https://github.com/dbeaver/dbeaver/issues/3397 when this is available.

[firebird-automations]

Commented by: @mrotteveel

Initial implementation in https://github.com/FirebirdSQL/jaybird/commit/9028f2ce8d569201bf3667ec386c52cc2e447af7, but it needs further refinement.

[firebird-automations]

Modified by: @mrotteveel

Fix Version: Non-version tasks [ 10870 ] =>

[firebird-automations]

Commented by: @mrotteveel

Further refinement in https://github.com/FirebirdSQL/jaybird/commit/fddb4ae716ea3fdd29ddbabcd9a2b517458a70c5

[firebird-automations]

Commented by: @mrotteveel

Specification https://github.com/FirebirdSQL/jaybird/blob/master/devdoc/jdp/jdp-2020-05-firebird-embedded-locator-service-provider.md

[mrotteveel]

For the Linux build, ensure that libtommath.so.0 is included

[mrotteveel]

Probably needs a custom build that includes libtommath and libtomcrypt.

[mrotteveel]

I marked the JDP and feature as experimental for Jaybird 5.

[mrotteveel]

Experimental variant for Windows (x86-64): https://github.com/mrotteveel/jaybird-embedded-win32-x86-64