Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Loading Into Random Table

 
vikram solanki
Greenhorn
Posts: 12
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi All,

I am stuck with a small problem here. This may even sound a little crazy but here it is...
I am trying to load some data into tables. I have the tables created and the data available in an xml. I even have a xml parser that gets me the data from the xml. But the problem is i do not know which coulmn may be present in which table. So is there any way
1. I could load the data into the database with only the column names? (please note that all the tables will have uniqe column names. None of the coulmns will be repeated.)
2. I could find the name of the table in which the column is present and then load the data into the DB.

Please let me know if you have any ideas
Thanks
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could use ResultSetMetaData to learn about the columns. Or in some databases, such as Oracle, you can query another table to see which columns exist.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic