Derby

ii  sun-javadb-client      10.3.2.1-0ubuntu2       Java DB client
ii  sun-javadb-common      10.3.2.1-0ubuntu2       Java DB common files
ii  sun-javadb-core        10.3.2.1-0ubuntu2       Java DB core
サーバーの起動
export DERBY_HOME=/usr/share/javadb
export PATH="$DERBY_HOME/bin:$PATH"
export LANG=C
startNetworkServer
クライアント
export DERBY_HOME=/usr/share/javadb
export PATH="$DERBY_HOME/bin:$PATH"
ij
スタンドアローン
    CONNECT 'jdbc:derby:/var/tmp/derby/firstdb;create=true';

    CREATE TABLE FIRSTTABLE (ID INT PRIMARY KEY,NAME VARCHAR(12));

    INSERT INTO FIRSTTABLE VALUES
    (10,'TEN'),(20,'TWENTY'),(30,'THIRTY'),(40,'FORTY');

    SELECT * FROM FIRSTTABLE;

    exit;

    CONNECT 'jdbc:derby:/var/tmp/derby/firstdb;';

    SELECT * FROM FIRSTTABLE;

    drop table FIRSTTABLE;

    String user = "APP";
    String password = "user1";
    String database = "/var/tmp/derby/cities";
ネットワーク
    connect 'jdbc:derby://localhost:1527/city_aaa';

    user APP
    password user1

Python


Java

java.security.AccessControlException:
access denied (java.net.SocketPermission 127.0.0.1:1527 connect,resolve)

/etc/java-7-openjdk/security/java.policy
grant {
    permission java.net.SocketPermission "localhost:1527", "listen";
};

Arch Linux
$ yaourt -Sb java-derby
$ yaourt -Sb derby

起動

$ /usr/share/java/derby/bin/startNetworkServer

result_aa

outarea_aa
outarea_bb
outarea_cc
outarea_dd
outarea_ee
outarea_ff
outarea_gg
outarea_hh

Return

May/09/2023 AM 08:15