Eclipse Community Forums: EclipseLink » EclipseLink and Firebird

Home » Eclipse Projects » EclipseLink » EclipseLink and Firebird

EclipseLink and Firebird [message #379268]

Wed, 13 August 2008 04:48

Eclipse User

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 ?

Thanks for your help.

Re: EclipseLink and Firebird [message #379271 is a reply to message #379268]

Wed, 13 August 2008 10:05

Eclipse User

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.
--Gordon

Re: EclipseLink and Firebird [message #379272 is a reply to message #379268]

Wed, 13 August 2008 10:07

Eclipse User

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

Re: EclipseLink and Firebird [message #379276 is a reply to message #379272]

Thu, 14 August 2008 03:44

Eclipse User

Thank you for your answer,
I'll try to create my own DatabasePlatform subclass and if I get it working, I'll contribute it back.
I haven't got enough time now, but I'll try to do it.

Bugzilla link:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=244125

Nicolas

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
>
>

Previous Topic:	Dynamic fetch plan with navigations
Next Topic:	Query parser class

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Sep 19 00:10:55 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter