Is there a way to use EclipseLink with Firebird.
We are developing an RCP application with firebird as dbms and we want to use JPA.
EclipseLink seems to be the best solution (osgi support), but I didn't manage to get it working with Firebird.
I've got this error :
Exception Description: NUM_ID_XXXX: platform DatabasePlatform doesn't support NativeSequence.
at org.eclipse.persistence.exceptions.ValidationException.platf ormDoesNotSupportSequence(ValidationException.java:1864)
I know firebird isn't in the list of supported database, but is there a way to use it anyway ?
The same Entity with the same annotation works well with hibernate, but hibernate support Firebird.
Is there a plan to support firebird in EclipseLink soon ?
Although there is not yet a Firebird platform it is generally very easy to
extend support to different databases. I recommend taking a look at the
current platforms (specifically PostgreSQLPlatform or Oracle ) and see
what modifications you can make to create a Firebird platform. Then open
a bug and contribute it back. Generally only keywords need to translated
to the new platform.
If you were to switch to table sequencing you may find that
DatabasePlatform does provide you with all you need.
James a écrit :
> You can switch to using TABLE sequencing to avoid the issue on
> Firebird. I would never recommend IDENTITY sequencing anyway as it does
> not support preallocation which can be a major performance issue.
> You could also create your own DatabasePlatform subclass for Firebird in
> EclipseLink, (if you do please submit it to the project).
> Please log a bug for adding Firebird support.
> -- James