Groups > comp.lang.java.programmer > #7996

Re: xsd to database schema...

Path	csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!news.glorb.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date	Tue, 13 Sep 2011 20:12:03 -0400
From	Arne Vajhøj <arne@vajhoej.dk>
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version	1.0
Newsgroups	comp.lang.java.programmer
Subject	Re: xsd to database schema...
References	<j4o4ci$ddo$1@speranza.aioe.org>
In-Reply-To	<j4o4ci$ddo$1@speranza.aioe.org>
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
Lines	20
Message-ID	<4e6ff155$0$315$14726298@news.sunsite.dk> (permalink)
Organization	SunSITE.dk - Supporting Open source
NNTP-Posting-Host	72.192.23.141
X-Trace	news.sunsite.dk DXC=7f^\_M3AlCMLCYW^HlPiL@YSB=nbEKnkK4ang]8e?Co@JPe3\kP5EUAKBm9cfh9BSDM2;kT<[:>[AofWVh77FEMDTO:f=BK=LjJ
X-Complaints-To	staff@sunsite.dk
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.programmer:7996

Show key headers only | View raw

On 9/13/2011 1:38 PM, boris wrote:
> can anyone recommend java tool to convert xsd to database schema?

Note that some schemas may be very difficult to map to a
relational database, but let us assume they are "nice".

I would try to do XSD->Java->SQL.

XSD->Java can be done with JAXB.

I believe you can find something for Java->SQL.

A quick googling found the following potential:

http://openjpa.apache.org/builds/latest/docs/manual/manual.html#ref_guide_ddl_examples
http://docs.codehaus.org/display/CASTOR/Using+DDL+Generator

Arne

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

xsd to database schema... boris <boris@localhost.localdomain> - 2011-09-13 13:38 -0400
  Re: xsd to database schema... Jeff Higgins <jeff@invalid.invalid> - 2011-09-13 15:16 -0400
  Re: xsd to database schema... Arne Vajhøj <arne@vajhoej.dk> - 2011-09-13 20:12 -0400
  Re: xsd to database schema... "John B. Matthews" <nospam@nospam.invalid> - 2011-09-13 21:45 -0400
  Re: xsd to database schema... Roedy Green <see_website@mindprod.com.invalid> - 2011-09-14 14:57 -0700

csiph-web