Connect command
Derby Tools and Utilities Guide
35
ij> next menuCursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6
ij> close menuCursor;
ij>
Commit command
Syntax
COMMIT
Description
Issues a java.sql.Connection.commit request. Use this command only if auto-commit is
off. A java.sql.Connection.commit request commits the currently active transaction and
initiates a new transaction.
Example
ij> commit;
ij>
Connect command
Syntax
CONNECT ConnectionURLString [ PROTOCOL Identifier ]
[ AS Identifier ] [ USER String
PASSWORD String ]
Description
Connects to the database indicated by the ConnectionURLString. Specifically, takes the
value of the string (the database connection URL) and issues a
getConnection
request
using
java.sql.DriverManager
or a
javax.sql.DataSource
implementation (see
property) to set the current connection to that database connection
URL.
You have the option of specifying a name for your connection. Use the
command to switch between connections. If you do not name a connection, the system
generates a name automatically.
You also have the option of specifying a named protocol previously created with the
command or the
property.
If the connection requires a user name and password, supply those with the optional user
and password parameters.
If the connect succeeds, the connection becomes the current one and ij displays a new
prompt for the next command to be entered. If you have more than one open connection,
the name of the connection appears in the prompt.
All further commands are processed against the new, current connection.
Examples
ij> connect 'jdbc:derby:menuDB;create=true';
ij> -- we create a new table in menuDB:
CREATE TABLE menu(course CHAR(10), item CHAR(20), price INTEGER);
ij> protocol 'jdbc:derby:';
ij> connect 'sample' as sample1;
ij(SAMPLE1)> connect 'newDB;create=true' as newDB;
