Eclipse Community Forums: EclipseLink » EclipseLink and Firebird

Help

Home

Home » Eclipse Projects » EclipseLink » EclipseLink and Firebird

Show: Today's Messages :: Show Polls :: Message Navigator

EclipseLink and Firebird [message #379268]

Wed, 13 August 2008 04:48

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.

Report message to a moderator

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

Wed, 13 August 2008 10:05

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

Report message to a moderator

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

Wed, 13 August 2008 10:07

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

Report message to a moderator

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

Thu, 14 August 2008 03:44

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 18:08:47 EDT 2013