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
Post a Comment