Anti-Spam SMTP Proxy (ASSP) server supports Firebird
You can read more about it from Wikipedia and the announcement from it’s mailing list , and the thread that discussed about Firebird support.
Category: Tools & Products releases
Announcements of new Firebird related products, or new releases.
Jaybird 2.2 #JDBC #Java driver is Released with many fixes
The Firebird JDBC team is happy to announce the release of Jaybird 2.2.0.
This release contains the following changes:
- Enhanced support for JDBC 4.0 (Java 6)
- Support for JDBC 4.1 (Java 7) — including try-with-resources support,
- Implementation of getGeneratedKeys(),
- Enhanced support for the services API,
- Support for 64 bit native libraries for Type 2 / Embedded,
- A number of bug fixes.
Fixes since Jaybird 2.2.0-beta-1:
* ConcurrentModificationException when closing connection obtained from org.firebirdsql.ds.FBConnectionPoolDataSource with statements open (JDBC-250),
* Memory leak when obtaining multiple connections for the same URL (JDBC-249),
* CPU spikes to 100% when using events and Firebird Server is stopped or unreachable (JDBC-232),
* Events do not work on Embedded (JDBC-247),
* Provide workaround for characterset transliteration problems indatabase filenames and other connection properties (JDBC-253),
* FBBackupManager does not allow 16kb page size for restore (JDBC-255),
* Log warning and add warning on Connection when no explicit connectioncharacter set is specified (JDBC-257).
The release is also available on maven(*):
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdkXX</artifactId>
<version>2.2.0</version>
<artifactId>jaybird-jdkXX</artifactId>
<version>2.2.0</version>
The artifactId depends on your target Java version: jaybird-jdk15, jaybird-jdk16 or jaybird-jdk17.
Hopper 1.0.2 released – stored procedure and trigger debugger
 |
Upscene Productions announces a new release of: “Hopper – a Stored Code Debugger” |
Hopper is a Stored Routine and Trigger Debugger, available for Firebird, InterBase and MySQL.
For more information and a trial download, see the news @ Upscene Productions, pricing information is available.
You like this news? Twitter it! Share it! If you’d like to blog about it, contact us!
FlameRobin connection thread test on Windows
I have posted a test version of FlameRobin: http://mghie.users.sourceforge.net/flamerobin_win32_test.zip
(a ZIP file containing only the 32 bit executables for Windows in ANSI and Unicode version) that uses a thread to establish the database connection. That
means that the progress dialog can be moved and cancelled, and the progress bar is updated in indeterminate mode. To see it in action it’s
best to try to connect to a database on a server which is not available or which doesn’t exist, which so far blocks FlameRobin completely until
the connection call times out. It would be great if people could test this and write (to flamerobin-devel) whether anything
breaks for them (it didn’t for me, yet). I’m a little of unsure if I should clean this up and commit…
Thanks
—
Michael Hieke
Firebird Adapter for Php Yii Framework 1.1.x
Hopper 1.0.1 released – stored procedure debugger
|
Upscene Productions announces a new release of: “Hopper – a Stored Code Debugger” |
Hopper is a Stored Routine and Trigger Debugger, available for Firebird, InterBase and MySQL.
For more information and a trial download, see the news @ Upscene Productions, pricing information is available.
You like this news? Twitter it! Share it! If you’d like to blog about it, contact us!
PyFirebirdSQL 0.7 pure Python driver is released with events support
The changelog includes many patches for events support.
Here is the download page.
You can also use pip to install the package
sudo pip install firebirdsql
An ODBC driver for Firebird on MacOSX
Via Paul Beach Blog
I was recently contacted by a Firebird user on MacOSX who was trying to get the Firebird ODBC driver to build on MacOSX. I thought I would try and step in to help.
For those of you who follow the CVS checkins for OdbcJdbc you might have noticed the addition of a number of a new directory in the Builds directory called Gcc.darwin containing a makefile, a readme and a .sh file to create a lipo’ed dylib. The driver sucessfully builds and passes some simple tests. Feel free to contact me for a copy of the dylib to test further.
The readme contains the following information
Firebird Data Wizard 12.6 released
|
SQL Maestro Group announces the release of Firebird Data Wizard 12.6, a powerful Windows GUI utility for Firebird data management. |
Firebird Data Wizard provides you with a number of easy-to-use wizards to convert any ADO-compatible database to the Firebird database, import data into
Firebird tables, export data from tables, views and queries to most popular file formats as well as generate data-driven ASP.NET pages for your Firebird database.
New version introduces SQL Dump wizard, user-defined data type mappings, auto arranging target tables by dependencies and lots of other new features.
There are also other useful things as well as versions for other DBMS (MySQL, Oracle, SQL Server, DB2, PostgreSQL, etc). Read full press release.
Dozens of new options for Firebird and .NET Framework
Hey!
If you have ever worked with Firebird or Interbase using the standard .NET provider for OLE DB (System.Data.OleDb), you will have likely encountered issues like this:
- The necessity to add ALL parameters manually.
- Even though the OLE DB provider supports parameter generation for commands, the .NET provider doesn’t use it, so you as the programmer must do that work on your own.
- The lack of support for named parameters. Although they actually exist, using them in reality requires a whole set of complex manipulations (the steps needed to add a parameter to a collection, etc.).
- The impossibility of using multiple DataReader objects at the same time (Multiple Active Result Sets).
- No execution of SQL scripts which contain several SQL expressions per command.
This list of difficulties a .NET developer has to deal with is far from complete.
Now it’s all different in a fundamentally new ADO.NET Data Provider for OLE DB
IBProvider Team
