XML-to-legacy-DBs gateway needed

[Hans-Guenter Stein]

Hi all,

I have to implement a gateway between XML and standard databases like MS
SQL or Informix.

Scenerio:

A Java program (agent) wants to perform a DB query. The query parameters
are specified in form of an XML-document. The agent passes a handle to
this XML-query to the gateway. The gateway parses the XML and translates
it (according to application specific rulesets) into an SQL-statement.
The SQL-statement is send to the DB (e.g. via JDBC driver). The answer
to the query is transalted back to XML (according to another ruleset)
and passed to the agent.

Has anybody done something like that before? Is there a standard way to
implement it (besides the apllication specific translation rules)? If so
please let me know - I just don't want to re-invent the wheel...

Hans-Guenter
--


     Hans-Günter Stein, FAST e.V.

     Arabellastr. 17   | Tel +49-89-920047-55  | mailto:hgs at fast.de
     D-81925 Muenchen  | Fax +49-89-920047-18  | http://www.fast.de/~hgs




xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo at ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo at ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa at ic.ac.uk)