Eclipse Community Forums: Modeling (top-level project) » [EMF] How to persist to SQL/RDBMS/JDBC?

Help

Home

Home » Modeling » Modeling (top-level project) » [EMF] How to persist to SQL/RDBMS/JDBC?

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

[EMF] How to persist to SQL/RDBMS/JDBC? [message #655625]

Mon, 21 February 2011 21:14

Mike Cooper
Messages: 39
Registered: February 2011

Member

We are new to EMF (obviously Smile

). We are considering using EMF for a new app which needs to use an SQL backend for persistence.

We need some pointers on how to do the persistence in EMF to SQL/JDBC. The docs we have seen (including the EMF 2009 book) all talk about XML for persistence. No mention of how to use SQL/JDBC. Is there an existing URI and Resource class which support SQL/JDBC? If not, anybody have suggestions on how to implement?

Thanks.
mike

Report message to a moderator

Re: [EMF] How to persist to SQL/RDBMS/JDBC? [message #655641 is a reply to message #655625]

Tue, 22 February 2011 01:05

Ed Merks
Messages: 24540
Registered: July 2009

Senior Member

Mike,

Looking into Teneo and ask follow-up questions about in in the
eclipse.tools.emf newsgroup/forum.

Mike wrote:
> We are new to EMF (obviously :) ). We are considering using EMF for a
> new app which needs to use an SQL backend for persistence.
> We need some pointers on how to do the persistence in EMF to
> SQL/JDBC. The docs we have seen (including the EMF 2009 book) all
> talk about XML for persistence. No mention of how to use SQL/JDBC.
> Is there an existing URI and Resource class which support SQL/JDBC?
> If not, anybody have suggestions on how to implement?
>
> Thanks.
> mike
>

Report message to a moderator

Re: [EMF] How to persist to SQL/RDBMS/JDBC? [message #655642 is a reply to message #655625]

Tue, 22 February 2011 01:25

Eike Stepper
Messages: 5153
Registered: July 2009

Senior Member

Am 22.02.2011 03:14, schrieb Mike:
> We are new to EMF (obviously :) ). We are considering using EMF for a new app which needs to use an SQL backend for persistence.
> We need some pointers on how to do the persistence in EMF to SQL/JDBC. The docs we have seen (including the EMF 2009 book) all talk about XML for persistence. No mention of how to use SQL/JDBC. Is there an existing URI and Resource class which support SQL/JDBC? If not, anybody have suggestions on how to implement?

You may want to try CDO, which is a 3 tier architecture for modeled applications, a model repository and arbitrary data backends (including support for O/R mapping):

http://wiki.eclipse.org/CDO
http://www.eclipse.org/cdo

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: [EMF] How to persist to SQL/RDBMS/JDBC? [message #655833 is a reply to message #655642]

Tue, 22 February 2011 13:40

Mike Cooper
Messages: 39
Registered: February 2011

Member

Thanks for the suggestions!

mike

Report message to a moderator

Previous Topic:	Best tools for new Java XML SQL app
Next Topic:	Referencing Ecore to Support ORM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 10:24:57 EDT 2013