|
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: 33107 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
>
Ed Merks
Professional Support: https://www.macromodeling.com/
|
|
|
Powered by
FUDForum. Page generated in 0.01975 seconds