File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes XML and Related Technologies and the fly likes Convertion of xml file to sql file. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Convertion of xml file to sql file." Watch "Convertion of xml file to sql file." New topic

Convertion of xml file to sql file.

gowtham thurangi

Joined: Apr 05, 2011
Posts: 13

Hi All,

I have a xml file with data. I want to convert it into sql file using java. so that i can use that sql file for further cases.Please Reply...

William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 12759
The ServingXML toolkit has utilities like that.

"Please Reply" Why did you think that necessary?

gowtham thurangi

Joined: Apr 05, 2011
Posts: 13


Actually in my project, we convert the data from text files to xml file and after that we are inserting into database. But in between i need to get the sql file so that it can be useful like backups.
In sql file we need to maintain data and sql query. of that particular table. I have sql server database, Iam getting sql file from database backup. But i need while inserting into database.

Please Help me.

Paul Clapham

Joined: Oct 14, 2005
Posts: 18541

Well, that didn't sound anything like your original post. Actually I didn't understand it at all. But I think that's because I don't understand what you mean when you say "the sql file". What exactly is an "SQL file" anyway?
I agree. Here's the link:
subject: Convertion of xml file to sql file.
Similar Threads
Java Program to Convert Oracle database to a single SQL file.
SQL in properties file
very basic questions
sql query stored in the xml, parsed and executed from java - throws malformed exception
SQL Statements in XML document