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]

Tue, 22 February 2011 02:14

Mike Cooper

Messages: 60
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 06:05

Ed Merks

Messages: 31907
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
>

Ed Merks
Professional Support: https://www.macromodeling.com/

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 06:25

Eike Stepper

Messages: 6579
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

Cheers
/Eike

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

Report message to a moderator