This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes dynamically create tables 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 "dynamically create tables" Watch "dynamically create tables" New topic
Author

dynamically create tables

Anish Kuti
Greenhorn

Joined: May 12, 2008
Posts: 29

We have a requirement to dynamically create tables…any suggestions on how it can be done?


We will have attributes for a table input by the user on a portal (java). These attribute will be used to form the DDL query and then that would be executed.

Also, I heard that there will be issues if the DDL statements are executed from JDBC connection.

Please help.

Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


Also, I heard that there will be issues if the DDL statements are executed from JDBC connection.

I'd ask whoever told you this what issues they mean. As far as JDBC is concerned there is little difference between DDL and DML.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: dynamically create tables