Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » Modeling (top-level project) » [EMF] How to persist to SQL/RDBMS/JDBC?
[EMF] How to persist to SQL/RDBMS/JDBC? [message #655625] Mon, 21 February 2011 21:14 Go to next message
Mike Cooper is currently offline Mike Cooper
Messages: 45
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
Re: [EMF] How to persist to SQL/RDBMS/JDBC? [message #655641 is a reply to message #655625] Tue, 22 February 2011 01:05 Go to previous messageGo to next message
Ed Merks is currently offline Ed Merks
Messages: 25925
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
>
Re: [EMF] How to persist to SQL/RDBMS/JDBC? [message #655642 is a reply to message #655625] Tue, 22 February 2011 01:25 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5482
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
Re: [EMF] How to persist to SQL/RDBMS/JDBC? [message #655833 is a reply to message #655642] Tue, 22 February 2011 13:40 Go to previous message
Mike Cooper is currently offline Mike Cooper
Messages: 45
Registered: February 2011
Member
Thanks for the suggestions!

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


Current Time: Mon Jul 28 08:34:11 EDT 2014

Powered by FUDForum. Page generated in 0.02513 seconds