[prev in list] [next in list] [prev in thread] [next in thread]
List: xml-dev
Subject: RE: [xml-dev] Oracle and XML
From: "Spenser Kao" <SpenserKao () optusnet ! com ! au>
Date: 2005-06-30 22:50:59
Message-ID: 000c01c57dc6$2f9333e0$3214b286 () spenserlaptop1
[Download RAW message or body]
>Has any one knew how to get XML from an Oracle database table?
Try (a) XSU (XML SQL Utility) [1] for Java getXML, or (b) XSQL [2].
If you got SQL statements ready for porting, option a is pretty
straightforward, as all you need is place it into a java command
something like
java OracleXML getXML -user <username/password> -conn <connection
string> <SQL statement>
The output is purely XML well-formed, therefore to be redirected to a
file if preferred.
For jdk1.2.x, xsu12.jar and JDBC2.x are the environment you need to set
up; otherwise xsu11.jar and JDBC1.x are for jdk1.1.x.
If you only wanted to pick up data from small number of table fields,
then option b can be considered.
Hope this helps.
Spenser Kao
[1]
http://www.stanford.edu/dept/itss/docs/oracle/9i/appdev.920/a96621/adx08
xsu.htm
[2]
http://www.stanford.edu/dept/itss/docs/oracle/9i/appdev.920/a96621/adx09
xsq.htm#1029237
-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS <http://www.oasis-open.org>
The list archives are at http://lists.xml.org/archives/xml-dev/
To subscribe or unsubscribe from this list use the subscription
manager: <http://www.oasis-open.org/mlmanage/index.php>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic