This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
Don't get me started about those stupid light bulbs.
 
subject: dynamically create tables
 
Similar Threads
Composite Foreign Key mapping
dynamic Array
WAS 5.0 : DDL's not being executed with oracle 9i
JMS Queue Persistence
configuring persistence