News via twitter Mark Rotteveel
Updating releasenotes for Jaybird 2.2.1, and if testing goes OK, I will probably release next week.
Also don’t forget
Do you use Jaybird in your applications? Fill out our survey: http://infopoll.net/live/surveys/s36021.htm
News from Mark Rotteveel : The Jaybird code repository has been migrated from CVS to Subversion.
The code is now available from
https://svn.code.sf.net/p/firebird/code/client-java/
It can also be viewed from
https://sourceforge.net/p/firebird/code/HEAD/tree/client-java/
.
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
Web-based Squirrel SQL client. It allows you to view database structure, import/export and manage your databases, including create database, table, store procedure, view,trigger and user. it supports Firebird
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
Here is the Jaspersoft configuration howto guide with screenshots (in Portuguese)
Hello,I’ve created in Hebrew few tips on how to work with JayBird in Java and JRuby using Firebird. Links for the (google) translated versions:
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
JbConsole is a Firebird console tool. I have tested with Jython 2.5b3 and Jaybird 2.1.6 .
(java 1.6 on Windows XP and java 1.5 on OS X 10.5)
It’s still toy level, but it seems to be sample implementation of Jaybird and Jython.
http://www005.upp.so-net.ne.jp/nakagami/Download/JbConsole_0_2_0.zip
See the screen shot
http://nakagami.blog.so-net.ne.jp/2009-02-09
ED:Translated with google , I like his words about Jython
Swing and Java (JVM) I fast. 驚いた。 I was surprised.
