Eclipse Community Forums: EMF "Technology" (Ecore Tools, EMFatic, etc) » Import Export of XML files in database from GMF or other

Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » Import Export of XML files in database from GMF or other

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

Import Export of XML files in database from GMF or other [message #107380]

Thu, 17 January 2008 13:53

Eclipse User

Originally posted by: frederic.ventura.eurogiciel.fr

Hi every body

I've just obtained a working GMF plugin working on a database (using
GMF/teneo/hibernate) and I have to had a new function
I would like to know if it already exists something to do this.
my goal is to import datas from xml files into my database.
for example:
my diagram is composed of a championship
my championship contains several matches
each match is composed of a 2 team
a team is composed of several players

I can create in my GMF diagram instance of championship, match, team and
player.
I can receave xml files (one xml file for each kind of class)
I have to import each file in my GMF diagram.

Such a tool already exist or is it necesary to develop it?

thanks by advance
fred

Report message to a moderator

Re: Import Export of XML files in database from GMF or other [message #107450 is a reply to message #107380]

Thu, 17 January 2008 14:15

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Hi Fred,
The HbDataStore has a simple method to do this, here is the method body (which is probably too
simple for most uses):
if (importFormat == HbConstants.EXCHANGE_FORMAT_XML) {
importResource = new XMLResourceImpl();
} else {
importResource = new XMIResourceImpl();
}

final HibernateResource hibResource = new HibernateResource(URI.createFileURI("." + name));

try {
importResource.load(is, Collections.EMPTY_MAP);
hibResource.getContents().addAll(importResource.getContents( ));
hibResource.save(Collections.EMPTY_MAP);
} catch (IOException e) {
throw new HbMapperException("Exception when importing " + name, e);
}

When the objects in the xml file update objects in the database then the id and version of the
objects also needs to be present as efeatures in the xml. Otherwise Hibernate will think that the
objects from the xml file are always new and create new records instead of updating the db.
See also here (this is client-server related but also applies here):
http://www.elver.org/hibernate/hibernate_details.html#Client -Server+scenario%3A+requires+explicitly+modelled+id+and+vers ion+properties

gr. Martin

fred wrote:
> Hi every body
>
> I've just obtained a working GMF plugin working on a database (using
> GMF/teneo/hibernate) and I have to had a new function
> I would like to know if it already exists something to do this.
> my goal is to import datas from xml files into my database.
> for example:
> my diagram is composed of a championship
> my championship contains several matches
> each match is composed of a 2 team
> a team is composed of several players
>
> I can create in my GMF diagram instance of championship, match, team and
> player.
> I can receave xml files (one xml file for each kind of class)
> I have to import each file in my GMF diagram.
>
> Such a tool already exist or is it necesary to develop it?
>
> thanks by advance
> fred
>

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org

Report message to a moderator