#Java Web-based Squirrel SQL client
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
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.
I was looking for some tutorial about configuring Squirrel SQL (http://squirrel-sql.sourceforge.net/) to connect to firebird database and unfortunately i couldn’t find one . So when i finally managed to connect, i thought of publishing the steps in my log so that it could be useful to some one else.
Configuring Squirrel Sql to connect to firebird was much easier than i thought.
I having been trying to connect (without success) to a Firebird server from OOo 2.3.[ED:but in the end it was solved by using this guide and it was fast too ]
Jaybird 2.1.2 is released. It is a bugfix release that targets two main issues, JDK 6.0 compatibility and support for INSERT…RETURNING statements. More info at the JDBC Driver page.