Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Finding matching column name Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Finding matching column name" Watch "Finding matching column name" New topic

Finding matching column name

R Singh

Joined: Mar 07, 2002
Posts: 4
I have an XML schema having elements to be matched with database table columns. I am using jdbc to find table and column information from a given databse.
How do I search tables/columns to dynamically match the element names with corresponding column names in tables. I understand that if it was a select command, one could use soundex function.
Thanks in advance. Please help ASAP.

Rodney Woodruff
Ranch Hand

Joined: Dec 04, 2001
Posts: 80
Are you trying to insert the data from the xml file into database?

Hope This Helps
It is sorta covered in the JavaRanch Style Guide.
subject: Finding matching column name