Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » EclipseLink and Firebird
EclipseLink and Firebird [message #379268] Wed, 13 August 2008 04:48 Go to next message
Nicolas Mura is currently offline Nicolas Mura
Messages: 24
Registered: July 2009
Junior Member
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 Go to previous messageGo to next message
Gordon Yorke is currently offline Gordon Yorke
Messages: 77
Registered: July 2009
Member
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 Go to previous messageGo to next message
James is currently offline James
Messages: 272
Registered: July 2009
Senior Member
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 Go to previous message
Nicolas Mura is currently offline Nicolas Mura
Messages: 24
Registered: July 2009
Junior Member
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:
  


Current Time: Sat Aug 23 07:32:00 EDT 2014

Powered by FUDForum. Page generated in 0.05256 seconds