Is there a standard JDBC means of creating a database?

Joe Sam Shirah

No, because there is no SQL standard method. The basis is mostly historical, because almost every DBMS uses a different syntax and arguments and often requires special permissions. In my JDBC 2.0 Fundamentals Short Course, for example, the Cloudscape database was created with a JDBC driver URL attribute, while DB2 on NT used CREATE DATABASE and AS/400 DB2 used CREATE COLLECTION.

If you want to use a DBMS specific means and are willing to account for ( or trade off ) portability, it is potentially possible to achieve it with JDBC. See: Can I use JDBC to execute non-standard features that my DBMS provides?

0 Comments  (click to add your comment)
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

About | Sitemap | Contact