Category: Developer News
News from the Firebird developers.
How to protect Firebird databases from ransomware?
Ransomware attacks became the serious problem for many companies: during the last week, we had 3 incidents from different customers which had their Firebird databases encrypted by ransomware viruses. Luckily we were able to help all of them, but the scale of the problem definitely increases.
Read new article: https://ib-aid.com/en/articles/how-to-protect-firebird-databases-from-ransomware/
ADO.NET provider 5.6.0.0 for Firebird is ready
SQL SECURITY clause is now implemented in Firebird git master tree.
SQL Security clause part of SQL Standard (2003, 2011) Feature is implemented in Firebird master git tree.
ADO.NET provider 5.1.1.0 for Firebird is ready
Summary for testing IBProvider with Firebird 2.5
Hello!
Since you already have made a pause in your work and came here, we are offering to you look at the short review of testing Firebird through IBProvider.
http://www.ibprovider.com/eng/news/n_160908.html
With Best Regards,
IBProvider Team
ADO.NET provider 5.1.0.0 for Firebird is ready
Jaybird 3.0.0-alpha-1 release for testing
Jaybird 3.0.0-alpha-1 has been published for testing. We would really appreciate if you could start testing your applications with this version and provide feedback on stability and behavior, but also on the release notes.
Feedback can be sent to the Firebird-java mailinglist or on the issue tracker http://tracker.firebirdsql.org/browse/JDBC.
Jaybird 3.0 is a big change from Jaybird 2.2 and earlier. We have rewritten the entire low-level implementation to be able to support protocol improvements in newer Firebird versions, made changes with a stricter interpretation of the JDBC requirements, and removed some parts that were either obsolete or not functioning correctly.
We recommend that you do not consider Jaybird 3.0 a drop-in replacement for Jaybird 2.2, and study the release notes carefully.
See:
- Release notes
- Release files: Jaybird 3.0.0-alpha-1
Jaybird 3.0 Alpha 1 is available from Maven central:
Groupid: org.firebirdsql.jdbc,
Artifactid: jaybird-jdkXX (where XX is 17 or 18).
Version: 3.0.0-alpha-1
For example:
<dependency> <groupId>org.firebirdsql.jdbc</groupId> <artifactId>jaybird-jdk18</artifactId> <version>3.0.0-alpha-1</version> </dependency>
If your application is deployed to a Java EE application server, you will need to exclude the javax.resource:connector-api dependency, and add it as a provided dependency:
<dependency> <groupId>org.firebirdsql.jdbc</groupId> <artifactId>jaybird-jdk18</artifactId> <version>3.0.0-alpha-1</version> <exclusions> <exclusion> <groupId>javax.resource</groupId> <artifactId>connector-api</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>javax.resource</groupId> <artifactId>connector-api</artifactId> <version>1.5</version> <scope>provided</scope> </dependency>
If you want to use Type 2 support (native, local or embedded), you need to explicitly include JNA 4.2.2 as a dependency:
<dependency> <groupId>net.java.dev.jna</groupId> <artifactId>jna</artifactId> <version>4.2.2</version> </dependency>
External procedures in Firebird in .NET done(-ish)
FB/Java plugin
I’m pleased to release first test version of FB/Java, compatible with Firebird 3.0.0.
https://github.com/FirebirdSQL/fbjava/releases
FB/Java is an External Engine plugin for Firebird that makes Firebird capable of run functions, procedures and triggers made in the Java platform.
It complements Jaybird making it interface with Firebird engine and handling the infrastructure necessary to support user routines.
It also has a client utility with functions to install and uninstall the plugin in a database and that users may use to deploy and undeploy Java classes and resources stored in JAR files to a database.
Bugs should be filed in the github project.
This test version uses a modified snapshot of Jaybird 3.0.
Adriano