File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Java Program to Convert Oracle database to a single SQL file. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java Program to Convert Oracle database to a single SQL file." Watch "Java Program to Convert Oracle database to a single SQL file." New topic
Author

Java Program to Convert Oracle database to a single SQL file.

Karthik Sanghvi
Greenhorn

Joined: Nov 06, 2006
Posts: 9

Does anybody has idea of a java program that converts a oracle database(with multiple tables) to one single XML document?
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3860

I'm not sure it's possible to get all in to a one file, even if you could how you going to use it... Perhaps you may tell us the exact intention of doing this?


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Karthik Sanghvi
Greenhorn

Joined: Nov 06, 2006
Posts: 9
There are few tools that convert sql tables to a single XML file.
My database may not big as big as 4-5 tables, but I want to produce a program
that can flatten tables and convert them to a XML file (or store them in a XML file)

I do not have any dependencies as each of the tables are independent.

Thanks
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Check dbtamer in my signature, it already reads and writes to an sql file, you can just modify to create a custom xml output.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2516
    
  10

"Basic Thogonomix", please check your private messages for an administrative matter.


OCUP UML fundamental and ITIL foundation
youtube channel
Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

look at XStream API .


Save India From Corruption - Anna Hazare.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Program to Convert Oracle database to a single SQL file.