Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » Modeling (top-level project) » Best tools for new Java XML SQL app
Best tools for new Java XML SQL app [message #655621] Tue, 22 February 2011 01:10 Go to next message
Mike Cooper is currently offline Mike CooperFriend
Messages: 46
Registered: February 2011
Member
Hi Folks,

We are developing our first large Java app which will have an sql database backend. The app will need to exchange data via xml due to the nature of the client implementations.

We are trying to decide the best tool and model to use which will provide the following:

1) Take a data model defined in some format (XML, Ecode, etc) and auto generate Java classes and XML (using JAXB is fine if we can get the generator to create XSD).

2) Take the data model and sync an SQL schema with the database (MySQL to start with, but later will support MS SQL and Oracle DB).

We are considering Eclipse Modeling Framework (EMF). There is mention of being able to persist to SQL but we haven't found any specifics on this. This is frankly our biggest question on EMF right now.

We also have our own in-house code generator from an older project. It doesn't do any SQL, but we could fix that with some work. It also falls short in many areas vs. EMF especially with notification of changes.

Suggestions and feedback would be most welcomed.

mike
Re: Best tools for new Java XML SQL app [message #655634 is a reply to message #655621] Tue, 22 February 2011 03:25 Go to previous message
Ed Merks is currently offline Ed MerksFriend
Messages: 26278
Registered: July 2009
Senior Member
Mike,

Comments below.


mcooper@magnicomp.com wrote:
> Hi Folks,
>
> We are developing our first large Java app which will have an sql
> database backend. The app will need to exchange data via xml due to
> the nature of the client implementations.
>
> We are trying to decide the best tool and model to use which will
> provide the following:
>
> 1) Take a data model defined in some format (XML, Ecode, etc) and auto
> generate Java classes and XML (using JAXB is fine if we can get the
> generator to create XSD).
EMF can do that too.
>
> 2) Take the data model and sync an SQL schema with the database (MySQL
> to start with, but later will support MS SQL and Oracle DB).
Teneo or CDO could help with that.
>
> We are considering Eclipse Modeling Framework (EMF). There is mention
> of being able to persist to SQL but we haven't found any specifics on
> this. This is frankly our biggest question on EMF right now.
Should should read up on Teneo then.
>
> We also have our own in-house code generator from an older project.
> It doesn't do any SQL, but we could fix that with some work. It also
> falls short in many areas vs. EMF especially with notification of
> changes.
>
> Suggestions and feedback would be most welcomed.
>
> mike
>
Previous Topic:Different output model directories for interfaces, impls, etc?
Next Topic:[EMF] How to persist to SQL/RDBMS/JDBC?
Goto Forum:
  


Current Time: Thu Dec 18 04:15:37 GMT 2014

Powered by FUDForum. Page generated in 0.12442 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software