Cart
[Home] [By Thread] [By Date] [Recent Entries]
>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
|
