Using JPA with Firebird Sql

Today we started on new project , tha base platform was Java with the Eclipse Helios using ZK and JPA frameworks. For JDBC there was no problem, it is simple usinig the version provided directly by firebirdsql.org at http://www.firebirdsql.org/index.php?op=files&id=jaybird but when we have tried to connect via JPA we didn’t able to acquire the DB schema.
This mainly because the firebird dialect was not implemented into the DTP ( Eclipse Data Tools Platform) provided by the develpment environment. To address this problem we found an implementation of Firebird DTP Plugin (it seems working) at http://www.lawinegevaar.nl/firebird.

The plugin installation is very simple: download the last version (nowadays 1.0.1) and extract the jars directly in the eclipse/plugin folder.

Alt text for the image, e.g. “The Mona Lisa”

Restart Eclipse and voilà: the new Firebird connection profile type is available.

rgds
ivan