CREATE DATABASE in Derby by ij

Derby does not require or support a CREATE DATABASE statement. To create a new database, simply append create=true to the connection string. 

If you start ij and run this statement, it automatically creates a new database in the current working directory:

CONNECT 'jdbc:derby:mydb;create=true';

To create a new database for a running Derby service, include the create option in the connection URL in exactly the same way:

CONNECT 'jdbc:derby://localhost:1527/mydb;create=true';

Or
jdbc:derby://localhost:1527/mydb;create=true;user=myaccount;password=mypasswd

Comments