Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Karthik Sanghvi
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Does anybody has idea of a java program that converts a oracle database(with multiple tables) to one single XML document?
 
Vijitha Kumara
Bartender
Posts: 3913
9
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Karthik Sanghvi
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Basic Thogonomix", please check your private messages for an administrative matter.
 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
look at XStream API .
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic