Jaybird undocumented tip : Is there any way to set socket timeouts?

Is there any way to set socket timeouts?
Roman Rokytskyy answered :

-Yes, the property is called so_timeout and is directly passed when the socket is opened (see Socket.setSoTimeout documentation). You can append the property to the JDBC URL after question mark:

jdbc:firebirdsql:myhost/3050:/path/to/db.fdb?so_timeout=12345

– I have added this feature on request for some very special case. In general you don’t need this property, since the server is not supposed to crash and the network is not supposed to break as well, at least not for database applications. So, the solution is to solve the crash, not to add a workaround for it.

ps: soon it will be added to documentation

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Beta version of Jaybird 2.2 released with support for jdbc 4.1

The Firebird JDBC team is happy to announce the release of Jaybird 2.2.0
beta-1.

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

Downloads are available from:
https://sourceforge.net/projects/firebird/files/firebird-jca-jdbc-driver/

The beta release is also available on maven(*):
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdkXX</artifactId>
<version>2.2.0-beta-1</version>

The artifactId depends on your target Java version: jaybird-jdk15,
jaybird-jdk16 or jaybird-jdk17

Problems, bugs: please mail us on the Firebird-Java group or add a
ticket to the tracker on http://tracker.firebirdsql.org/browse/JDBC

*) As this is the first release to Maven and we need manual
authorization from Sonatype, it can take several days before the
artifacts are really available on Maven

Mark Rotteveel

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Jaybird 2.2 beta hopefully will be released this weekend with jdbc 3.0 and open/libre office support

News via Mark Rotteveel on twitter

Finishing touches to Jaybird 2.2 beta releasenotes, hopefully I will be able to finally release it this weekend

ps:
Jaybird 2.2 is the next Firebird jdbc driver release with many fixes which will include improved support of the JTA specification (XADataSource and XAResource interfaces). Additionally it already has improved support for OpenOffice.org/LibreOffice Base component, which deviates in some places from the JDBC 3.0 specification.

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Firebird usage with SchemaSpy – Java based Graphical Database Schema Metadata Browser

On devshed firebird forum someone asked if anyone used SchemaSpy with firebird , and later he got it working , here is the command line option (after installing jaybird.jar)
1) Download the ZIP file for jaybird
2) unzip it
3) Copy the file jaybird-full-2.1.6.jar into a convenient directory
4) specify the full path to the .jar file when starting schema spy

java -jar /home/java/schemaSpy_5.0.0.jar -t firebird -db /var/lib/firebird/2.1/data/employee.fdb -s schema -u SYSDBA -p ******* -o /home/firebird/ -port 3050 -host localhost -dp /home/user/jaybird-full-2.1.6.jar

ps:that is a single line

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading...

A new release of the Firebird Eclipse plugin is available

A new release of the Firebird Eclipse plugin is available on
http://www.lawinegevaar.nl/firebird

Version 1.0.1.200907101543

Bugfix and ‘less-is-more’ release

Changes:
* Code cleanup
* More delegation to standard DTP implementation
* Sourcecode added to distribution

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
1 2 3 4