Best tools for new Java XML SQL app [message #655621] |
Mon, 21 February 2011 20:10  |
Eclipse User |
|
|
|
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  |
Eclipse User |
|
|
|
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
>
|
|
|
Powered by
FUDForum. Page generated in 0.03704 seconds