Hi Richard,
thank you for your interest in Castor. According to your
questions I need to explain the background of Castor a bit.
Castor does not support transformation of XML <=> RDBMS from
scratch. Instead it consists of an XML and an database part
which are closely coupled. For what you want to achive you
will need both of them.
The XML part maps XML documents into Java objects and vice
versa. For this transformation Castor offers 3 posibilities:
- introspection without additional information
you only need the Java objects that correspond to your XML
document
- with additional information provided in a mapping file
that describes how to translate elements and attributes
from XML into Java objects and their properties
- Java classes generated out of XSD
The database (JDO) part maps Java objects into RDMS and vice
versa. To allow this transformation it needs additional
information from a mapping file.
In general you would need to write some generic code to
get the XML <=> RDBMS translation to work. Depending on
what you really want to achive there are different ways on
how to write/generate the Java classes and mapping files
needed.
Regards
Ralf
Castor JDO, committer
===========================================================
OS environment: Windows X Linux X Solaris X Irix X
Other: every OS where Java 1.4 is available for
Database Support: Oracle X DB2 X PostgreSQL X mySQL X
Others: Derby, Hypersonic, Informix, InstantDB,
SAP DB, MaxDB, Microsoft SQL Server,
Sybase, Borland Pointbase
___________________________________________________________
CREATE
Can create XML documents from RDBMS tables? Yes X No
Can create RDBMS schema from XML page? Yes No X
Can create XSD document from RDBMS schema? Yes No X
Can create RDBMS schema from XSD document? Yes No X
COMMENTS:
We intend to add support for creating RDBMS schema from
mapping file.
_____________________________________________________________
INSERT
Can insert from XML data to RDBMS? Yes X No
COMMENTS:
_____________________________________________________________
EXTRACT
Can extract from RDBMS to XML data? Yes X No
COMMENTS:
_____________________________________________________________
QUERY
What Languages are supported? SQL X XPATH XQUERY
Can create XML document from RDBMS query? Yes X No
COMMENTS:
At the moment we support a proprietary OQL syntax and
passthrough SQL statments. We have concret plans to support
OQL syntax of EJB3 specification soon.
_____________________________________________________________
CODE GENERATION
Supports code generation of parsing code? Yes X No
Languages: Java _X_ C++ ___ C#___ Other___
Supports code generation of database insert code? Yes No
Languages: Java ___ C++ ___ C#___ Other___
Supports code generation of database extraction code? Yes No
Languages: Java ___ C++ ___ C#___ Other___
Supports code generation of database query code? Yes No
Languages: Java ___ C++ ___ C#___ Other___
COMMENTS:
Castor internaly generates insertion/extraction/selection
statements from the information provided in mapping file.
____________________________________________________________
DELETION/UPDATE
Can the tool modify/update data in the RDBMS according to XML document
change? Yes X No
Can the tool modify RDBMS structure automatically to account for XSD
deletions/modifications? Yes No X
Can the tool modify XSD structure automatically to account for RDBMS
structure change? Yes No X
COMMENTS:
_____________________________________________________________
Liu, Richard schrieb:
Hi,
I just join this user list and I have a few general questions to ask.
We basically look for a tool which can do xml<==>RDBMS bidirectional
mapping and code generation. By reading castor website, it seems that
"JDO" can do most of it.
Can anybody answer the following general questions for me?
Thanks a lot.
Richard Liu
Software Engineer at Boeing
========================================================================
==========================================
OS environment: Windows Linux Solaris Irix
Other:
Database Support: Oracle DB2 PostgreSQL mySQL
Others:
___________________________________________________________
CREATE
Can create XML documents from RDBMS tables? Yes No
Can create RDBMS schema from XML page? Yes No
Can create XSD document from RDBMS schema? Yes No
Can create RDBMS schema from XSD document? Yes No
COMMENTS:
_____________________________________________________________
INSERT
Can insert from XML data to RDBMS? Yes No
COMMENTS:
_____________________________________________________________
EXTRACT
Can extract from RDBMS to XML data? Yes No
COMMENTS:
_____________________________________________________________
QUERY
What Languages are supported? SQL XPATH XQUERY
Can create XML document from RDBMS query? Yes No
COMMENTS:
_____________________________________________________________
CODE GENERATION
Supports code generation of parsing code? Yes No
Languages: Java ___ C++ ___ C#___ Other___
Supports code generation of database insert code? Yes No
Languages: Java ___ C++ ___ C#___ Other___
Supports code generation of database extraction code? Yes No
Languages: Java ___ C++ ___ C#___ Other___
Supports code generation of database query code? Yes No
Languages: Java ___ C++ ___ C#___ Other___
COMMENTS:
____________________________________________________________
DELETION/UPDATE
Can the tool modify/update data in the RDBMS according to XML document
change? Yes No
Can the tool modify RDBMS structure automatically to account for XSD
deletions/modifications? Yes No
Can the tool modify XSD structure automatically to account for RDBMS
structure change? Yes No
COMMENTS:
_____________________________________________________________
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
