Eclipse Community Forums: Modeling (top-level project) » Best tools for new Java XML SQL app

Help

Home

Home » Modeling » Modeling (top-level project) » Best tools for new Java XML SQL app

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

Best tools for new Java XML SQL app [message #655621]

Tue, 22 February 2011 01:10

Mike Cooper

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

Report message to a moderator

Re: Best tools for new Java XML SQL app [message #655634 is a reply to message #655621]

Tue, 22 February 2011 03:25

Ed Merks

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

Report message to a moderator

Previous Topic:	Different output model directories for interfaces, impls, etc?
Next Topic:	[EMF] How to persist to SQL/RDBMS/JDBC?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 20 05:38:36 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter