Meaningless Drivel is fun!*
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
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
 
It is sorta covered in the JavaRanch Style Guide.
 
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