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] Mon, 21 February 2011 20:10 Go to next message
Mike Cooper is currently offline Mike Cooper
Messages: 45
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] Mon, 21 February 2011 22:25 Go to previous message
Ed Merks is currently offline Ed Merks
Messages: 25943
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: Wed Jul 30 07:26:05 EDT 2014

Powered by FUDForum. Page generated in 0.01570 seconds