[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Oracle and XML

• To: "'Thi Nguyen'" <thichaunguyen@h...>, <xml-dev@l...>
• Subject: RE: Oracle and XML
• From: "Spenser Kao" <SpenserKao@o...>
• Date: Fri, 1 Jul 2005 08:50:59 +1000
• Importance: Normal
• In-reply-to: <BAY103-F16563FC8800429E4B21B40ABE30@p...>

>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

• References:
  • Oracle and XML
    • From: "Thi Nguyen" <thichaunguyen@h...>

• Prev by Date: RE: Oracle and XML
• Previous by thread: RE: Oracle and XML
• Next by thread: Re: Document oriented experience reports anyone?
• Index(es):
  • Date
  • Thread