DRIVER ‘org.apache.derby.jdbc.ClientDriver’;
connect ‘jdbc:derby://127.0.0.1:1527/testdb’;

connect ‘jdbc:derby://192.9.208.14:1527/mydb’;
select count(*) from root.t_neox;

select * from SYSCS_DIAG.LOCK_TABLE

select * from SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(’derby.locks.escalationThreshold’, ‘1000′);

connect ‘jdbc:derby://192.9.208.14:1527/testdb;username=temple;password=12345678′;

connect ‘jdbc:derby://192.9.208.14:1527/mydb;username=system;password=12345678′;

connect ‘jdbc:derby://192.9.208.14:1527/mydb’
USER ‘SYSDBA’
PASSWORD ‘SYSDBA’;

– system-wide property
derby.connection.requireAuthentication=true
— database-wide property

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( ‘derby.connection.requireAuthentication’, ‘true’);
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( ‘derby.connection.requireAuthentication’, ‘false’);

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(’derby.database.defaultConnectionMode’,'fullAccess’);

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(’derby.database.fullAccessUsers’, ‘ROOT’);

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( ‘derby.user.temple’, ‘12345678′);

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( ‘derby.database.fullAccessUsers’, ‘temple’);

connect ‘jdbc:derby://192.9.208.14:1527/tdb;create=true;user=temple;password=123′;